Capturing Information about Currently Installed SQL SERVER

Returns version, processor architecture, builds date, and operating system for the current installation of SQL Server.

USAGE: 

select @@version 

Output:

Microsoft SQL Server 2005 - 9.00.4060.00 (X64)

Mar 17 2011 13:06:52

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition (64-bit) on Windows NT 6.1

(Build 7601: Service Pack 1)

Ebook Download
View all
Learn
View all