Pulling in an Environment Variable

• Richard Rowe

  SSC Enthusiast

  Points: 134

  More actions

  October 11, 2005 at 3:09 am

  #102857

  Does anyone know what command I can use in my query to pull an enviroment variable (I created) into my database?

  Thanks for any suggestions.

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  October 11, 2005 at 3:52 am

  #596475

  You can use xp_cmdshell for all kinds of interaction with the shell. Using something like EXEC master.dbo.xp_cmdshell 'echo %FOO%' you can get the value of an environment variable called foo. You will need to pick it up in some way, for instance by inserting the result set returned into a temp table.

  Note that the environment variable must be available from the context of the account SQL Server is running as.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Richard Rowe

  SSC Enthusiast

  Points: 134

  More actions

  October 11, 2005 at 3:55 am

  #596477

  Thanks Chris

  I'll take a look at that.

  Ricky