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  SQL Server 2000 Forums  SQL Server Administration (2000)  sp_blocker_pss80

Author  Topic  dewacorp.alliances 452 Posts Posted - 2005-02-15 : 21:55:08 Dear Support I'm trying to use this sp_blocker_pss80 from http://support.microsoft.com/?id=271509 to detecting the block. One of step said that I need to put this stored in master database. My question is: I have my client (CLN000) and has a SQLServer on it. This machine is specifically for doing monitoring and stuff. Also, I have a server (SVR000) that would like to be monitored to. So my question is: Does the sp_blocker_pss80 needs to be in the server (SVR000)? Can I put this into a client (CLN000) instead and running from there using: osql -E -SSVR000 -icheckblk.sql -ocheckblk.out -w2000 Please advice? Thanks.