I have created this blog to learn more and more about SSIS and Sql server.
Here you will find posts about Control Flow Task, Data flow transformation and lot more. I have tried to explain transformations and tasks through simple scenario and example.
I hope this would help you
Thursday, October 17, 2013
How to stop any user from dropping any database
How to stop any user from dropping any database
you can prevent casual database deletions with a trigger:
CREATE TRIGGER STOP_DB_DROP ON ALL SERVER FOR DROP_DATABASE AS PRINT 'You are not allowed to DROP databases' ROLLBACK;
Is this create trigger statement will work on SQL server?
ReplyDeleteThanks for the fantastic educational points - That's really amazing tour arrangements.
ReplyDeleteOnline Flight Booking | Low Cost Flights Tickets