logon event in SQL Server 2008 Management Studio express

[DaveBenson]

Hi,
Does anyone know if it is possible trap a logon event in SQL Server 2008 Management Studio express? I want to use it to activate a procedure every time anyone connects to the database. I have tried setting up a logon trigger and also tried to dabble with the service broker but without success. From looking on line, I gather this can be done with full version – however I am wondering if it is simply not possible to do on express version. Any help would be much appreciated!

Dave

 

[gmmastros]

Take a look here:

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/sql-advent-2011-day-13

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

I assume it's your thread here

http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/19b482b2-aa72-45a9-bb61-11dc4ed6f6ed

PluralSight Learning Library

 

[DaveBenson]

Hi,

Yes it was my thread. Have found a way around it now. Sorry for not closing thread earlier.