Post reply

How do I tell what version I am using?

  • November 4, 2010 at 7:52 am

    #228600

    I am trying to install Team Foundation Server, and the install tells me I don't have a compatible version of SQL Server installed. I looked online and there are some service packs for 2008 out there. How do I tell if any of them have been installed. 10.0.1600 is the version number.

  • November 4, 2010 at 7:54 am

    #1246544

    10.0.4000 is service pack 2.

    run "SELECT @@VERSION" - this will tell you the version, and whether you have RTM, SP1 or SP2 installed.

    I believe that 10.0.1600 is RTM; I think that SP1 is something like 10.0.2531.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply