Thanks all, similar how do you tell what escalation setting has been configured on a table?

I know you can change it to AUTO, DISABLE or TABLE but how do you...

I had another look and it actually shows the entire create stored procedure, all the TSQL within it including the comments.

It just that the SQL Profiler show the textdata as a create procedure which is misleading, it should have been display the execute stored procedure command.

Just did some testing and the SQL Profiler actually logs those create stored procedure when you do an execute on the stored procedure and there are lock escalation (from page...

Just a few quick questions,

Please correct me if I am wrong, but master db contain login information, so essentially you are just copying the logins to the target server, just...