I need the istance name in my SQL 2000
This is a discussion on I need the istance name in my SQL 2000 within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi guys, how to view the default instance name in my sql server?...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 04:14 AM
| ||||
| ||||
 Re: I need the istance name in my SQL 2000 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" <secondotetidoilmioindirizzocosilospammi@nondireca zzate.it> wrote in message news:camuap$96g$1@domitilla.aioe.org... > Hi guys, > how to view the default instance name in my sql server? > >      |
Linear Mode
