How to get current instance name from T-SQL

sql sql-server tsql sql-server-2008r2-express
Guillermo Gutiérrez picture Guillermo Gutiérrez · Aug 6, 2013 · Viewed 212.9k times · Source

How can I get the SQL Server server and instance name of the current connection, using a T-SQL script?

Answer

Guillermo Gutiérrez picture Guillermo Gutiérrez · Aug 6, 2013

Just found the answer, in this SO question (literally, inside the question, not any answer):

SELECT @@servername

returns servername\instance as far as this is not the default instance

SELECT @@servicename

returns instance name, even if this is the default (MSSQLSERVER)

Related questions

SQL: Comparing Dates with only Month and Year columns

I have a table MonthlyShipments that looks like: partnumber | quantity | month | year | part1 | 12 | 6 | 2011 | part1 | 22 | 5 | 2011 | part1 | 32 | 4 | 2011 | part1 | 42 | 3 | 2011 | part1 | 52 | 2 | 2011 | I want to sum the quantities of the past 3 months, excluding the current month. My where clause currently looks like: where MonthlyShipments.Month &…

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More