MS Sql Server

August 2004

SQL Object Access Tracking
(31 Aug 2004 23:41:56)
mailing through SQL
(31 Aug 2004 22:9:3)
Help with a script to KILL spids.
(31 Aug 2004 21:23:17)
Re: SUSPECT: RE: mailing through SQL
(31 Aug 2004 14:32:27)
MS DTC
(31 Aug 2004 13:45:59)
Migrate from 6.5 to 7.0
(31 Aug 2004 12:37:12)
UTF-8 format in SQL
(31 Aug 2004 11:17:57)
Linkes Servers
(30 Aug 2004 23:39:40)
Re: using to databases 1 server
(30 Aug 2004 23:39:40)
system stored procedures not replicating to subscriders...........
(30 Aug 2004 23:39:28)
Hi there...I need to backup and restore database from sql 7 to sql 2000
(30 Aug 2004 23:39:28)
Moving DTS Packages...
(30 Aug 2004 22:27:6)
Creating a simple Trigger - I have never used or written one before
(30 Aug 2004 15:34:9)
Replication Validation
(30 Aug 2004 14:45:58)
monitoring log size
(30 Aug 2004 13:45:37)
Re: SUSPECT: mailing through SQL
(30 Aug 2004 13:10:25)
Permission to run CmdExec job steps
(30 Aug 2004 11:33:21)
Table Partioning
(30 Aug 2004 0:5:32)
Query
(30 Aug 2004 0:1:47)
re:using to databases 1 server
(29 Aug 2004 3:57:34)
LISTOWNER- lazydba archive search funtion
(28 Aug 2004 23:33:23)
Help with locks, pauses
(28 Aug 2004 21:59:56)
LISTOWNER- EMAIL SHIELDING
(28 Aug 2004 13:0:2)
SQL Server mem usage spiking after trans. log full...
(28 Aug 2004 10:4:32)
Query question
(28 Aug 2004 7:42:13)
Serious Problem
(28 Aug 2004 7:39:25)
Re: Serious Problem[Scanned]
(28 Aug 2004 7:31:26)
Re: shrinking dilemna[Scanned]
(28 Aug 2004 7:27:46)
Table Dependancies
(28 Aug 2004 7:8:53)
doubt rgding sysname
(28 Aug 2004 6:54:57)
DOMAINS function ... in MSSQL ??? SNOWFLAKEs and STAR schemas
(28 Aug 2004 6:53:18)
Does SQLServer supports many-many relationship?
(28 Aug 2004 6:38:29)
Re: Delete transaction Log[Scanned]
(28 Aug 2004 6:18:57)
Delete transaction Log
(28 Aug 2004 5:57:52)
Date fields getting populated in SQL 2000
(28 Aug 2004 5:40:12)
Database & Application Performance (ODBC)
(28 Aug 2004 5:31:53)
DATA WAREHOUSE
(28 Aug 2004 5:28:43)
configuring pull subscriptions
(28 Aug 2004 5:28:28)
Client-Side V's Server-Side Cursors
(28 Aug 2004 4:15:46)
[mikey:Q] question of BCP
(28 Aug 2004 4:4:57)
logging server events
(27 Aug 2004 20:21:33)
Re: SUSPECT: Table Dependancies
(27 Aug 2004 16:10:59)
Re: Shrinking file.[Scanned]
(27 Aug 2004 15:38:22)
shrinking dilemna
(27 Aug 2004 7:22:0)
Truncate table and indexes
(27 Aug 2004 5:20:16)
Shrinking file.
(27 Aug 2004 1:15:40)
Problem with SqlServerAgent
(26 Aug 2004 23:53:35)
SQL Server - DBA Report
(26 Aug 2004 23:52:49)
Triggers
(26 Aug 2004 23:18:58)
Re: SUSPECT: RE: SUSPECT: ERROR 512
(26 Aug 2004 19:45:5)
SQL Server Full-Text Search Performance Tuning and Optimization
(26 Aug 2004 19:23:2)
What is in a file?
(26 Aug 2004 19:22:42)
Re: SUSPECT: ERROR 512
(26 Aug 2004 19:20:56)
ERROR 512
(26 Aug 2004 19:1:30)
wanna be Oracle DBA, Please suggest good books
(26 Aug 2004 15:37:52)
Large data deletion
(26 Aug 2004 14:2:20)
Full-Text Search
(26 Aug 2004 7:9:29)
Just for fun ...
(26 Aug 2004 6:17:0)
If you think YESTERDAY is funny ... here's a BEWARE when asking the boss for a reference ...
(26 Aug 2004 3:44:53)
Re: SUSPECT: [mikey:Q] question of BCP
(25 Aug 2004 16:38:27)
sql server
(25 Aug 2004 14:33:15)
Log shipping destination server number limit
(25 Aug 2004 14:12:29)
Save CSV file from hosted SQL database to local machine
(25 Aug 2004 13:59:47)
MS Sql 2k DTS question
(25 Aug 2004 13:48:25)
Update a table on a joined query
(25 Aug 2004 13:44:38)
Re: Problem with SqlServerAgent[Scanned]
(25 Aug 2004 10:15:25)
error 17802 - sql server 6.5
(24 Aug 2004 17:30:52)
What will INVALIDATE INDEXES
(24 Aug 2004 10:31:23)
Re: *** POSSIBLE SPAM *** RE: SQL Server - DBA Report
(24 Aug 2004 8:39:57)
Why does the Transaction Log keep growing?
(24 Aug 2004 4:17:54)
SQL 2000 in a cluster
(24 Aug 2004 4:3:33)
dead locks on remote query/ insert
(24 Aug 2004 3:58:8)
Re: SUSPECT: large table size ?
(23 Aug 2004 21:21:15)
Re: SUSPECT: RE: SUSPECT: RE: SUSPECT: SQL performance
(23 Aug 2004 21:3:38)
Where is this error coming from ...
(23 Aug 2004 20:49:14)
DBCC sqlperf(waitstats)
(23 Aug 2004 19:46:25)
Sql question
(23 Aug 2004 16:18:55)
Re: SUSPECT: RE: SUSPECT: SQL performance
(23 Aug 2004 16:0:49)
large table size ?
(23 Aug 2004 14:0:5)
I need help desparately
(23 Aug 2004 13:54:4)
Advice
(23 Aug 2004 7:30:39)
Exception Error
(23 Aug 2004 7:6:45)
Re: [SPAM] - RE: Just Month, Day, Year - Number of numbers in MIM E From exceeds maximum threshold
(23 Aug 2004 5:48:6)
complex problem
(23 Aug 2004 5:26:36)
Data movement
(23 Aug 2004 5:16:44)
DTS Package
(23 Aug 2004 5:11:12)
Exit from DTS Transformation on a certain condition
(23 Aug 2004 5:5:57)
Hung tables
(23 Aug 2004 4:53:54)
Parsing an XML document in a user defined function
(23 Aug 2004 4:1:8)
Security
(23 Aug 2004 3:6:31)
LISTOWNER - Flames
(22 Aug 2004 22:52:14)
Re: SUSPECT: SQL performance
(22 Aug 2004 22:31:34)
Special Backup request
(20 Aug 2004 18:33:1)
Apology
(20 Aug 2004 18:16:31)
Re: SUSPECT: RE: SQL performance[Scanned]
(20 Aug 2004 17:32:11)
Re: SQL performance[Scanned]
(20 Aug 2004 15:59:26)
Just Month, Day, Year
(20 Aug 2004 15:27:6)
Re: SUSPECT: Just Month, Day, Year
(20 Aug 2004 14:45:44)
Re: SUSPECT: Hung tables
(20 Aug 2004 14:44:39)
Re: SUSPECT: RE: Why does the Transaction Log keep growing?
(20 Aug 2004 14:4:55)
Re: Why does the Transaction Log keep growing?[Scanned]
(20 Aug 2004 14:2:17)
Re: Save CSV file from hosted SQL database to local machine[Scanned]
(20 Aug 2004 7:49:24)
Querying Transaction Log
(20 Aug 2004 7:45:10)
Torn page error
(19 Aug 2004 23:41:36)
SQL performance
(19 Aug 2004 21:28:3)
Error on SQL Server Log
(19 Aug 2004 20:40:8)
SQL Server2000 to MS-Exchange Mail Server
(19 Aug 2004 20:30:17)
SQL - DB2
(19 Aug 2004 20:13:16)
Backing up system databases
(19 Aug 2004 19:43:56)
Database Move Tools?
(19 Aug 2004 19:34:28)
Process moving Objects from Development to Production environment
(19 Aug 2004 19:29:0)
SQL Server 2000 Enterprise Manager extremely slow
(19 Aug 2004 19:21:29)
Re: SUSPECT: RE: How does one truncate a transaction log file in SQL 2000
(19 Aug 2004 19:1:55)
Truncate Problem
(19 Aug 2004 18:44:37)
Re: SUSPECT: Re: SQL Server - DBA Report
(19 Aug 2004 18:20:54)
Re: SUSPECT: String Manipulation
(19 Aug 2004 16:43:30)
String Manipulation
(19 Aug 2004 15:41:19)
Urgent Advice
(19 Aug 2004 13:31:12)
How does one truncate a transaction log file in SQL 2000
(19 Aug 2004 13:23:52)
Upgrading from SQL 7 to SQL 2000
(19 Aug 2004 10:59:37)
Re: Log shipping via FTP?[Scanned]
(19 Aug 2004 9:2:20)
Creating functions
(19 Aug 2004 5:5:8)
Identity column
(19 Aug 2004 4:23:17)
Writing text to a file using SQL?
(19 Aug 2004 4:1:37)
Views or stored procedure and foreign keys
(19 Aug 2004 3:56:57)
Very slow updates across linked servers
(19 Aug 2004 3:56:40)
tempdb in ram
(19 Aug 2004 3:41:38)
SQL SERVER error connecting to Oracle (7399)
(19 Aug 2004 3:36:59)
Restore Log using Tranact-SQL causes error
(19 Aug 2004 3:24:37)
How to Trap date conversion error in SQL Server??
(19 Aug 2004 3:4:25)
How do I free up space on a server
(19 Aug 2004 1:51:30)
Column width in Query Analyzer
(19 Aug 2004 1:40:20)
Disk Free Space
(18 Aug 2004 23:7:52)
Decimal to Char
(18 Aug 2004 21:44:2)
DTS with VBA Error
(18 Aug 2004 20:3:25)
Re: SUSPECT: Views or stored procedure and foreign keys
(18 Aug 2004 13:49:50)
Re: SUSPECT: tempdb in ram
(18 Aug 2004 12:59:51)
How can I find if there's a constraint
(18 Aug 2004 11:27:42)
Re: Disk Free Space[Scanned]
(18 Aug 2004 11:12:58)
How to find Second Max Salary without using TOP?
(18 Aug 2004 8:52:12)
Assistance
(18 Aug 2004 1:3:15)
fn_trace_gettable
(17 Aug 2004 19:14:5)
DTS and Excel
(17 Aug 2004 16:49:38)
query analyzer on linux
(17 Aug 2004 14:5:21)
Log shipping via FTP?
(17 Aug 2004 13:46:11)
time diff. Date Problem
(17 Aug 2004 12:59:54)
curly one
(17 Aug 2004 0:46:22)
Retrieving ResultsSet and ReturnValue
(16 Aug 2004 18:36:13)
Monitoring Blocked SPIDS
(16 Aug 2004 16:54:36)
LISTOWNER- Too Many Emails in your inbox?
(16 Aug 2004 13:0:1)
another question... GUID vs Identity (performance benefits)
(16 Aug 2004 5:16:35)
change a default value in DDL for columns in a db with a certain data type
(16 Aug 2004 5:1:43)
Custom Application
(16 Aug 2004 4:47:18)
Database cannot open
(16 Aug 2004 4:41:26)
Re: Difference between - GO vs begin/end
(16 Aug 2004 4:36:12)
Full Text Index
(16 Aug 2004 4:32:20)
full-text catalog
(16 Aug 2004 4:21:46)
Hi!!How to avoid this error
(16 Aug 2004 4:6:51)
How to insert a user defined message in sysmessages table
(16 Aug 2004 4:4:46)
Insert resultset into temp table
(16 Aug 2004 3:51:28)
Linked Server
(16 Aug 2004 3:42:0)
Regarding updlock
(16 Aug 2004 3:41:56)
Linked server error
(15 Aug 2004 22:27:9)
Oracle and Sql server !!!!!!!
(15 Aug 2004 22:21:57)
Query takes too much time to Execute
(15 Aug 2004 22:21:57)
SQL Agent doesn't mail anymore
(15 Aug 2004 22:6:34)
SQL Server 7 ODBC connection on XP client
(15 Aug 2004 22:1:50)
Sql server and Oracle error !!!!
(15 Aug 2004 21:56:41)
Synchronization of master..sysusers and UserDB..sysusers tables
(15 Aug 2004 21:52:17)
new ebook - "SQL Server Backup, Recovery and Troubleshooting"
(15 Aug 2004 2:57:21)
sp_send_cdosysmail
(14 Aug 2004 11:42:21)
Linked Server question
(13 Aug 2004 15:50:36)
Full Text Expert
(13 Aug 2004 12:40:39)
Re: SUSPECT: Insert resultset into temp table
(13 Aug 2004 12:25:34)
Hi Frnds!!
(13 Aug 2004 7:40:11)
Retrieving values from multiple rows and concatenate
(13 Aug 2004 6:35:57)
Profiler / Trace
(12 Aug 2004 23:32:28)
Permission !!!!
(12 Aug 2004 23:11:25)
what sp triggers the trigger?? can we find out..
(12 Aug 2004 23:3:4)
convert getdate
(12 Aug 2004 22:55:14)
LISTOWNER - sql server list outage today
(12 Aug 2004 22:49:21)
Differnce between - GO vs begin/end
(11 Aug 2004 15:46:44)
after the fact investigation in SQL Server
(10 Aug 2004 22:7:56)
lazy... query help
(10 Aug 2004 21:56:22)
update ... lazy... query help
(10 Aug 2004 21:38:12)
logs of DTS Package
(10 Aug 2004 15:6:31)
HSODBC Openquery
(10 Aug 2004 15:6:30)
DTS with IF sentence
(10 Aug 2004 12:2:8)
How to veiw the content of a Blob fied (oracle 9i)
(9 Aug 2004 17:59:25)
RUN A MACRO EXCEL
(9 Aug 2004 17:26:7)
Recursive Query -- How to solve this ?
(9 Aug 2004 16:15:39)
SQL QUERY - Just curious
(9 Aug 2004 15:34:48)
Data Import Issue
(9 Aug 2004 13:16:16)
RI
(9 Aug 2004 2:4:39)
SQL 7/2K on same server
(8 Aug 2004 5:53:42)
sql monitoring tools survey
(7 Aug 2004 15:19:8)
Starting sql server services
(7 Aug 2004 15:4:54)
The scrip that pulls Indexed Columns
(7 Aug 2004 14:49:0)
PADDING IDENTITY COLUMNS/SEQUENCE NUMBERS with ZEROES
(7 Aug 2004 5:58:23)
Re: Need an Sql Query Help[Scanned]
(7 Aug 2004 5:44:10)
MSDAORA unable to begin a distributed transaction
(7 Aug 2004 5:33:58)
moving databases to other server
(7 Aug 2004 5:28:59)
Left Join
(7 Aug 2004 5:23:34)
Indexes in queries
(7 Aug 2004 4:51:0)
how to open port 1433 for internet access
(7 Aug 2004 4:37:15)
High Physical Reads Please be patient and read
(7 Aug 2004 4:37:6)
Fine Tune DB
(7 Aug 2004 4:29:2)
errors when connecting to oracle
(7 Aug 2004 4:22:38)
Error using DTS
(7 Aug 2004 4:14:17)
DTS - Package Time Limit
(7 Aug 2004 4:5:14)
Domain Controller
(7 Aug 2004 3:50:14)
Bulk Insert and Primary Key
(7 Aug 2004 3:35:34)
Cursor
(7 Aug 2004 1:9:37)
Cross Database queries
(7 Aug 2004 1:4:50)
DB Compare tools
(6 Aug 2004 21:2:44)
Urgent
(6 Aug 2004 16:47:14)
query vs stored procedure performance differences
(6 Aug 2004 13:46:32)
Pagination
(5 Aug 2004 20:58:8)
DBA Training
(5 Aug 2004 14:2:36)
Encrypted SPs
(5 Aug 2004 13:28:35)
Gathering Capacity Information
(5 Aug 2004 4:29:39)
WHAT HAPPEN WHEN IDENTITY/SEQUENCE reached its max value
(4 Aug 2004 13:29:54)
Date Only
(4 Aug 2004 10:41:50)
Disaster recovery AND reporting environment
(3 Aug 2004 22:42:48)
need a help in SQL Query
(3 Aug 2004 8:39:3)
Clustering
(3 Aug 2004 1:54:15)
Minumum Value
(2 Aug 2004 16:39:50)
imbedded DB HTML problem
(2 Aug 2004 16:21:56)
Need an Sql Query Help
(2 Aug 2004 8:59:3)
transaction log is ~ 50 Meg how do i trunk/comit the log?
(2 Aug 2004 2:28:40)
sql lazydba home page