MS SQL Server Common operations

The following are common:

--E- mails should be used very often.execMsdb.dbo.sp_send_dbmail@profile_name = @mail_profile,--Mail configuration main file, generated through the Database Mail Configuration Wizard, generally called ' dba_profile ', detailed look                @recipients = @email_recipients,--address, multiple comma-separated                @copy_recipients = @mail_copy_recipient,--cc Address                @blind_copy_recipients = @mail_blind_copy_recipient,--bcc address                @subject = @mail_subject,--Message Subject                @body = @mail_body,--Message Content                @body_format = 'HTML' --This can also be the text

Right-click Edit configuration

The following are not commonly used:

-- Modify Dbowner: Sometimes Management Studio can't open a db's property box, so it might be better to change the dbowner. EXEC ' SA '

MS SQL Server Common operations