Check if SQL2008 Tools is installed or not.

Question

Post reply

Check if SQL2008 Tools is installed or not.

Chandu-212374

SSCrazy

Points: 2247
More actions
September 2, 2010 at 8:29 am

#237774

I am writing a batch file to run an un-attended installation of SQL 2008 Tools and Mgmt studio.
How to write code to check if SQL2008 Tools exists on the system. If yes exit. If not install the Tools and SSMS.
Pls help.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

Check the registry. On my system, it's located at:

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\ClientSetup, and the key is SQLToolsPath.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2