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...

  • 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 ...
  • Disturbed Cache
    The Scenario Sharepoint 2013 developed publishing site using adfs. AppFabric with CU5. The problem In a developed Sharepoint Site we were...
  • 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...