sp_what
Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.
*Dont you just love totally non subjective assessments like this?
2018-11-01 (first published: 2018-10-22)
2,800 reads
Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.
*Dont you just love totally non subjective assessments like this?
2018-11-01 (first published: 2018-10-22)
2,800 reads
Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.
2016-12-05 (first published: 2015-05-29)
2,774 reads
This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.
2015-07-23 (first published: 2015-06-23)
1,306 reads
This script simply returns the most recent restore information about databases for a server.
Returns the destination database name, the device used to perform the restore and the restore date.
2015-07-15 (first published: 2015-06-10)
721 reads
2013-12-06 (first published: 2011-01-31)
4,750 reads
This script uses the backup tables to get info on the growth of your database files.
2013-05-07 (first published: 2009-02-03)
13,714 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers