Post reply

xp_cmdshell and Visual Source Safe(VSS)

  • January 29, 2003 at 1:47 am

    #158820

    Hi Guys

    I am trying to run a vss command through xp_cmdshell, and as u might have guessed, i am not having much luck!

    I can run other normal dos commands through xp_cmdshell and they work fine, the moment i try one of VSS command line options, it just hangs!..the vss command is 'DIFF', which finds the difference between 2 files, a file stored in a windows folder and a file stored in the VSS database. the command is a self-terminating command.

    I tried putting the command in a batch file and ran it from the command prompt and it works fine, the moment i try it through xp_cmdshell it just hangs and hangs and hangs!!!

    Any IDEAS???

    Please help!

    Thanks in advance!

    Rennie

  • February 3, 2003 at 12:00 pm

    This was removed by the editor as SPAM

  • February 3, 2003 at 12:58 pm

    #447876

    Permission issue maybe? Alternative might be to use sp_oa~ procs to do it via automation.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • February 3, 2003 at 11:28 pm

    #447928

    Hi Andy

    When i run my .bat file from the command prompt, it runs fine, the moment i run it via xp_cmdshell, it hangs!!!, BY FLUKE, i managed to debug the process killing the CPU and and captured my output from SQL, and it showed me that it was waiting for a password for VSS.

    I subsequently created a user with no password in VSS and it works fine....busy with testing still!

    I have however come across another little snag, this trigger that i was creating was supposed to have been put on sysobjects and BOL says it cant be done....NEED TO FIND A WORKAROUND??, ANY IDEAS???????

    Thanks in advance

    Rennie

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply