Activity overview
Latest activity by Dsteyer
Symantec Anti-Virus
I installed SQL Data Compare on my computer and began a data compare project. As the project was running Symatec pooped up with the following:
Scan type: Auto-Protect Scan
Event: Security Risk Foun...
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...
Help with Parameters
Hi Everyone. First love the product so far. Was wondering if I could get some syntax help though with Parameters. Here is my old non SQLBackUp syntax:BACKUP DATABASE @iDataBaseName TO DISK = @iBac...