Viewing 7 posts - 31 through 37 (of 37 total)
I have run some Profiler traces but am not sure how to definitively capture the exact SQL queries that will correlate back to the SPIDS of the deadlock participants. Also,...
March 30, 2004 at 11:18 am
This is not quite as automatic, but definitely is faster than manually logging into multiple instances of QA. Use Enterprise Manager to connect to a server, then expand down to the Databases...
March 24, 2004 at 8:36 am
Here is an easy way to accomplish this. Right-click on each DTS package and schedule each separately into three SQL Server Agent jobs. Then look at the step properties for...
March 11, 2004 at 7:41 am
Here is a variation of the above if you want to control the move more precisely by separating the copy and delete portions into separate ActiveX tasks.
December 23, 2003 at 8:03 am
Here is a little VB Script that will do the job. You can put it into an ActiveX task in your DTS package. It writes the count to a file,...
December 11, 2003 at 10:23 am
Here is a relatively minor improvement. Change the concatenation operator from a plus sign to "||" like it is in Oracle, and no longer have to cast or convert numeric...
September 2, 2003 at 8:42 am
Executing the stored procedure sp_help with no parameters will return a list of tables and objects in the database. Running sp_help followed by by the table name will return schema...
June 26, 2003 at 8:44 am