|
|
-
|
|
Get Database Size,owner,Crated Date using Single Procedure...
|
|
-
|
|
Find Match and not match Data Using Binary_CheckSUM...
|
|
-
|
|
Search Objects (Table Name, Procedures, and View) from Jobs...
|
|
-
|
|
Search Objects (Table Name, Procedures, and View) from databases...
|
|
-
|
|
1)How to Create User Define Role?
2)How to Give Particular Access to Role?...
|
|
-
|
|
1) For This Post How to send Alert when jobs are fails?
2) For this Post you can reduce your Database jobs monitor burden.
...
|
|
-
|
|
1)In SSMS Job is wonderful task for us.it's use for our work automated,for job you can remove your manual work.
2)In job you can scheduled your own task like Backup database,Rebuild index,Daily Send mail who's Employees are not login,Daily send SMS etc
...
|
|
-
|
|
1)I have discussed previous post for Database Mail Configurations after this you can
Send mail thorough System Store procedure.
2)You can Create your own procedure and send mail Any alert or any attachment through this system store procedure.
...
|
|
-
|
|
1)This Post Use for Sending mail through Database and also use for sending alert from database.
2) In this post you can understand how to configure your mail-id with sql server....
|
|
-
|
|
Pivot Command is very Useful when you want to Get data from Row wise to Column wise Data....
|
|