Home Forums SQL Server 2005 T-SQL (SS2K5) sp_send_dbmail @query parameter RE: sp_send_dbmail @query parameter

  • July 12, 2011 at 8:15 am

    #1351603

    For Dynamic command I used the below and it worked.

    set @Command='Execute Database..sp_MySP "' + convert(varchar,@datetime,101) + '"'