If you set up a default on a column AFTER data has been entered, then this procedure will apply the default to all NULL values within that column. Limitations: It only works with numeric values right now.You will also need the INSTR function, which you can also get from this site.This is my first […]
2004-10-13 (first published: 2004-07-22)
89 reads
There are times when you have mulitple job failures and need to find out in a quick way which jobs/steps failed and what their rerun statuses are. This script creates a stored procedure in the msdb db to help you find out the statuses of these jobs.
2004-10-12 (first published: 2004-07-21)
140 reads
Based on a script from this site, which sets ownership of all objects to dbo, this modification of the original author's code simply adds user defined functions (UDF's). Script now includes tables, views, procs and functions.
2004-10-07 (first published: 2004-07-19)
214 reads
Delete all rows from all user tables. Create stored procedure and execute the procedure to get rid of all rows from all tables. This will not drop your tables. Be very careful what you wish for!
2004-10-06 (first published: 2004-01-20)
96 reads
A simple script created to summarize locking by spid, by database, by type with more user friendly descriptions. You can also run for a specific spid. Hope it's useful.
2004-10-05 (first published: 2004-01-27)
480 reads
Returns the number of records within a table without having to perform COUNT.
2004-10-04 (first published: 2004-02-03)
838 reads
This will return the weekno of the given date
2004-10-01 (first published: 2004-02-16)
133 reads
Get the Last date of the month for the given month and year
2004-09-30 (first published: 2004-02-16)
92 reads