Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

During working for script to send mail alerts, i just learned as we can change display name for the mail at runtime. It will normally use profile name or display name which configured in database mail profile for mail. Below query will use display name ...

During working for script to send mail alerts, i just learned as we can change display name for the mail at runtime. It will normally use profile name or display name which configured in database mail profile for mail. Below query will use display name ...

During working for script to send mail alerts, i just learned as we can change display name for the mail at runtime. It will normally use profile name or display name which configured in database mail profile for mail. Below query will use display name ...

During working for script to send mail alerts, i just learned as we can change display name for the mail at runtime. It will normally use profile name or display name which configured in database mail profile for mail. Below query will use display name ...

During working for script to send mail alerts, i just learned as we can change display name for the mail at runtime. It will normally use profile name or display name which configured in database mail profile for mail. Below query will use display name "Ma

Just learned from pinal's blog that by using SSMS, we can generate various reports also. Suppose, we can generate the report of top queries by average CPU Time or average IO Time etc. In SSMS, Right click on server name-> Reports -> Standard Re...