This script(sproc)uses xp_cmdshell from sql and FINDSTR from DOS to search the current errorlog for a specific string such as kernel or failed login. Compile this in the master db and if you do not pass an input parameter a example usage will display for you. ex: sp_dba_sqlerrorlog kernel Edward J Pochinski III
2001-08-13
1,948 reads
This will show the fragmentation and stats before and after a reindex of a specified table. Run in the context for the db that holds the table the proc will get passed and re-index. Complile in master since the master is checked first for any SP that is prefixed with SP_ and you can call […]
2001-08-13
4,051 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Jl. Pantai Indah Selatan Blok DF No.1 & 2, RT.5/RW.6, Kapuk Muara, Kecamatan Penjaringan,...
Jl. Pantai Indah Kapuk Utara I Blok F, RT.6/RW.2, Kamal Muara, Kecamatan Penjaringan, Jkt...
Comments posted to this topic are about the item When And How to Automate?
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers