Viewing 15 posts - 1 through 15 (of 19 total)
This is a great stored procedure. Although adding stored procedures to the master db is not recommended, I do add this one. It is very useful. It finds occurrences of...
July 2, 2004 at 9:45 am
We use the usp_KillUsers stored procedure found here at SSC.com. (This procedure kills all user processes except the calling one.) From a job, we run the Kill procedure, have the job wait a...
February 19, 2004 at 9:02 am
Someone posted a useful stored procedure called usp_KillUsers a while back. I run this sp nightly from a SQL Server job to get rid of any old connections. Works well. Do...
January 20, 2004 at 9:03 am
If I remember correctly the question specified that the application was freezing not frozen. For that reason I think profiler would be the correct choice. I believe running profiler with lock and...
January 15, 2004 at 8:58 am
I use these 2 statements as two different steps in a job to back up the log and then truncate it. Works well.
Step 1
BACKUP LOG [MyDB] TO DISK= 'D:\Backup\MySqlServer\MyDB\MyDbLog.dat' WITH ...
January 7, 2004 at 9:11 am
You can also use VBA and ADO to execute a stored procedure that calls the DTS package. Here's an example of a stored procedure that uses the system stored...
December 15, 2003 at 5:42 pm
One advantage to setting up a linked server is that the connection and authentication information already exists when making the query, so the call is much simpler. ...
December 10, 2003 at 9:27 am
Under the SQL Agent properties/Connection tab, check to see what account is there. If it's a network account, try using the sa account. This solved a lot of...
December 5, 2003 at 9:57 am
A great way to see where the bottleneck(s) in a query are, is to use the "Show Execution Plan" under the "Query" menu item in SQL Analyzer. After the...
December 3, 2003 at 1:46 pm
Well I never did find out exactly what was causing the problem but after installing WIN2000 SP4 and changing the SQL SERVER AGENT connection login to sa, it now works....
November 18, 2003 at 3:51 pm
Thank you for the insight. I forgot all about the right click/package log function! Please read my reply to phillcart about what I came up with as to...
November 17, 2003 at 3:46 pm
Thank you for the reply Phillcart. I did check those tables out and I will keep that in the toolbox for later use. I checked the sysdts tables,...
November 17, 2003 at 3:44 pm
I was hoping it wasn't a literal truncate of the message, but looking at the table yes, that makes sense. I will try your stratedgy. Thank you once...
November 13, 2003 at 1:46 pm
Thank you for your reply. I am not familiar with the just-in-time debugging option, but I will investigate and put into action. Very appreciated. Thanks again!