This procedure queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules(if applicable),how often the interval occurs(every X hours,min.,days,etc), the maximun duration, last duration,last status of the job.This is a script that I modified and added to from M.Pearson.
2003-12-16
397 reads
This script is similar in style to my previous script SQL Server Job Status Report, but this script generates an HTML report on the size of all databases on a specific SQL Server instance. The report consists of several sections: a summary report on the size of all databases; a summary report on the size […]
2003-12-04
1,148 reads
This script generates an HTML report on the status of all jobs on a specific SQL Server instance. The report consists of several sections: a summary report of jobs that have passed, failed, been cancelled, or whose status is unknown; a detailed report of the status of each job.The script is designed to be included […]
2003-12-01
924 reads
I pieced this script together from solutions I found on this and from Brian Knight's excellent book. It creates 3 tables: - tblDriveLogs. Collects free drivespace info for each drive for each time the script is run. - tblIndexLogs. Collects info on spaceused for each index and table. Please note that when only af single […]
2003-11-26
902 reads
Use SQL-DMO to find database size used for more than one sql server in your enviroment.
2003-11-10
172 reads
MSSQLServer has got sp_depends system sp to display the dependencies for a stored procedure, table and view. sp_depends does not support to display the User-defined data type dependencies. For custom database, we will create user defined data types (UDDT) and add this UDDT to a column/variable in a table/stored procedure. This sp (UDTDepends) will help […]
2003-10-30
456 reads
It creates documentation for all user tables in a specific database. A server name/ database name was added on the top of the HTML file also a column datatype field was added to the HTML file. Now the @strHTML can have 8000 chars, before only 4000 - still for tables with a lot of columns […]
2003-10-27
659 reads
Provides a method to regularly recycle the sql server error logs based on a given file size. If the current log file is larger than that size, then the current log is closed and a new log created.This proc takes one parameter, @MaxFileSize, which is the target file size. This parameter defaults to 10 MB. […]
2003-10-27
924 reads
The error checking seems to work better than the @@error after exiting out of a xp_cmdshell DOS task concerning a failed or successfull attempt.
2003-09-26
532 reads
We can know how much space a database is occupied in hard disk by using sp_spaceused function. If we want to find all database sizes at a time, we have to provide use and sp_spaceused for all databases. It takes some time to write all those T-sql statments. My script will find each and every […]
2003-09-16
1,661 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Comments posted to this topic are about the item When SQL Server Central Went...
Comments posted to this topic are about the item The String Distance I
Comments posted to this topic are about the item How Database Professionals Sent a...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers