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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SPID's running a particular Stored Proc

Author  Topic 

avmreddy17
Posting Yak Master

180 Posts
Posted - 2008-07-18 : 10:22:02
Is there any way to find out all the SPID's running a particular Stored Procedure

Thx

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2008-07-18 : 10:34:54
i think you can get it from sysprocesses table or using sp_who


http://doc.ddart.net/mssql/sql70/sys-p_2.htm


http://doc.ddart.net/mssql/sql70/sp_wa-wz.htm
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site