Provisioning sanitized data with SQL Clone and Data Masker. Watch now.
Issues running ALTER PROCEDURE statements in T-SQL mod scripts
I'm trying to incorporate a SQL script into the image creation process within SQL Clone, however I cannot seem to run an ALTER PROCEDURE statement as we get the following error:
System.Data.SqlClient.SqlError: Incorrect syntax near the keyword 'PROCEDURE'.
Note that the use case is that our backups from production include stored procedures that have connections to production linked servers, and we need to replace these in our image to ensure they do not get cloned.
Without resorting to wrapping the whole procedure as a string and executing it as a statement, is there a way to run this?
Are there also any rules about using GO statements or comments, like in SQL Cmd mode?
0 · Share on Twitter