Search code examples
sqlsvnxp-cmdshell

How to Execute SVN Update command through SQL xp_CMDShell

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

Solution

  • 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.