I have a stored procedure to truncate tables and it works absolutely fine in SQL Server
EXEC [staging].[USP_TruncateTables] @tableName = 'example', @SchematableName = 'staging.example';
So I can use this truncate Script for all the staging tables
However I set it up in Data Factory (And I have tried both ways. I have added it in the Copy Script
And I also tried by removing the above and adding a Stored Procedure Activity

But both produce the same error message
"errorCode": "2402",
"message": "Execution fail against sql server. Sql error number: 1088. Error Message: Cannot find the object \"example\" because it does not exist or you do not have permissions.",
"failureType": "UserError",
"target": "Stored procedure1",
"details": []
I dont think there is any issues with the User and Role because I have all the EXEC SELECT UPDATE etc permissions required. I cannot currently get past this issue.
If anyone has any ideas that would be great