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 |
pras2007
Posting Yak Master
216 Posts |
Posted - 2008-12-21 : 09:39:41
|
Hello All,How would I find out the name of my default instance in SQL Server? Please advice. Thanks. |
|
pras2007
Posting Yak Master
216 Posts |
Posted - 2008-12-21 : 09:45:07
|
I forgot to mention that I’m using Enterprise Evaluation Edition, if it makes a difference. Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2008-12-21 : 09:48:39
|
The default instance doesn't have a name, you simply connect to the server by name or IP address.You can use the following functions to return the name in a query:SELECT @@SERVERNAMEorSELECT SERVERPROPERTY('MachineName') |
|
|
|
|
|