如何从T-SQL获取当前实例名称 [英] How to get current instance name from T-SQL

问题描述

如何使用T-SQL脚本获取当前连接的SQL Server服务器和实例名称?

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

推荐答案

只需在

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

返回实例名称，即使这是默认名称(MSSQLSERVER)

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

这篇关于如何从T-SQL获取当前实例名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！