SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Centralized Asynchronous Auditing with Service Broker
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 07/16/2007 :  11:06:57  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
Service Broker is a new feature in SQL Server 2005. It is an integrated part of the database engine and it provides queuing and reliable direct asynchronous messaging between SQL Server 2005 instances only. In the future this is planned to be extended to non-SQL Server instances. This article shows how to use Service Broker and triggers to capture data changes.

Read Centralized Asynchronous Auditing with Service Broker

efelito
Constraint Violating Yak Guru

USA
478 Posts

Posted - 07/18/2007 :  21:58:32  Show Profile  Visit efelito's Homepage  Reply with Quote
This looks like exactly the type of solution I've been searching for. Has the author or anyone else for that matter run this in a production environment for any length of time? Are there any major draw backs to this type of auditing in a large OLTP environment? I'm anxious for part two of this article to get more information on configuring service broker across servers. Can you recommend any good service broker learning resources?

Thanks for the article.

Jeff Banschbach, MCDBA
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2884 Posts

Posted - 07/18/2007 :  23:34:12  Show Profile  Visit jezemine's Homepage  Reply with Quote
good article!

one little comment is that your TestDatabase.sql script fails on a server with case-sensitive collation, because the Person.ID column is referenced as "id" later on in the script, thus:

UPDATE Person
SET DateOfBirth = '19800217'
WHERE id = 5

why do I have a case-sensitive collation on my server? The only reason is so that I am guaranteed that any code I write will work on any server that happens to be case-sensitive (some of my customers use it, so I force myself to use it also).



elsasoft.org
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11749 Posts

Posted - 07/19/2007 :  04:45:32  Show Profile  Visit spirit1's Homepage  Reply with Quote
efelito:
i've run it on production for a month withoput problems, but note that this production environment wasn't very high transactional.
you'll have to try it for yourself

jezemine:
you know i haven't even thought about server collation. thanx for the tip.


_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11749 Posts

Posted - 07/19/2007 :  04:57:42  Show Profile  Visit spirit1's Homepage  Reply with Quote
well the only "good" resource is service broker forums on MSDN:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=91&SiteID=1

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000