Installation path - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Installation path

Author

Topic

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-06-30 : 10:51:10

How is it possible to find the installation path of sql 2005 please?
Thanks

nathans
Aged Yak Warrior

938 Posts

Posted - 2008-06-30 : 17:39:50

This info is stored in registry. Look under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" to find the exact key youre after.

You can read like:


declare @p nvarchar(4000)

exec master..xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE\Microsoft\Microsoft SQL Server\90\', 'VerSpecificRootDir', @p OUTPUT

Select @p

Nathan Skerl

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-01 : 03:53:51

Solved. Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources