Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
Learn something every day with brand new articles by email:
Sign up
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
|
938 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,276 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,194 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
|
951 reads
Items 1 to 4 of 4
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.