All Questions
Tagged with sql-server-express trigger
4 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, ...
- 1,456
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 ...
CommunityBot
- 1
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 ...
- 70.5k
5
votes
2
answers
1k
views
Transaction independent writes inside a trigger
I am using sql express 2008 r2 express edition.
Is it possible to do writes inside a trigger independent from the the transaction of the statement which causes the trigger to fire?
I have triggers ...
CommunityBot
- 1