Hi
Have you tried something like:
SELECT ISNULL(SERVERPROPERTY('InstanceName'), SERVERPROPERTY('MachineName'))
The default instance returns NULL. More information in Books Online.
John
"amnésia" <se*************************************@nondireca zzate.it> wrote
in message news:ca**********@domitilla.aioe.org...
Hi guys,
how to view the default instance name in my sql server?