Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Centralized Asynchronous Auditing with Service Broker

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-07-16 : 11:06:57
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

478 Posts

Posted - 2007-07-18 : 21:58:32
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
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-07-18 : 23:34:12
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

11752 Posts

Posted - 2007-07-19 : 04:45:32
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

11752 Posts

Posted - 2007-07-19 : 04:57:42
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
   

- Advertisement -