• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

SQL 2005 affects DOS commands??

I have built a new system wand installed SQL 2005.  I have noticed that this affect the SET command in DOS.  example: set l
                          lib=C:\Program Files\SQLXML 4.0\bin\

does anyone know if this is because SQL was setup wrong?  ...or is this something that's "normal"??

this does not happen on my older SQL boxes...

  • 2
2 Solutions
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the "lib" is eventually normal.
the "LOGONSERVER" should be depending on your OS and domain settings, but not the SQL Server setup
emibadteamAuthor Commented:
yepper,,   I understand that   what I'm showing you above is what is returned when I type "set l"..

hence my question...  cause I don't get that if I'm on a server with an older version of SQL..
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what I meant:
>the "lib" is eventually normal.
the "lib" is eventually normal with sql server 2005, as that indeed installs xml 4 objects

the LOGONSERVER is something coming from OS (windows), so you might compare the versions of windows with that box and the one with the "older" sql versions, are they the same?
That's very normal.
"set L" will display all environment variables starting with L. You can have lots of environment variables defined, it's just that the older version of SQL doesn't set the "lib" variable; this is not affecting the "set" command, it's just another environment variable that is defined like %Temp% or %Path% or whatever.
If you enter
set logonserver
(or even only set li) you will only get the logonserver again. Enter a simple "set", and you will see them all (except for some special variables like %date% or %time%, which are created during runtime).

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now