Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Banyardi Schmardi

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

usp_ShrinkAllLogs

Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.  Read more...
By Banyardi Schmardi 2009/11/27 | Source: SQLServerCentral.com | Category: truncate table
Rating: |  Discuss |   Briefcase | 904 reads

Script SQL Table Schema as XML-XSD

When creating XML messages for Service Broker or other applications use this simple method to build a validation XSD.  Read more...
By Banyardi Schmardi 2009/10/28 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 1,161 reads

usp_SQL_In_sp_who2

Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID  Read more...
By Banyardi Schmardi 2009/04/24 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 1,144 reads

usp_ShrinkDBLogs

A T-SQL script to truncate your user database logs.  Read more...
By Banyardi Schmardi 2008/11/20 | Source: SQLServerCentral.com | Category: log
Rating: |  Discuss |   Briefcase | 936 reads
   Items 1 to 4 of 4