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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 General Reporting

Author  Topic 

RobMarsh
Starting Member

28 Posts

Posted - 2002-12-30 : 09:11:05
Hi,
Are there any system tables that keep a log of who logged in when and did what? I have a requirement to generate some reports that cntain this kind of data.

Thanks,

Rob

royv
Constraint Violating Yak Guru

455 Posts

Posted - 2002-12-30 : 09:21:02
The short answer is no. You will have to design something to do this.

***************************************
Death must absolutely come to enemies of the code!
Go to Top of Page

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-12-30 : 11:43:24
You can put in your own auditing or you can have a look at a new tool from lumigent (makers of the excellent Log Explorer) called Entegra [url]http://www.lumigent.com/Products/entegra/entegra.htm[/url]


HTH
Jasper Smith
Go to Top of Page

RobMarsh
Starting Member

28 Posts

Posted - 2002-12-30 : 13:03:00
Thanks for that - I'll look into the Entegra tool..

Rob

Go to Top of Page
   

- Advertisement -