Dec 23, 2013

Sql script to get the version of sql server


Sql query to get the version operating system where it has installed:

SELECT @@VERSION AS [Version]

Sample output:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)   Mar 29 2009 10:27:29   Copyright (c) 1988-2008 Microsoft Corporation  Express Edition on Windows NT 6.1 <X86> (Build 7600: )

No comments:

Post a Comment