instance name

Hi,
my machine name is webdev5
when I run sql server, it asks for the server name, I enter 'webdev5'
and using windows authentication.
where can I find out about the instance name? on my machine? I am using
2005
thank you
ken
Instance name is most commonly used when there are multiple installations of
SQL Server on the same computer. If you have only one SQL Server, and if you
did not deselect the "Use DEFAULT Instance" option when installing, then
your instance is named 'webdev5'.
Read about Instance and Instance Names in Books Online.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegro ups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>
|||Hi,
If you are logged into SQL Server Management studio then connect to SQL
server and open a Query window and execute
SELECT @.@.SERVERNAME
If its a default instance it just returns the machine name. This will be
trated as the SQL Server name. If you have Servername\Instancename;
then you have installed a named SQL Server instance.
You could also get this information from Errorlog of SQL Server. There you
have to look for Server name:.............
Thanks
Hari
SQL Server MVP
<SQLken@.gmail.com> wrote in message
news:1159221843.315654.187670@.m7g2000cwm.googlegro ups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
> where can I find out about the instance name? on my machine? I am using
> 2005
> thank you
> ken
>