Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Doubt on trigger Expand / Collapse
Author
Message
Posted Tuesday, September 24, 2013 12:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 11:43 PM
Points: 148, Visits: 425
Hello Everybody,

I have a table and sp . I want no one to drop those. Am I able to set instead of trigger for this.

Else is there any other way to achieve that.

Thanks in advance
Post #1497666
Posted Tuesday, September 24, 2013 8:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:31 PM
Points: 13,207, Visits: 12,688
You can do that with database triggers. Lowell shows a great example of it here. http://www.sqlservercentral.com/Forums/Topic1141863-338-1.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1497873
Posted Tuesday, September 24, 2013 9:32 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:31 PM
Points: 4,435, Visits: 6,336
DDL triggers. However, these can be disabled by users with sufficient permissions so they are not fool-proof.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1497946
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse