SQLServerCentral - Scripts by Banyardi Schmardi

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:

|

Briefcase | 937 reads

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:

|

Briefcase | 1,262 reads

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:

|

Briefcase | 1,192 reads

A T-SQL script to truncate your user database logs. Read more...

By Banyardi Schmardi 2008/11/20 | Source: SQLServerCentral.com | Category: log

Rating:

|

Briefcase | 950 reads