Microsoft has KB articles on how to monitor blocking in SQL Server 7 and 2000. Basically, they work similar to the stored procedure given. What MS recommends is a process...

There is an issue to consider, and that issue is the performance hit, regardless of whether or not it grabs the right stored procedure or not.

Quite simply, if you have...

Unless they've changed the address, suggestions for additions and improvements can be sent to:

sqlwish@microsoft.com

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Did you mark the stored procedure in the master database as a system object? I don't see that you did based on your explanation. That would explain the discrepancy based...

If I remember right, the performance implications of Foreign Keys was one of the reasons it wasn't a high priority on the MySQL project. However, it's in there now because...

Think of a sleeping process as simply an idle one. It's not unusual to see them if users leave applications open (especially the SQL Server client tools). Unless the user...

(1) He should be able to write a VBScript routine and schedule it using the Windows Task Scheduler. Not through ASP. Instead create a script file such as MailCustomers.vbs or...

If the service actually hangs, you can produce a user dump... harder to read and decipher, but doesn't require Profiler to be running. You can use AD+ in "hang" mode:

http://support.microsoft.com/default.aspx?scid=kb;en-us;286350

K....

Check your SQL Server properties. If you've set auditing of logon events, you'll see them in the Event Log. I believe this requires a SQL Server restart to take effect.

K....

You can see every table in the database, but can you actually return data from every table?

If you can, check to make sure the public role hasn't been placed in...

<Shameless plug>

I cover how to do these in my e-Book as well. It's available at a discount for SQL Server Central users through NetImpress.

</Shameless plug>

Also, the SQL Server specific counters...

We've chosen a similar tactic. We don't do enough transactional processing to go RAID 0+1 so we've stuck with RAID 5. The read/write cache on our array controllers are more...

This is a confirmation of what Mkumari has said. The sysobjects system table exists in every database. It only contains the objects for the database it is in. This...

Antares is right about how it'll go about executing. If you don't mark it as a system stored procedure, it will get around to executing the one in the local...

Run the sp_grantdbaccess to grant them access to the database (this is a requirement).

As joachim has pointed out, if you've not given them access to the tables, simply by giving...