Daily Archives: March 5, 2014

T-SQL Stored Procedure to Get the Number of Connections and Login Names per DB

Advertisements

Posted in Database Connection, T-SQL Script | Tagged | Leave a comment

T-SQL Stored Procedure to Shrink the Log File of a Database

This script is particularly useful when you are dealing with disk space limitations on dev or uat boxes when point-in-time recovery capabilities are not required and the simple recovery model is very much acceptable. I use this stored proc constantly … Continue reading

Posted in SQL Server, T-SQL Script, Transaction Log | Tagged , | Leave a comment