declare @body1 varchar(4000)
declare @body2 varchar(4000)
DECLARE @tab char(1) = CHAR(9)
DECLARE @CRLF char(2)
SELECT @CRLF=CHAR(13)+CHAR(10)
--@query_result_separator=
set @body1 = 'Please find the attached list. '
+@CRLF+ N'Thanks, SQL DBA Team.'
EXEC msdb.dbo.sp_send_dbmail
@profile_name='sqldbmail', --- Please chnage the profile name
@recipients='Compliance@ajeyudu.com', -- Please change the email address
--@blind_copy_recipients='SQLADBA@ajeyudu.com',
@subject = 'ajeyudu database:-AC-206 control to audit permissions Monthly Report.', --- Please change the subject line as per your requirement
@body = @body1,
@body_format = 'HTML',
@query = 'Select * from DB_Name..object_name', --- Select select statement
@query_result_header = 1,
@query_result_separator =@tab,
@exclude_query_output = 1,
@append_query_error = 1,
@attach_query_result_as_file = 1,
@query_attachment_filename = 'Ajeyudu_SY_USR.csv', -- File name
@query_result_no_padding = 1
declare @body2 varchar(4000)
DECLARE @tab char(1) = CHAR(9)
DECLARE @CRLF char(2)
SELECT @CRLF=CHAR(13)+CHAR(10)
--@query_result_separator=
set @body1 = 'Please find the attached list. '
+@CRLF+ N'Thanks, SQL DBA Team.'
EXEC msdb.dbo.sp_send_dbmail
@profile_name='sqldbmail', --- Please chnage the profile name
@recipients='Compliance@ajeyudu.com', -- Please change the email address
--@blind_copy_recipients='SQLADBA@ajeyudu.com',
@subject = 'ajeyudu database:-AC-206 control to audit permissions Monthly Report.', --- Please change the subject line as per your requirement
@body = @body1,
@body_format = 'HTML',
@query = 'Select * from DB_Name..object_name', --- Select select statement
@query_result_header = 1,
@query_result_separator =@tab,
@exclude_query_output = 1,
@append_query_error = 1,
@attach_query_result_as_file = 1,
@query_attachment_filename = 'Ajeyudu_SY_USR.csv', -- File name
@query_result_no_padding = 1
No comments:
Post a Comment