<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
sql auditing triggers
sql auditing triggers
Rate Topic
Display Mode
Topic Options
Author
Message
nzubaria
nzubaria
Posted Saturday, October 18, 2008 2:43 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, June 23, 2009 3:05 AM
Points: 2,
Visits: 35
I have to write DDL trigger in sql 2005, using CLR feature. Can anyone provides help in this regard
Post #588094
GilaMonster
GilaMonster
Posted Saturday, October 18, 2008 3:16 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742,
Visits: 30,021
What do you want to do with said trigger and why do you have to use CLR?
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #588099
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Sunday, October 19, 2008 11:43 AM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436,
Visits: 13,751
There is information in Books Online on DDL triggers and lots of articles on CLR programming. In addition to Gail's questions, you should do some research and ask specific questions, not an open one about how to do all of some project.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #588287
nzubaria
nzubaria
Posted Tuesday, October 28, 2008 11:18 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, June 23, 2009 3:05 AM
Points: 2,
Visits: 35
Hi
Actually I am Developing a Database Auditing Infrastructure. I am working in SQL Server 2005.
So my main focus of area is "SQL Triggers" and "stored Procedures". I ask for help on CLR routine i thought it would help me.
If you can me some other suggestion. I would be thankful to you.
Secondly can you suggest me a way that is there any possibility of writing Generalized DML triggers on all tables of database or not ???
Thanks for fast Reply
Regards
Post #593389
GilaMonster
GilaMonster
Posted Wednesday, October 29, 2008 1:04 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742,
Visits: 30,021
nzubaria (10/28/2008)
Hi
Actually I am Developing a Database Auditing Infrastructure. I am working in SQL Server 2005.
So my main focus of area is "SQL Triggers" and "stored Procedures". I ask for help on CLR routine i thought it would help me.
Anything dealing with data is probably better written in T-SQL than CLR, unless you have a good reason to need the CLR
If you can me some other suggestion. I would be thankful to you.
Secondly can you suggest me a way that is there any possibility of writing Generalized DML triggers on all tables of database or not ???
It is possible, but I would strongly recommend against it. Generic triggers tend to perform poorly, leading to slow data changes, deadlocks and all other such unpleasant things.
What I've done in the past is to have a stored procedure that can, using dynamic SQL, create triggers on all tables. That way you only have to write the code once, but the triggers are specific to their tables and hence reasonably fast.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #593409
kevin_nikolai
kevin_nikolai
Posted Monday, January 07, 2013 2:51 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:19 PM
Points: 141,
Visits: 388
Both a trigger and cdc (change data capture) can be enabled to monitor changes to a table. When would you use each of them ?
Post #1403882
GilaMonster
GilaMonster
Posted Monday, January 07, 2013 3:04 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742,
Visits: 30,021
Please post new questions in a new thread. Thank you.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1403886
kevin_nikolai
kevin_nikolai
Posted Tuesday, January 08, 2013 3:20 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:19 PM
Points: 141,
Visits: 388
Thanks Gail, created thread 'SQL 2008 R2 - CDC or Trigger'
Post #1404463
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
