sql service broker

  • Hi

    Need help on getting code and info on

    service broker (for sql server 2005 only)

    for auditing DML commands.

    Respond if any.

    Thanks

  • Why the service broker?

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

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

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

  • 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?

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

  • 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?

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

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