I'm trying to execute a tsql code on a database task. The tsql code executes without any issue on the SSMS. But when manually testing the task from VisualCron I get this error:
Error in SQL query: Must declare the scalar variable "@xxxx".
Exception in Task: Must declare the scalar variable "@xxxx"
What else do I need to do? I thought that the tsql code will be fully executed on the database engine, so no need to declare any variables on task creation. Thanks.
Edited by moderator
| Reason: Not specified