sql service broker

Question

Post reply

sql service broker

mukki

SSC Rookie

Points: 47
More actions
May 5, 2013 at 9:13 am

#147762

Hi
Need help on getting code and info on
service broker (for sql server 2005 only)
for auditing DML commands.
Respond if any.
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

e4d4 SSCertifiable Points: 5777 More actions · Answer 1

Why the service broker?

You should use DML Triggers http://msdn.microsoft.com/en-us/library/ms191524%28v=sql.105%29.aspx

mukki SSC Rookie Points: 47 More actions · Answer 2

thanks...yaa but i need to use service broker for DML auditing. is it feasible in sql 2005?

mukki SSC Rookie Points: 47 More actions · Answer 3

thanks...yaa but i need to use service broker for DML auditing. is it feasible in sql 2005? i cant use triggers.

e4d4 SSCertifiable Points: 5777 More actions · Answer 4

No, service broker is for asynchronous processing. But you probably could put a message to the SB from DML trigger or an audit SP.

What do you want to achieve?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Is there a reason you can't use database triggers to capture/audit DML actions?

mukki SSC Rookie Points: 47 More actions · Answer 6

hi.. i used c2 audit mode n why i shud use triggers as i dont need data but only audit log of that...also trigger is hampering perf ...so suggest cn i use ser broker code without using triggers?