TSQL:Procedure to Query for Dependent ObjectsJack Donnell,jack@JackDonnell.com Have you ever kept altering the same query to look for different items in you database?I took a hint from MS with all the sp_help and other system stored procedures and made a two scripts this one to query for databases dependednt objects or references.I also created another […]
2002-06-07
732 reads
Monitor the long term growth of Many databases on Server-Create the table DbSizeTracking on database of choice-Create a job to run the script on weekly intervals-Query the table with section at end of script
2002-06-06
916 reads
2002-06-06
517 reads
Here is a strait forward script that allows you to use CDONTS to send email. Note that the Subject, From, CC and BCC are all optional parameters. Because it uses a fully qualified path, this procedure can live in any database on the server. CDONTS will need to be installed on the server.
2002-06-06
730 reads
sp_lock2 is similar to sp_lock, except that it displays the database name, object name and index name instead of the ids. It accepts no parameters unlike the sp_lock procedure which can take an optional spid parameter. The basis for the main query which queries the system tables for lock info was taken from the sp_lock […]
2002-06-06
4,314 reads
The SQL 7.0 Query for listing of all users tables with owner, no of rows and Date/Time created is as follows
2002-06-06
329 reads
--Implement an Alert Which Trigger when Specified Disks--free space exceeds a specified alert level--Steps to implement:--1) Define a Custom Error Message with messsage text (The ---drive free space is bellow alert level. Details: %s)--2) Define an Alert linked to CEM defined at step 1--3) Implement a Job which execute the following step in a recurring […]
2002-06-04
2,731 reads
This queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules (if applicable).
2002-06-04
1,781 reads
2002-06-04
466 reads
This stored procedure can be used to send mail through CDONTS and SQL Server. It resides in the Master database and accepts email addresses and subjects with a maximum of 50 characters and a body with a maximum of 500 characters. (You can increase or decrease these according to your requirements.) For this stored procedure […]
2002-06-03
2,210 reads
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Comments posted to this topic are about the item Checking the Error Log II
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers