I need the istance name in my SQL 2000

Hi guys,
how to view the default instance name in my sql server?Hi

Have you tried something like:

SELECT ISNULL(SERVERPROPERTY('InstanceName'), SERVERPROPERTY('MachineName'))

The default instance returns NULL. More information in Books Online.

John

"amnsia" <secondotetidoilmioindirizzocosilospammi@.nondirecaz zate.it> wrote
in message news:camuap$96g$1@.domitilla.aioe.org...
> Hi guys,
> how to view the default instance name in my sql server?