Posts

Showing posts from July, 2017

Check Lock Records

 Run Query  select DB_NAME(dbid) as 'DB Name',cmd,* from sys.sysprocesses where blocked > 0 See Database Name focus and remember spid. View Processes on Activity Monitor and kill process.