FREE AI-Enhanced Online SQL Server Compiler

Untitled*

You must execute the code again to save those values in the database.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE with override;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE with override;
GO

EXECUTE msdb.dbo.sysmail_delete_profileaccount_sp @profile_name = 'ExcelProLixo'
EXECUTE msdb.dbo.sysmail_delete_principalprofile_sp @profile_name = 'ExcelProLixo'
EXECUTE msdb.dbo.sysmail_delete_account_sp @account_name = 'ExcelProLixoConta'
EXECUTE msdb.dbo.sysmail_delete_profile_sp @profile_name = 'ExcelProLixo'

EXECUTE msdb.dbo.sysmail_add_profile_sp  
    @profile_name = 'ExcelProLixo',  
    @description = 'Perfil usado para notificações do ExcelProLixo' ;  
GO

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp  
    @profile_name = 'ExcelProLixo',  
    @principal_name = 'public',  
    @is_default = 1 ;
GO

EXECUTE msdb.dbo.sysmail_add_account_sp  
    @account_name = 'ExcelProLixoSuporte',  
    @description = 'Conta para envio de notificações ExcelProLixo',  
    @email_address = 'ExcelProLixo@meuemail.com',  
    @display_name = 'ExcelProLixo',  
    @mailserver_name = 'mail.meuemail.com',
    @port = 25,
    @enable_ssl = 0,
	@use_default_credentials = 0,
    @username = 'ExcelProLixo@meuemail.com',
    @password = 'hunter2' ;  
GO

EXECUTE msdb.dbo.sysmail_add_profileaccount_sp  
    @profile_name = 'ExcelProLixo',  
    @account_name = 'ExcelProLixoSuporte',  
    @sequence_number =1 ;  
GO

declare @assunto nvarchar(max) = (select concat('Teste: ',FORMAT (getdate(), 'dd/MM/yyyy, HH:mm')))
exec msdb.dbo.sp_send_dbmail 
 @profile_name = 'ExcelProLixo', 
 @recipients = 'omeuemaildetestes@gmail.com', 
 @subject = @assunto, 
 @body = 'Mail Sent Successfully', 
 @body_format = 'text'

SELECT items.subject,  
    items.last_mod_date  
    ,l.description FROM msdb.dbo.sysmail_faileditems as items  
INNER JOIN msdb.dbo.sysmail_event_log AS l  
    ON items.mailitem_id = l.mailitem_id  
	order by items.last_mod_date desc
GO

Msg 102, Level 15, State 1, Server 992236f938e6, Line 2
Incorrect syntax near 'sp_configure'.
Msg 5812, Level 14, State 1, Server 992236f938e6, Line 1
You do not have permission to run the RECONFIGURE statement.
Msg 15123, Level 16, State 1, Server 992236f938e6, Procedure sp_configure, Line 62
The configuration option 'Database Mail XPs' does not exist, or it may be an advanced option.
Msg 5812, Level 14, State 1, Server 992236f938e6, Line 1
You do not have permission to run the RECONFIGURE statement.
Msg 229, Level 14, State 5, Server 992236f938e6, Procedure msdb.dbo.sysmail_delete_profileaccount_sp, Line 1
The EXECUTE permission was denied on the object 'sysmail_delete_profileaccount_sp', database 'msdb', schema 'dbo'.
SqlState 24000, Invalid cursor state
SqlState 24000, Invalid cursor state
SqlState 24000, Invalid cursor state
SqlState 24000, Invalid cursor state
SqlState 24000, Invalid cursor state