This DTS package reads a list of servers from an XML configuration file, connects to each server, and writes a list of all failed jobs to a web page on the web server. Each morning, I just need to open my browser and I can see the status of all 42 of our servers.
2002-09-19
679 reads
I wrote this for the developers because they were always asking me to find all of their stored procedures that did X.It scans through the syscomments text in each database looking for the requested string. User must have read access on the syscomments and sysobjects tables in each database.
2002-06-14
948 reads
This script captures the current system lock in a temp table, then builds a temp translation table for database and object id by iterating through all of the databases. It then produces a report by joining the two tables.For better performance, you could make the translation table perminante and only update it when you are […]
2002-06-14
576 reads
Logging is a necessity in the database world, well, the entire tech world. You...
By Rayis Imayev
(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media...
By Steve Jones
It’s been a week since I flew home from London and Redgate to begin...
Comments posted to this topic are about the item The Mindset of a Database...
Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...
Hi everyone I have two db - one is test and other is archive. ...
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers