Activity overview
Latest activity by rakshitpatel
Started getting VAS errors and errors with other apps using CLR & SP_OACreate only after upgrading to SQL Backup 6 ! / comments
Started getting VAS errors and errors with other apps using CLR & SP_OACreate only after upgrading to SQL Backup 6 !
It worked. Thanks for the suggestion.
Brian Donahue wrote:
I think xp_cmdshell supports output supression as an option:
xp_cmdshell 'sqldatacompare.exe', NO_OUTPUT
This should stop the console output from coming back in the SQL Server messages stream.
/ comments
It worked. Thanks for the suggestion.
Brian Donahue wrote:
I think xp_cmdshell supports output supression as an option:
xp_cmdshell 'sqldatacompare.exe', NO_OUTPUT
This should stop the console ou...
CLI -Turn off output in results
Is there a way to turn off the results when Data Compare CLI is used from SQL server using xp_cmdshell.
Turn off following output:-
Red Gate SQL Data Compare Command Line Utility V7.1.0.245
=======...
Thanks. Yes @db2 was a typo. The user do have permission. I am running locally. It does create the script.
I ran it from command prompt and there was no error
I ran the command from Management Studio without capturing the return code and it worked and created script.
Its works but give me wrong return code when I capture it.
Chris Auckland wrote:
Thanks for your post.
Exit code 77: Action cannot be completed because the user does not have permission
Does the user that is running the command have the necessary permissions to use xp_cmdshell and/or log into the database requested? Could you try running a command line comparison directly from a command prompt rather than through xp_command shell?
On a side note, and this is probably just a mis-copy when writing the post, but the /db2 switch in your command looks incorrect. I think it is meant to be + ' /db2:' + @db2 + ' /include:table:\['
I hope this helps.
/ comments
Thanks. Yes @db2 was a typo. The user do have permission. I am running locally. It does create the script.
I ran it from command prompt and there was no error
I ran the command from Management Stud...
CLI - Wrong return code
SET @SQLExec = 'C:\"Program Files"\"Red Gate"\"SQL Data Compare 7"\SQLDataCompare.exe /server1:'
+ @SourceServer + ' /server2:' + @DestinationServer
+ ' /db1:' + @SourceDatabase
+ ' /db2:@db2/inclu...