I have set up service broker (for the first time) and event notifications to
1. log the following ddl/trace events (create db, alter db, drop db and restore db)
2. delete and then insert a list of all databases to a table in the current database
this all works fine except after the event fires the table containing the list of databases only contains one row - for the current database
Is this a security issue with service broker or am i barking up the wrong tree?
