SQL 2005 affects DOS commands??

Posted on 2007-07-31
Last Modified: 2010-03-19
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...

Question by:emibadteam
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    the "lib" is eventually normal.
    the "LOGONSERVER" should be depending on your OS and domain settings, but not the SQL Server setup

    Author Comment

    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..
    LVL 142

    Accepted Solution

    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?
    LVL 82

    Assisted Solution

    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

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    This video discusses moving either the default database or any database to a new volume.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now