Post reply

xp_cmdshell - how do you refresh environment variables????

  • November 15, 2005 at 2:52 am

    #89840

    Hi we have a few usp's that use xp_cmdshell to executes some proprietary software that relies on accessing environment variables. Our issue is that if a new environment variable is added to the server, it's not picked up within SQL Servers name space unless restarted which is not practical due to the high demand on the server.

    Does anyone know of a way of refreshing the environment variables without restarting SQL Server??

    Cheers in advance for any comments.

     

  • November 15, 2005 at 9:41 am

    #603971

    Have a look at SETX (on the resource kit)


    * Noel

  • November 15, 2005 at 9:51 am

    #603973

    Thanks Noel,

    Is there anymore info you can give me on this... are you talking about the SQL Server resourse kit? Do you have a URL that explains in more detail?

    Cheers

    R

  • November 15, 2005 at 9:57 am

    #603976

    Windows 2k resource kit

     


    * Noel

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

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