Tried with @execute_query_datebase='Database' Still no luck

Step need to just fetch the data from table by using select statement and the result needs to attach in email notification.

That is the objective.

Hi Anthony,

I tried with Execute as well getting issue ,Tried with table same error.user have admin access,Tried with sa user too still same issue.

DECLARE @query NVARCHAR(MAX)

DECLARE @query1 NVARCHAR(MAX)

SELECT @query1='select *...