date/time. I would insert a row at logon and then select that row from inside the trigger. Do you know of a better way?
sysprocessesfrom your trigger to record any changes to your database the specific user makes. I hope this helps!
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Kevin Kline
Monitoring and Administration expert Kevin Kline discusses the obstacles of database administration when a publisher resides on a different domain.continue reading
A common SQL Mail error is addressed by monitoring and administration expert Kevin Kline.continue reading
Monitoring and Administration expert Kevin Kline discusses the installation of SQL Server client tools on Windows XP Pro.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.