Comments
Sort by recent activity
Bryan,
Thanks for Replying. However using your code sample only gives me
Incorrect syntax near '+'.
I keep fiddling and chaning quotes but nothing is helping.
Here I stripped everything but the one variable: EXEC master..sqlbackup '-SQL " BACKUP DATABASE Staging_116 TO DISK='''+@iBackUpLocation+''' WITH INIT " '
One last additional comment
If I take the following: BACKUP DATABASE Staging_116 TO DISK=''' + @iBackUpLocation + ''' WITH INIT
highlight it and check syntax I get no errors. / comments
Bryan,
Thanks for Replying. However using your code sample only gives me
Incorrect syntax near '+'.
I keep fiddling and chaning quotes but nothing is helping.
Here I stripped everything but the one...