SQLServerCentral.com Content tagged Maintenance and Management, Lock and Connection Managementhttp://www.sqlservercentral.com/Content tagged Maintenance and Management, Lock and Connection Management posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)The Ultimate Connection Summarizer and Trouble FinderReports summaries of connections, running requests, open transactions, open cursors, and blocking at 3 different levels of aggregation detail, ranking trouble groups first.http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/64433/2008/09/18http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/64433/How to insert and update from remote linked serverPlease read the how to use. unfortunately the orignal document i submitted was truncated :( and i dont have time to remember what i saidhttp://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/usp_KillConnectionshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/2007/10/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/finding the blocks in sql serverhttp://www.sqlservercentral.com/scripts/Miscellaneous/32000/2007/09/09http://www.sqlservercentral.com/scripts/Miscellaneous/32000/SP_WHO_3 Powerful Filtering/Sorting Very Efficienthttp://www.sqlservercentral.com/scripts/Miscellaneous/31267/2007/06/13http://www.sqlservercentral.com/scripts/Miscellaneous/31267/What's Runninghttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31900/2007/04/17http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31900/SP_WHO_3 Powerful Filtering/Sorting Very Efficienthttp://www.sqlservercentral.com/scripts/Miscellaneous/31267/2007/06/13http://www.sqlservercentral.com/scripts/Miscellaneous/31267/sp_whathttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/2006/10/02http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/Function to return the SQL Build Numberhttp://www.sqlservercentral.com/scripts/Replication/31753/2006/08/09http://www.sqlservercentral.com/scripts/Replication/31753/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/Function to return the SQL Version Numberhttp://www.sqlservercentral.com/scripts/Replication/31754/2006/08/08http://www.sqlservercentral.com/scripts/Replication/31754/sp_whathttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/2006/10/02http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31690/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/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/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/31227/2004/11/09http://www.sqlservercentral.com/scripts/Miscellaneous/31227/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/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/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/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/Correction to "drop/recreate objects" script.http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30686/2003/02/06http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30686/Drop and re-create all stored procedures or viewshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30684/2003/02/05http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30684/SP to display locking users in tree formathttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30459/2002/08/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30459/Never use select into in transactions......http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30364/2002/06/07http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30364/