0

I have installed Tortoise SVN on my machine, i want to update my local copy with SVN using SVN UPDATE command. I am using SQL script 

 EXEC master..xp_CMDShell 'svn update D:\SVN_WorkingFolder'

This script is not executing. May i know where i am doing workng.

Thanks in advances guys. KumaR

guido
  • 18,864
  • 6
  • 70
  • 95
user1453689
  • 1
  • 2
  • Does "svn update D:\SVN_WorkingFolder" work from a normal command line prompt? – Frank Schmitt Sep 24 '12 at 12:48
  • Yes, SVN update works on command prompt.. I have tried SVN CLEANUP command which is working fine. EXEC master..xp_CMDShell 'svn cleanup D:\SVN_WorkingFolder', but SVN UPDATE is not working. – user1453689 Sep 24 '12 at 12:52
  • Does xp_CMDShell support output redirection? If yes, you could try svn update D:\SVN_WorkingFolder > D:\svn_update_log.txt - perhaps the command output will tell you why it fails. – Frank Schmitt Sep 25 '12 at 06:22
  • Hai Frank, i creaked the solution. it is issue with permissions to access network. Now i can do svn update. Thanks for your efforts. – user1453689 Sep 25 '12 at 07:50
  • Then I'd suggest you add an answer to your own question in which you describe how you solved it (so if someone else encounters the problem, they know what to do). – Frank Schmitt Sep 25 '12 at 08:51

1 Answers1

0

Script execution process won't complete because of insufficient permissions to access network. We won't get any error message or output redirection.

Steps to give permission: Services--> SQLServer2005--> Properties-->Log on-->This account--> Provide local user credentials. Now restart SQL server then execute above SVN update command it will work. Even we can execute batch file to do this job.

user1453689
  • 1
  • 2