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

Idera Virtual Database

Using a Server Trigger to Dropping a Database

This video shows how you can create a server trigger in SQL 2008 to log and/or prevent dropping a database. It's a great into to server triggers.

Duration:
3 mins 46 secs
Skill Level:
100
Rating:
4.19 out of 5
Publish Date:
February 04, 2010
Using a Server Trigger to Dropping a Database Watch Video Now  Watch it later!
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Chris Skorlinski
15 years as Microsoft SQL Server Escalation Engineer specializing in configuration, performance tuninng, and troubleshooting Microsoft SQL Server Replication.

References



Comments
R Michael Lacy on 2/8/2010
Thank you for attaching your demo scripts. Doing so make it much easier to start experimentation.

Renee on 2/8/2010
It was hard to see the video. Also, when would I want to use this kind of server trigger?

Dick Rosenberg on 2/8/2010
Good info but I couln't see any of your code. You have to zoom in on it.

mark brito on 2/8/2010
Critical Stuff!

mark brito on 2/8/2010
The reason it is blurry is because it is high end stuff that they normally charge for you to see. IMHO, Its very valuable code.

Sankar on 2/8/2010
The text was not clear to read. But good to know this content. Great. Thanks.

Mark Weichman on 2/9/2010
most of the value was lost because you didn't zoom in so we could see the code

John on 2/9/2010
Video quality was poor. I found it hard to read the code displayed on the screen.

Ranjith on 2/9/2010
nice one

Steve Harris on 2/9/2010
what are some other options that can be captured at server level triggers? are server level triggers a more recent addition to sql server? what version were they first introduced in?

Christian Bahnsen on 2/9/2010
Great topic and example. Thanks.

Ed Carden on 2/9/2010
What happend to the Demo Script link? I'm getting error page.

Deepak on 2/9/2010
Really too good. Not to be missed.

Don on 2/10/2010
Excellent Idea!

Andy Warren on 2/11/2010
Script link has been fixed, sorry!

steven on 2/12/2010
Most of the videos are very blurry.

I was unaware of this entire category of triggers. Very good to know.

paisan on 2/25/2010
not loud sound,and can't see

suman on 6/19/2010
good one



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