All Questions
3 questions
7
votes
2
answers
3k
views
Enabling admin connection on SQL Server Express to fix logon trigger
Well, luckily I got this error on my test environment. I'm so scared about this error that I disabled all logon triggers I was using on production environment.
I created the famous logon trigger, ...
- 7,484
5
votes
1
answer
5k
views
Is Service Broker the best choice for auditing data changes on SQL Server Express?
My project is to audit 5 to 10 existing tables in our system without prolonging transactions. Whatever method is used, it has to work on SQL Server Express 2005 to (eventually) 2016.
I've done ...
- 1,093
2
votes
2
answers
3k
views
Trigger to create a variable Table to be sent to service broker
I've setup a service broker for the first time and tested it... Looks good.
Everytime a DML operation happens on a specific table; Let's say the Price Table, a trigger calls a stored procedure passing ...
- 1,093