SQLServerCentral.com Scripts tagged Lock and Connection Management, T-SQL Aidshttp://www.sqlservercentral.com/Scripts tagged Lock and Connection Management, T-SQL Aids posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Table Variableshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31812/2006/01/15http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31812/sp_whathttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/2006/10/02http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/usp_ToggleDatabaseshttp://www.sqlservercentral.com/scripts/Replication/31554/2005/08/04http://www.sqlservercentral.com/scripts/Replication/31554/SQL Blocking and Blocked Proc + Notifi - Part2http://www.sqlservercentral.com/scripts/Miscellaneous/31492/2005/05/12http://www.sqlservercentral.com/scripts/Miscellaneous/31492/Kill All User Sessionshttp://www.sqlservercentral.com/scripts/Miscellaneous/30838/2003/06/18http://www.sqlservercentral.com/scripts/Miscellaneous/30838/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/More Friendly version of sp_lock system sp.http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30408/2002/07/10http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30408/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/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/