Trigger for new Database

I got a mail asking for trigger on new Database

I need to implement a trigger to email me when someone creates a database on a server without letting me know.I dont know how to write the trigger.Can you help please?

How to find Index information - sp_msindexspace,sp_helpindex,sp_mshelpindex

Index are very important part for any database.
We need to regularly monitor index and maintain index for better performance of the system.
I have already written an article on how to find highly used index

sp_changesubscription for changing subscriber password

For DBA its a routine activity to change server passwords.
If we are using replication between servers and if we are changing password of subscribers
we have to change it on publisher also.

we can use sp_changesubscription here to change password for the subscriber.

We can use it for changes the properties of a snapshot or transactional push subscription or a pull subscription involved in queued updating transactional replication

Popular Posts