Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
hrishi_des
Yak Posting Veteran
76 Posts |
Posted - 2006-12-05 : 00:30:50
|
How to find programmatically name of instance server? |
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2006-12-05 : 00:45:50
|
Hi ,try - select @@ServicenameBOL 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 |
|
|
|
|
|