I'd guess that if XACT_ABORT is OFF then only the statement that's running at the moment of the timeout will be rolled back.  Whether that rollback occurs gracefully and expeditiously...

WITH Last24Hrs AS (
SELECT
VisitID
,IdentifierID
,ActivityDateTime
,DATEADD(HOUR,-24,MAX(ActivityDateTime) OVER (PARTITION BY VisitID)) AS _24HrsBefore
FROM #T1
)
SELECT
VisitID
,IdentifierID
,ActivityDateTime
FROM Last24Hrs t
WHERE t.ActivityDateTime >= t._24HrsBefore;

John

This is a good reference for connection strings.  If you can't find what you're looking for there, just include the SET statement in your code.  Probably best to do...

OK, are you telling me that in case I'm interested, or do you have a follow-up question?  Note that it says "Default connection options" in that dialog box.  As I...

If XACT_ABORT is ON, an error will cause the whole transaction to be rolled back; if it's OFF, only the statement being executed will be rolled back.  When XACT_ABORT is...

I feel your pain.  Presumably you're the DBA?  If you don't get to make...

Better still, from an administrative point of view, would be to create a role and add users to it as and when required.

John

Why can't you use a trigger?  You could investigate SQL Audit instead - I think that would deliver what you're looking for.

John

A SQL audit needn't be too much of a burden.  Set up your filter carefully, limit the file size and the number of files, and import regularly into a database...

No, I think Full recovery mode is mandatory - it says here.  Dealing with transaction log backups isn't too much extra admin, although I suppose you will need a...

The query you posted returns the lowest person_id for every first_name - so you'd get the John with the lowest person_id, the Wally with the lowest person_id, and so on. ...

You can use SELECT TOP 1 with and ORDER BY person_id clause.

John

Linked servers, CMS, OPENROWSET, Policies, SSRS, SSIS - each has its advantages and its limitations and could form the whole solution or part of it.  You'll need to figure out...

No.  I'm not here to do your (home)work for you.  I've given you a link to get you going, and Des has also provided you with a query.  Use both...

Sam

Yes, you can help with execution plans, code smells (of which I've found many in vendor code), deadlock analysis, table and index designs, and so on.  However, if you...