2015-05-01 (first published: 2013-08-13)
3,719 reads
Display the SELECT statement for any table
Found this lovely T-SQL script to display the SELECT statement for any table.
2013-08-22 (first published: 2013-08-06)
3,200 reads
Display the number of days since last Database backup.
A simple T-SQL script to display the number of days since the last database backup.
2013-08-07 (first published: 2013-07-29)
1,398 reads
sp_MSforeachtable:Add SQL objects to multiple database on a server.
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
621 reads
2011-09-15 (first published: 2011-09-05)
2,892 reads
2011-08-05 (first published: 2011-07-23)
2,160 reads
A simple SysProcess query
A quick and simple SysProcess query which will display most of the common parameters of interest.
2011-07-28 (first published: 2011-07-23)
1,365 reads
Blogs
Azure SQL Database – Error Logs?
By Arun Sirpal
Ok, so Azure SQL doesn’t really have its own error log based somewhere on...
Pluralsight Free April
By Gail Shaw
It’s a few days into April, but not too late I hope to mention...
Daily Coping 7 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Forums
For loop in C# script component
Hi Everyone,I have a script task calling a sequence container. What i would like...
More Time to Certify
Comments posted to this topic are about the item More Time to Certify
Difference Between Lists
Comments posted to this topic are about the item Difference Between Lists
Ask SSC