RE: spontaneously made login
From: DB_Princess (anonymous_at_discussions.microsoft.com)
Date: 02/20/04
- Next message: anonymous_at_discussions.microsoft.com: "Re: EM losing Server registrations in XP"
- Previous message: Hobbes: "Linked server from SQL Server to Access db on network share?"
- In reply to: rich: "spontaneously made login"
- Next in thread: Rich: "RE: spontaneously made login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 19 Feb 2004 15:51:07 -0800
I try to capture the machine name with an api and pass that in with the other session info so that I have something to tie that user to the spid and to the other info entered by that user. Then, I have triggers on the tables I need to audit and use the @@SPID variable in a trigger to write the spid and related info into a tracking table. That way, I can associate the user with a machine name with a spid with a transaction, thereby creating the audit trail.
- Next message: anonymous_at_discussions.microsoft.com: "Re: EM losing Server registrations in XP"
- Previous message: Hobbes: "Linked server from SQL Server to Access db on network share?"
- In reply to: rich: "spontaneously made login"
- Next in thread: Rich: "RE: spontaneously made login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
