The trigger "prevents" (assuming...

Most people won't even try it because it uses xp_CmdShell but if you use it to call SQLCmd to do the same thing and capture the output of the xp_CmdShell,...

As a bit of a sidebar, the "poor man's" method of auditing that includes a variable width NVARCHAR or VARCHAR column to store the name of the person or thing...

I correct the code in the INSERTED section of the trigger.  Changed to...

, TrnxUserId = i.CrtBy

To do that, you'd first have...

• This reply was modified 4 years ago by Jeff Moden. Reason: Added notes about FKs on audit tables. Heh... "Just sa NO"! :D

p.s. That looks like a shedload of code.  It actually isn't.  The forum software nearly double-spaces code. 🙁 🙁 🙁

Ok... I don't even know how to spell SSRS.  The following creates a test table for others to play with and I use it to create an output that SSRS...

• This reply was modified 4 years ago by Jeff Moden. Reason: Double-up single quotes in the comments because the forum software doesn't handle them correctly

I found the following chart a few days ago.  It's based on "unlimited" attempts instead of a "3 strikes and you're out" methodology.

p.s.  For those getting ready to recommend temporal tables... I love them because they auto-magically do a lot of what I said especially when it comes time to doing point-in-time...

I firmly believe that one shouldn't have to read all of the code to figure out what it does to figure out what section of the code to work with. ...

Does the attendance table that you're deriving the data from actually have 1 row for every day of the school year for every student or is it missing days, such...

• This reply was modified 4 years ago by Jeff Moden. Reason: Added extra question about holidays and other non-school days

It's real simple... Group By does not guarantee the order of the output, period.  Only an ORDER BY will make that guarantee.

It likely has to do with which login on the target of the linked server was used and what the privs are on the target server for that login.

For example,...

Actually, it works in...

I wouldn't even dream of doing this simple thing in PowerShell.   I  also can't help you if you want it done in PowerShell.

If you want it done in T-SQL,...