Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.
2009-09-23 (first published: 2009-08-27)
2,259 reads
This script takes a table as parameter and generate its data script (INSERT INTO TABLE).
2009-09-21 (first published: 2009-09-13)
2,234 reads
The script will produce a Drop/Create script for all the jobs existing on the server. Instead of scripting them individually.
The output script will also have schedules scripted out
2009-09-18 (first published: 2009-09-08)
5,595 reads
This script will list columns data type and size for every table in a database.
2009-09-15 (first published: 2009-09-02)
1,968 reads
Query to generate a dynamic Select statement from any table for moving data between servers.
2009-09-11 (first published: 2009-09-01)
1,578 reads
this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.
2009-09-10 (first published: 2008-11-21)
3,310 reads
This script pulls all data and log files associated with user db's
2009-09-08 (first published: 2009-08-31)
433 reads
To find date at nth occurrence of a weekday in a month and year
2009-09-07 (first published: 2009-09-01)
734 reads
This script finds the last run status for Full / TL backups.
2009-09-04 (first published: 2009-08-31)
2,276 reads