SQLServerCentral.com Scripts tagged Lock and Connection Management, Miscellaneoushttp://www.sqlservercentral.com/Scripts tagged Lock and Connection Management, Miscellaneous posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)finding the blocks in sql serverhttp://www.sqlservercentral.com/scripts/Miscellaneous/32000/2007/09/09http://www.sqlservercentral.com/scripts/Miscellaneous/32000/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/SQL Blocking and Blocked Proc + Notifi - Part2http://www.sqlservercentral.com/scripts/Miscellaneous/31492/2005/05/12http://www.sqlservercentral.com/scripts/Miscellaneous/31492/SP_WHO_3 Powerful Filtering/Sorting Very Efficienthttp://www.sqlservercentral.com/scripts/Miscellaneous/31267/2007/06/13http://www.sqlservercentral.com/scripts/Miscellaneous/31267/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/Modified sp_who - more info & extra parameterhttp://www.sqlservercentral.com/scripts/Miscellaneous/31144/2004/05/06http://www.sqlservercentral.com/scripts/Miscellaneous/31144/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/Blocking Notificationhttp://www.sqlservercentral.com/scripts/Miscellaneous/30819/2003/05/29http://www.sqlservercentral.com/scripts/Miscellaneous/30819/Restrict simultaneous access to resourceshttp://www.sqlservercentral.com/scripts/Miscellaneous/30789/2003/05/07http://www.sqlservercentral.com/scripts/Miscellaneous/30789/Full server documentationhttp://www.sqlservercentral.com/scripts/Miscellaneous/30769/2003/04/28http://www.sqlservercentral.com/scripts/Miscellaneous/30769/View Input Buffers for all SPIDShttp://www.sqlservercentral.com/scripts/Miscellaneous/30742/2003/04/04http://www.sqlservercentral.com/scripts/Miscellaneous/30742/No more orphan users!http://www.sqlservercentral.com/scripts/Miscellaneous/30682/2003/02/03http://www.sqlservercentral.com/scripts/Miscellaneous/30682/INSERTS that will STAY after a ROLLBACK is issuedhttp://www.sqlservercentral.com/scripts/Miscellaneous/30498/2002/10/01http://www.sqlservercentral.com/scripts/Miscellaneous/30498/Modified SP_whohttp://www.sqlservercentral.com/scripts/Miscellaneous/30353/2002/05/28http://www.sqlservercentral.com/scripts/Miscellaneous/30353/Send notifications on job STEP failures (trigger)http://www.sqlservercentral.com/scripts/Miscellaneous/30177/2002/02/13http://www.sqlservercentral.com/scripts/Miscellaneous/30177/SP to show information about log in databaseshttp://www.sqlservercentral.com/scripts/Miscellaneous/30151/2002/02/02http://www.sqlservercentral.com/scripts/Miscellaneous/30151/Another script from DOS but shows alertshttp://www.sqlservercentral.com/scripts/Miscellaneous/30077/2001/11/03http://www.sqlservercentral.com/scripts/Miscellaneous/30077/Shows Tables for a Given Database from DOShttp://www.sqlservercentral.com/scripts/Miscellaneous/30076/2001/10/28http://www.sqlservercentral.com/scripts/Miscellaneous/30076/Find Longstanding Open Transactionshttp://www.sqlservercentral.com/scripts/Miscellaneous/30085/2001/10/08http://www.sqlservercentral.com/scripts/Miscellaneous/30085/List Where SQL Server Fileshttp://www.sqlservercentral.com/scripts/Miscellaneous/30073/2001/09/10http://www.sqlservercentral.com/scripts/Miscellaneous/30073/List Only User Tableshttp://www.sqlservercentral.com/scripts/Miscellaneous/30070/2001/09/07http://www.sqlservercentral.com/scripts/Miscellaneous/30070/Display X Type Locking Usershttp://www.sqlservercentral.com/scripts/Miscellaneous/30069/2001/09/06http://www.sqlservercentral.com/scripts/Miscellaneous/30069/