Auditing (Urgent)

[Sejal]

Hello,

How can I audit users logins to particular database? Can I audit to a file or to database?

Any help is appreciated.

Thanks
Priti

[MAK]

I prefer auditing on a table so that i can query it easily.

To audit for a particular database, in the profiler filter it for database name.

Check Profiler properties.

I believe you are using SQL Server.

[Sejal]

I'm using SQL Server 7.0 I would appreciate if you could guide me what events should I use to get the login info of particular database, All the tables are sensitive on that db,should I save the output to file or to database?

Thanks A lot

[MAK]

If you are concerned about only logins, then use security audit in the event list. Store it in a database table