Viewing 2 posts - 1 through 2 (of 2 total)
I ran a defrag of the file system on the weekend, and also a database reindex of each table.
I get the blocking info by using sp_who2 and dbcc inputbuffer (spid). Sometime...
April 24, 2006 at 10:23 am
#633851
Thanks for your help. I've done it with two INSERT/SELECT queries. I was able to join the Company table in the second query to allow to get me the CompanyKey...
November 8, 2005 at 3:38 am
#602749