However, profiler is not logging anything in between the two instructions that should be parsed, but I still see the error! Any ideas what I need to do to see the content that is supposed to be parsed by the server? Which columns, events to trace? I’ve tried to use profiler, but although I can see the SQL commands: SET PARSEONLY ON It seems like the use of SQLCMD is actually testing whether the PRODCOPY database exists, which of in this case it doesn’t. If I comment out the section: IF DB_ID('PRODCOPY') IS NOT NULL Incorrect syntax was encountered while parsing :setvar.
The error is: A fatal scripting error occurred. we need to clear the existing PRODCOPY users backup the existing PRODUCTION database :setvar backuppath = "e:\sql\restore\PROD.bak" I have the following script using SQLCMD setvar, but I receive an error when I parse the script: :setvar dbname "PROD"
0 kommentar(er)
