![[Deleted User]](https://assets.zendesk.com/hc/assets/default_avatar.png){kind=avatar}
Comments
Sort by recent activity
Or actually it says
[SQLSTATE 42000] (Error 137) Unclosed quotation mark after the character string ' '' ' / comments
Or actually it says
[SQLSTATE 42000] (Error 137) Unclosed quotation mark after the character string ' '' '
The problem with that is @ sitename is the database name, how does it look through all of the database names? / comments
The problem with that is @ sitename is the database name, how does it look through all of the database names?
I am trying to script this and it is not working, keeps saying I have an extra ' SET @SQL = ' EXECUTE master..sqlbackup ''-SQL "RESTORE DATABASE ' + @sitename +
' FROM DISK = ''''D:\SQLVMDEV10\' + @sitename + '\FULL\*.sqb'''' WITH MOVE DATAFILES TO ''''G:\VirtualRestore'''' , SOURCE = ''''' + @sitename + ''''' LATEST_FULL WITH MAILTO = [url=''ed.watson@swfwmd.state.fl.us]''ed.watson@swfwmd.state.fl.us[/url]',
RECOVERY, DISCONNECT_EXISTING,
MOVE LOGFILES TO ''''G:\VirtualRestore'''' , REPLACE , CHECKDB = ''ALL_ERRORMSGS, DATA_PURITY, EXTENDED_LOGICAL_CHECKS'', DROPDB''', @exitcode OUT, @sqlerrorcode OUT" '' '
Any ideas? / comments
I am trying to script this and it is not working, keeps saying I have an extra 'SET @SQL = ' EXECUTE master..sqlbackup ''-SQL "RESTORE DATABASE ' + @sitename +
' FROM DISK = ''''D:\SQLVMDEV1...
Disregard, it went away later in the day. / comments
Disregard, it went away later in the day.
http://sqlprod40:81/static/3.0.0.1575/S ... esponse.js: 324
Failed
Is the error that I am getting, but did not receive in the EAP. / comments
http://sqlprod40:81/static/3.0.0.1575/S ... esponse.js: 324
Failed
Is the error that I am getting, but did not receive in the EAP.
Well my point was that SQL Compare says the DBs are identical. Shouldn't SQL Data Compare then should not show that 1 table could not be compared unless I am missing something. I can send you screenshots if that would be helpful. / comments
Well my point was that SQL Compare says the DBs are identical. Shouldn't SQL Data Compare then should not show that 1 table could not be compared unless I am missing something. I can send you scr...
Sorry, I get it now, just realized developer did not put an index on this table. Sorry for the inconvenience, but I just wasnt getting it. Thanks for your help. / comments
Sorry, I get it now, just realized developer did not put an index on this table. Sorry for the inconvenience, but I just wasnt getting it. Thanks for your help.