Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLboom
Yak Posting Veteran
63 Posts |
 Posted - 2004-10-06 : 10:34:22
|
| Hi, i wanted to know if there's any way to fetch the data of anyone connecting to my sql server. I tried creating a trigger on the system table where this entry goes but sql server does not allowed that. So, does sql server has anything the data of anyone logging in can be maintained on adhoc basis.Thanks |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2004-10-06 : 11:02:03
|
| What I have done to capture this information is created a scheduled job that runs every five or ten minutes to perform the equivalent of an sp_who2 against the SQL Server instance. The results are stored in a table. Our auditors are happy to know we are tracking SQL Server access and it has also come in handy in troubleshooting efforts.Another option is to audit successful login attempts, which we are required to do. The downside is that looking for error messages in the log becomes tedious due to all of the successful login entries in the log. The successful login entries are also less informative with this approach. Dave |
 |
|
|
|
|
|
Login Data