I got one task related to database backups, it is like
When user tried to Delete a database in the server.
1) log the user id, DateTime in some Logtable.
2) Take backup of the database before it is deleted.
I know SQL Server have 'DDL Triggers' at server level and database level, I don't know how to use this related to the task given.
If any one know about this please help me.
Thanks in advance
Mobile Application Development