|
madhuotp
Yak Posting Veteran
78 Posts |
 Posted - 12/05/2006 : 00:45:50
|
Hi ,
try - select @@Servicename
BOL Ref :
Returns the name of the registry key under which SQL Server is running. @@SERVICENAME returns 'MSSQLSERVER' if the current instance is the default instance; this function returns the instance name if the current instance is a named instance.
madhu |
 |
|
Instance Server name
