How Get An Alert When Your SQL Server Restarts

preview_player
Показать описание
DECLARE @subject VARCHAR(max)
SET @subject ='SQL Server lenovo Instance Restarted On '+ +CONVERT(VARCHAR(12),GETDATE(),107)

@profile_name = 'giveyourdbmailprofiename',
Рекомендации по теме
Комментарии
Автор

Hi can you give the procedure to create mail profile to send mail from SQL server database

bikashnayak