It would much easier to provide a working solution if you provided a small set of sample data and the expected output. I've read your post several times and...

Can you post the code you are using. I just tested using this:

DECLARE @data NVARCHAR(MAX) = 'EXEC Proc_gen @PsID=12, @kID=-1, @ID=3183';

SELECT @data AS theData ,

...

I don't think that there is a way to do what you are requesting. Database triggers are only for DDL statements, not DML statements.

Sure the trigger that SQLSACT...

The IIF is an inline IF statement so the expression I provided says, if the value for the parameter is empty then don't bother adding that parameter to the query...

I think that the offline property is a package property pre-SSIS 2012, so you need to look for that property on the package itself.

Adapting my query to do what you want isn't that difficult. Something like this will do it (I'm only showing weekly, but you could do all of them either...

Dird,

I am not aware of any bugs with the generation of identity values. There are 3 ways you can get gaps in identity values:

1. Failed inserts. This...

I think option #2 is probably the simplest option since Linked Servers aren't an option. Implementing option 2 could be as simple as a single SSIS package that runs...

This is an interesting problem. It seems like, and I haven't tried this so I don't know for sure if it'll work, you need to have a Table with...

In my opinion, the best way to solve this would be by using an expression in the query for your main dataset that evaluates the selection in the hair product...

Since you said in T-SQL I won't bother trying a PoSH solution. The way I'd typically do something like that is to use a linked server from DEV to...

Sorry, I missed the "how to avoid it part" in my first post confirming the behavior. I actually had a hard time duplicating the behavior until I used a...

All right. I ran a test using an XEvent session to get the locks acquired by DBCC CHECK_IDENT with a RESEED. The important locks acquired are a SCH-M...

I believe this might get you started.

WITH stalls

AS ( SELECT LEFT(Physical_name, 1) DriveLetter ,

...

I can't find "AUdit Action Type" in an audit. I see an action and a class. Here's a query I'd potentially use:

SELECT *

FROM sys.fn_get_audit_file([Path],

...