List Out All User Defined Triggers
List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.
2019-05-03 (first published: 2015-07-07)
841 reads
SQl Hunt
- Interests: Like to make friendship with people.
2019-05-03 (first published: 2015-09-13)
1,924 reads
PowerShell Query to remove backup folders against multiple servers
Remove backup folders from multiple servers.
2019-05-03 (first published: 2014-12-09)
619 reads
Query to check whether my Full Database Backup is running fine.
The query will help to find whether my database backup to a specific instance of SQL Server is running fine. If HH> 1, this would signify that the backup is running, else this is a failure.
2019-05-03 (first published: 2012-08-25)
1,238 reads
Query to Delete all Folders, Sub-Folders and Files located in a Path
A script to help you cleanup Files/Folders & Sub-folders.
2019-05-03 (first published: 2015-07-30)
69 reads
2019-05-03 (first published: 2015-05-08)
1,131 reads
Query to find the Job Output file location at each job step
Query to find the Job Output file location at each job step.
This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.
2019-05-03 (first published: 2015-04-24)
3,328 reads
Read all trace file data and print the action performed
If you want to read trace file records from default trace location and want to print to see what are all the activities happened on SQL Server, the query will be helpful for you.
2019-05-03 (first published: 2014-11-12)
2,328 reads
READ Data from default Trace
READ Data from default Trace to know when the objects are altered. If no database name is provided, it will run through all the databases.
2019-05-03 (first published: 2015-04-08)
1,415 reads
2019-05-03 (first published: 2016-10-05)
22,988 reads
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers