<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
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
|
894 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,113 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,125 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
|
929 reads
Items 1 to 4 of 4
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
