Hi everyone!
Can anyone tell me if it's possible to set up some kind of a trigger that will write out to a file or a table and log details of all database connections?
ie: user, datetime of connection, database connected to, etc.
Any help appreciated.
Cheers,
MeganHi Meagan ,
Use SQL Profiler and run a trace you will then see which user connected to which database and at which time they did so ...and more.
Regards
Burner
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment