December 11, 2008 at 3:59 am
Hi again guys,
how do u detect the login event ? What command do u use ?
say I want to record all people who login into my database. my database has to have procedure/trigger to DETECT if somebody login to my database, and after the detection I put this logged-in user to another table.
thanks again.
December 15, 2008 at 8:57 am
Here's the BOL link for LOGON triggers:
http://technet.microsoft.com/en-us/library/bb326598.aspx%5B/url%5D
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 15, 2008 at 9:12 am
I'd use Logon triggers as Jack suggested.
December 15, 2008 at 7:34 pm
yes.its Logon trigger.
i was trying it for 2 days and it didnt work on my sql server. in my desperation i posted this thread. then, after i digging the internet, i found out that LOGON Trigger is supported in SQL Server 05 SP2. Its the SP things that made my LOGON trigger invalid event type ! Damn i only have SP 1..
My case solved
thanks guys
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply