Monday, August 21, 2017

SQL Server Management Studio related

View who open database :
Open Activity Monitor
Type CTRL+ALT+A to open Activity Monitor at any time
UPDATE:
Since ...., you must user query instead :
List sessions / active connections in SQL Server
" exec sp_who" or "exec sp_who2"

Can this tool help me with INSERT, UPDATE or DELETE statements?
Yes - as a matter of fact.  Just right click in the query pane and select Change Type and then the type of query desired.
(source)

No comments:

Post a Comment