业务代码Profiler截得,自己加了层皮而已:
-------------------------------------------------------------------------
--USP_VERSION
-------------------------------------------------------------------------
IF OBJECT_ID('USP_VERSION') IS NOT NULL
DROP PROC USP_VERSION
GO
CREATE PROC USP_VERSION
AS
BEGIN
SELECT @@VERSION
SELECT
CAST(serverproperty(N'Servername') AS sysname) AS [Server_Name],
'Server[@Name=' + quotename(CAST(serverproperty(N'Servername') AS sysname),'''') + ']' AS [Server_Urn],
(@@microsoftversion / 0x1000000) & 0xff AS [VersionMajor],
(@@microsoftversion / 0x10000) & 0xff AS [VersionMinor],
@@microsoftversion & 0xffff AS [BuildNumber],
CAST(SERVERPROPERTY('IsSingleUser') AS bit) AS [IsSingleUser],
CAST(SERVERPROPERTY(N'Edition') AS sysname) AS [Edition]
ORDER BY [Server_Name] ASC
END
GO
EXEC USP_VERSION
GO