locked
Search paths added during SQL Server installation RRS feed

  • Question

  • I have SQL Server 2012 and the following have been added to my PC's search path:

    • C:\Program Files\Microsoft SQL Server\110\Tools\Binn\
    • C:\Program Files\Microsoft SQL Server\110\DTS\Binn\
    • C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\
    • C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\
    • C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\

    Can I request Microsoft to stop this bad habit.  It chokes up the search path with more than 200 characters making it unreadable and unmanageable.  It affects the performance of the PC as five more folders have to be opened and searched every time.  And it increases the security vulnerability.

    Programs are configured on the Start menu, and additional things that programs need should be within their configuration files and not globally published.

    Thanks.

    • Edited by K.Kong Saturday, October 6, 2012 7:01 AM
    • Moved by Sethu Srinivasan Monday, October 8, 2012 8:56 PM setup (From:Getting started with SQL Server)
    Saturday, October 6, 2012 6:59 AM

Answers

  • I don't see any harm in doing that. Start > run > SSMS would not open management studio and there are so many executables which should run and would use PATH variable.


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    • Proposed as answer by Kalman Toth Saturday, October 6, 2012 1:36 PM
    • Marked as answer by Shulei Chen Monday, October 15, 2012 9:15 AM
    Saturday, October 6, 2012 12:42 PM
  • Start > Run > Profiler

    Above has no dependency on SSMS.exe so there is no question of configuration file.

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    • Marked as answer by Shulei Chen Monday, October 15, 2012 9:15 AM
    Saturday, October 6, 2012 6:11 PM

All replies

  • Did you mean PATH variable?

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    Saturday, October 6, 2012 7:21 AM
  • That is correct.
    Saturday, October 6, 2012 10:59 AM
  • I don't see any harm in doing that. Start > run > SSMS would not open management studio and there are so many executables which should run and would use PATH variable.


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    • Proposed as answer by Kalman Toth Saturday, October 6, 2012 1:36 PM
    • Marked as answer by Shulei Chen Monday, October 15, 2012 9:15 AM
    Saturday, October 6, 2012 12:42 PM
  • I disagree.

    If SSMS needs other stuff, it should keep that information in its configuration files.

    Saturday, October 6, 2012 2:13 PM
  • Start > Run > Profiler

    Above has no dependency on SSMS.exe so there is no question of configuration file.

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    • Marked as answer by Shulei Chen Monday, October 15, 2012 9:15 AM
    Saturday, October 6, 2012 6:11 PM