June 25, 2012 at 2:19 pm
Hello,
I need to implement service broker functionality in my system for audit trail. Can some one give a small example for the same?
Regards,
Aman
June 25, 2012 at 3:01 pm
Doing audit trails or using Service Broker? Audit trails are relatively easy. Service Broker is a minefield if you've never worked with it before.
I recommend you start with Adam Mechanic's Workbench on it, you'll find the first article here:
http://www.simple-talk.com/sql/learn-sql-server/service-broker-foundations-workbench/
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 26, 2012 at 8:38 am
Hey Craig,
For doing audit trails asynchronousally we need to use service broker right?
regards,
aman
June 27, 2012 at 4:17 pm
amanmeet.mehta 46966 (6/26/2012)
Hey Craig,For doing audit trails asynchronousally we need to use service broker right?
regards,
aman
Usually, yes. There are alternatives but that's your best internal bet if you're trying to dump your audits off to another server or want to make sure any reporting being done from the audit structures don't block your primary transactions. One of the huge things internal Service Broker gives you is point-in-time consistency for asynchronous passes that may have been incomplete while the data was complete.
It's just a very deep hole until you see the sunlight on the other side. Once you've got it though, you're good to go, and it's well worth your time.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply