Log de user access - SQL Server Forums

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 Development (2000)

Log de user access

Author

Topic

joao.pinto@adrisoft.com
Starting Member

1 Post

Posted - 2006-04-05 : 07:38:18

Hi there,

Someone can give me one example of one trigger that fires when a specific user log on/ log off on the sqlserver on a specific database.

Thanks in advance

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2006-04-05 : 09:32:23

I think 2005 can do this, but not SQL Server 2000.

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-04-05 : 10:02:33

I think, the Profiler can be used to do that

Srinika

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2006-04-05 : 10:28:57

Use Profiler to fire a trigger? I think not...

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-04-05 : 10:56:48

blindman,

1. I meant not to fire a trigger, instead use it to capture whenever the users login / logout

2. I think following can be used as a trigger as well.
http://solidqualitylearning.com/blogs/dejan/archive/2004/11/25/214.aspx

Srinika

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2006-04-05 : 12:46:29

quote:
Originally posted by Srinika
2. I think following can be used as a trigger as well.
http://solidqualitylearning.com/blogs/dejan/archive/2004/11/25/214.aspx

A hack, but an ingenious hack...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources