Modify the error message on Locktable

SuperSage77

Hello!


A means exists - it to change the following message

You cannot use the table reservation entry, because it is blocked by another user. Wait that the user ends up, then re-try!

Then I to change this message to know to User which is changing this table ?

Thanks for response.

Rudy

matttrax

I don't know that you can change the error message, but you can see who is blocking you by drilling down on the open sessions from File --> Database --> Information.

You can also run an sp_who in SQL.