Viewing 15 topics - 268,276 through 268,290 (of 270,932 total)
I am looking for SQL server Monitoring 3rd Party Software.
I have Quest I/Watch and NetIQ f…
18 years, 1 month ago
Edit... Found a post from last September that covers this and I will look into that.
I am trying to…
I am trying to DTS data from SQL tables to an Access file. There is one table that will give an uns…
In: Data Transformation Services (DTS)
I have inherited three servers, one production and two for development/testing. I am trying to sync…
In: Anything that is NOT about SQL!
By: Andy Warren
We have a stored procedure that specifies NOLOCK hints on all its tables. When we run this procedu…
I am trying to monitor the lock usage on a stored procedure using SQL Profiler. However, the profi…
Is there a best practice for emulating constants within SQL Server like those used in programming l…
I have a stored procedure that takes seconds to run in SQL Analyser, but takes 20 minutes or more t…
By: Steve Jones - SSC Editor
I was wondering how to exit a procedure after I raise an error. This is what i'm doing. After a s…
I am sure this is an easy one all, but I am new to SQL Server.
How do you get the value of a partic…
Getting ready to try my hand at really using constraints. Anyone reason why I should not …
I am using SQL(7.0) Mail. How do I attach a file (on the hard drive, ex: D:\mydoc\test.doc) to SQL …
I'm looking for tools that generate an update sql script between 2 ODBC DB sources ( so not m…
I'm just checking out filegroups and am not sure how the restore methodology works - perhaps someon…
SS2k, full-text query problem.
Im getting the following error:
Server: Msg 7619, Level 16, S…
By: K. Brian Kelley