Anybody still on this question?

yes, it's so surprising. How come the select statement in the second window does not put the S-Lock on the key? Does it just check the dirt pages on the...

Greate!

But, in my routine, I often have to find the storeprocedure correlated to a table or column.

I have a script for purpose, but it just do it by...

In fact, we can use sp_resolve_logins to solve this issue

Mr. Bird^_^

I learned a lot from your article. thanks a lot.

If it is allowed to use sp_cmdshell, we can use findstr, that is a windows command, to find the error...

great article!

But, I think some other points might need to be monitor,

for example, cpu usage, disk io, etc..; system event log, cluster log, etc..;

DB file growth, table space growth, etc..;

duration...