Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Much Ado about Nothing
Message
From
10/05/2002 16:48:38
 
 
To
10/05/2002 15:27:35
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00655230
Message ID:
00655271
Views:
17
Is the entire thing under one transaction? I've had issues with really large long running transactions. Try breaking it into smaller ones.

Are you being blocked by something else? When things look stalled, fire off sp_who on another connection and look for a value in the BLK column.

Are you sure that it's not doing anything? How can you tell?

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform