SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Takes Query Plan Analysis and Performance Monitoring to a New Level

Using Database DDL Triggers

In this short demonstration, you'll learn how to use DDL database triggers to prevent changes to product and audit changes to comply with Sarbanes-Oxley and other change management requirements.

Duration:
7 mins 54 secs
Skill Level:
200
Rating:
4.40 out of 5
Publish Date:
July 14, 2006
Using Database DDL Triggers You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Brian Knight
Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

References

There are no downloads or recommended reading links for this video

Comments
redondoj@gmail.com on 10/14/2008
Good video. Excellent contents.

Tatyana on 8/8/2009
thank you ,exellent. Very usefull could you please add something about data warehousing for SSAS? Regards,

Leo Njampa on 8/17/2009
Excellent video.

rupesh sharma on 9/11/2009
wonderful...really helpful

rupesh sharma on 9/11/2009
wonderful...really helpful

phuc bui van on 10/7/2010
good

A Alagu Ganesh on 10/14/2010
Good

MohanD on 10/19/2010
Excellent. Where's's the Source code though ?.. I do not see the Source script.

Ming on 1/21/2011
like it

Charlie Bruno on 2/16/2011
Very informative and well explained.

Dhanson on 2/16/2011
I like that the examples are simple to follow and well explained.

3D2955A2F8 on 2/16/2011
Great session! Thanks!

Will Casey on 2/16/2011
good control mechanism

Keith Cooper on 2/16/2011
great information. presented well too.

Kevin Bayer on 2/16/2011
Good stuff...

John Breidenbach on 2/16/2011
Greate function. I didn't know that existed.

Ian Wilson on 2/16/2011
Too nervous!

Balamurugan on 2/16/2011
when i try to get the example script. i could n't able to download it.

Dave on 2/16/2011
Like the fact that the roll back trans was left in the video, as it highlighted a very good point about the position of statements.

Ganesh P on 2/17/2011
Excellent

Shellz on 2/21/2011
Nice touch with restricting the time of day. Those details are what make these videos great!

Gil on 2/22/2011
Seems like it should have been >= 7 rather than >7, since the intent was to block changes after 7am, and this would allow them until 7:59:59.

Michael Irwin on 2/22/2011
essential knowledge for auditing for security demos

Maurice Ivory on 3/3/2011
This video has taught me quite a few things about triggers. Now I feel that I can do triggers and be comfortable when doing them

Rajendiran on 3/14/2011
Its very nice tutorial

Rajendiran on 3/14/2011
nice

Bruce Bealer on 4/7/2011
Very good

Very valuable ...

Srinivas Annadi on 4/7/2011
Very brief and nice example

Raymond on 4/7/2011
Thank You!

Ameena on 4/7/2011
I will look forward to more granular DDL triggers. I like to see logon triggers usage at the server level as a security mechanism.

Don Weigend on 4/8/2011
How do you get around the rollback causing the audit table entry being rolled back as well?

MohanD on 4/8/2011
Good n Great, Instead of a allowing someone to allow execution in a time frame, we have used the generic logins, & the corporate logins for the SQL Server. Most DB user's can Login to the DB with a set of two or more credentials, so the point is to stop users from using their generic logins for DDL: Operations. Good n Great. !logic

James Morrison on 4/8/2011
Thanks. The example script link is not working

Charlie Bruno on 4/9/2011
Very good presentation.

ravi on 4/10/2011
nice, please provide information about locks and transactions

Kasey Wheeler on 4/11/2011
Great intro video on DDL triggers.

Keith Badeau on 4/29/2011
@Balamurugan what I do usually is pause the video and open notepad++ and type in the script manually from the video a section at a time. I like doing this better even if I can download it because it familiarizes me with the script before I even start analyzing and executing it. Hope this helps you, it's just what I do you can take it or leave I guess. ;)

Michael on 8/4/2011
There were too many mistakes

Maurice Ivory on 8/22/2011
This was okay....



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions