Wednesday, May 23, 2012

Identify version of SQL Server installed

To identify version run query: select @@version

Or on older versions (pre2005) run query:

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

And you get served with information layed out like below:

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
    Jul  9 2008 14:43:34
    Copyright (c) 1988-2008 Microsoft Corporation
    Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Powershell and Uptimerobot

Uptimerobot can be quite tedious when you need to update many monitors at once. For example say you bought the license for Uptimerobot and n...

  • Remote Desktop Services in 2012
    Problem: In a customer environment they wanted to install RDS and DC on the same server. A nice cheap solution, which have worked perfectly...
  • SPD 2013 error workflow
    Error received for no apparent reason when creating workflow. Errors were found when compiling the workflow. The workflow files were save ...
  • Sharepoint 2019 and mysites
     I had some problems with the old familiar "Working on it" for mysites in Sharepoint 2019. It was difficult to find information ab...