SQLServerCentral.com Scripts tagged Lock and Connection Managementhttp://www.sqlservercentral.com/Scripts tagged Lock and Connection Management posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)TopBlockerScript to log top blocker processes in a database. Top blocker is defined as the process that is at the top of a blocking chain.http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/61438/2007/12/07http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/61438/finding the blocks in sql serverhttp://www.sqlservercentral.com/scripts/Miscellaneous/32000/2007/09/09http://www.sqlservercentral.com/scripts/Miscellaneous/32000/How to insert and update from remote linked serverhttp://www.sqlservercentral.com/scripts/Replication/31977/2007/10/30http://www.sqlservercentral.com/scripts/Replication/31977/usp_KillConnectionshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/2007/10/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/Who's Blockinghttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31901/2007/04/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31901/What's Runninghttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31900/2007/04/17http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31900/Table Variableshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31812/2006/01/15http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31812/Script to output dbcc inputbuffer adding spid infohttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31802/2006/10/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31802/SQLPing.vbshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31781/2006/09/04http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31781/Function to return the SQL Version Numberhttp://www.sqlservercentral.com/scripts/Replication/31754/2006/08/08http://www.sqlservercentral.com/scripts/Replication/31754/Function to return the SQL Build Numberhttp://www.sqlservercentral.com/scripts/Replication/31753/2006/08/09http://www.sqlservercentral.com/scripts/Replication/31753/sp_whathttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/2006/10/02http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/To Identify blocks if using Solomon IVhttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31578/2005/11/03http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31578/Save results DBCC SQLPERF(UMSSTATS) in a table http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31577/2005/11/04http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31577/usp_ToggleDatabaseshttp://www.sqlservercentral.com/scripts/Replication/31554/2005/08/04http://www.sqlservercentral.com/scripts/Replication/31554/Blocked Process script for deadlock correctionhttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31535/2005/12/01http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31535/SQL Blocking and Blocked Proc + Notifi - Part2http://www.sqlservercentral.com/scripts/Miscellaneous/31492/2005/05/12http://www.sqlservercentral.com/scripts/Miscellaneous/31492/Get SQL code Blocking and Blocked procs + Notifhttp://www.sqlservercentral.com/scripts/Mail/31482/2005/04/28http://www.sqlservercentral.com/scripts/Mail/31482/SP_WHO_3 Powerful Filtering/Sorting Very Efficienthttp://www.sqlservercentral.com/scripts/Miscellaneous/31267/2007/06/13http://www.sqlservercentral.com/scripts/Miscellaneous/31267/Extract data from sp_who for specific databasehttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31246/2004/09/13http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31246/SP_WHO_3 - A Very Powerful Utility for All DBAshttp://www.sqlservercentral.com/scripts/Miscellaneous/31232/2006/01/17http://www.sqlservercentral.com/scripts/Miscellaneous/31232/SP_WHO_3 Powerful Filtering/Sorting Very Efficienthttp://www.sqlservercentral.com/scripts/Miscellaneous/31227/2004/11/09http://www.sqlservercentral.com/scripts/Miscellaneous/31227/sp_lock with order by and object namehttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31219/2004/10/22http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31219/Modified sp_who - more info & extra parameterhttp://www.sqlservercentral.com/scripts/Miscellaneous/31144/2004/05/06http://www.sqlservercentral.com/scripts/Miscellaneous/31144/Kill all SPIDs with a certain user IDhttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31097/2004/03/08http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31097/Check if someone use a database or nothttp://www.sqlservercentral.com/scripts/Miscellaneous/30871/2003/07/15http://www.sqlservercentral.com/scripts/Miscellaneous/30871/Kill All User Sessionshttp://www.sqlservercentral.com/scripts/Miscellaneous/30838/2003/06/18http://www.sqlservercentral.com/scripts/Miscellaneous/30838/blocked  and blocker  spid and detailshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30826/2003/06/05http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30826/Blocking Notificationhttp://www.sqlservercentral.com/scripts/Miscellaneous/30819/2003/05/29http://www.sqlservercentral.com/scripts/Miscellaneous/30819/Script to kill the top blocker and report what it was doing.http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30800/2003/05/12http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30800/