find out the instanceName

If after installing and working with MSDE a long while ago I forget the
instance Name in my local machine, what could I do to find it out again?
hi,
ykffc wrote:
> If after installing and working with MSDE a long while ago I forget
> the instance Name in my local machine, what could I do to find it out
> again?
for a quick view, you can rune oSql.exe with the -L parameter (case
sensitive), to list all available instances like
c:\...>oslq.exe -L
but you can inspect the file system as well.. in the \Program
Files\Microsoft SQL Server\ folder you will have all the installed one, if
you did not provide an alternate location at install time.. you'll have
\MSSQL\ for a default instance, and \MSSQL$InstanceName\ for a named
instance..
another one is inspecting the Windows registry... in the
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\
InstalledInstaces = ...
key you'll find all locally installed instances..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply