Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Shastryv
Posting Yak Master
145 Posts |
 Posted - 2001-07-10 : 14:52:18
|
| The stored procedure seems running when I launch from the QA but it in the Current activity it shows its sleeping. Can any one tell me how can I find whether it is running or not. Sp_who2 Active shows the process is running but the status is sleepingSelect * from sysprocesses show the following outputspid blocked waittype waittime lastwaittype sid------ ------- -------- ----------- ---------------- -----------------15 0 0x0200 656 EXCHANGE sleeping (1 row(s) affected)Any comment in greatly appreciatedShastry.V |
|
|
|
|
|
Whats going on with the Stored Procedure :-((