Comments
Sort by recent activity
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...
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...