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

• robertm

  Ten Centuries

  Points: 1096

  More actions

  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.

   

• noeld

  SSC Guru

  Points: 96590

  More actions

  November 15, 2005 at 9:41 am

  #603971

  Have a look at SETX (on the resource kit)

  
  * Noel

• robertm

  Ten Centuries

  Points: 1096

  More actions

  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

• noeld

  SSC Guru

  Points: 96590

  More actions

  November 15, 2005 at 9:57 am

  #603976

  Windows 2k resource kit

   

  
  * Noel