How Do I Find SSIS Packages that Exist in Multiple Folders?
Introduction
If you are using SQL Storage for your SSIS packages and have multiple folders to make life easier then there...
2010-04-19
295 reads
Introduction
If you are using SQL Storage for your SSIS packages and have multiple folders to make life easier then there...
2010-04-19
295 reads
Introduction
The stored procedure I am posting today will kill all sessions for users that are members of a given domain...
2010-04-14
497 reads
Introduction
Today I am taking a little detour from the scripts I have been posting to take part in “T-SQL Tuesday...
2010-04-13
427 reads
Introduction
Here is another utility stored procedure that I use. This stored procedure will tell you how a user has access...
2010-04-12
315 reads
Introduction
Trying to keep the streak alive so here is my 5th blog post in 5 days. This one is another...
2010-04-09
2,190 reads
Introduction
I recently moved a database from SQL 2000 to SQL 2005. It was really just a matter of detaching the...
2010-04-08
383 reads
Introduction
I was looking at one of my servers and was caught off-guard by how many individual users had been granted...
2010-04-07
512 reads
Introduction
From time to time I get asked to check if a stored procedure is still used in preparation for dropping...
2010-04-06
478 reads
Introduction
I was recently working a production issue that required me to log in via the Dedicated Administrator Connection (DAC). When...
2010-04-05
337 reads
Introduction
In an earlier post I walked through the diagnosis of a problem with TokenAndPermUserStore bloat in SQL 2005.In this post...
2010-03-25
1,072 reads
By DataOnWheels
What a year … At the end of May 2024, I went on full...
By Steve Jones
I wrote an editorial on the view of GenAI tech from execs and someone...
By Rohit Garg
Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch...
Comments posted to this topic are about the item Managing Fabric Lakehouse objects with...
Comments posted to this topic are about the item IT Unionization
Comments posted to this topic are about the item How Many Nested Triggers?
I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?
See possible answers