Post reply

Version

  • August 7, 2003 at 12:41 pm

    #83032

    Ho0w can I check to see what version of SQL Server I have. I need to know if it is enterprise or professional. Ineed to know # of clients allowed and I need to know the latest service pack.

    Thank you in advance.


    "The grass is always greener over the septic tank." ~Leaf

  • August 7, 2003 at 1:29 pm

    #469080

    select @@version in query analyzer will give you the release your on.

    I would check the licensing service to see how many Cal's you have.

    Tom

  • August 8, 2003 at 11:33 am

    #469227

    See

    Microsoft Knowledge Base Article - 321185

    HOW TO: Identify Your SQL Server Service Pack Version and Edition

    http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

    You want the Edition I think

    Edited by - robinhc on 08/08/2003 11:37:17 AM

  • August 8, 2003 at 3:20 pm

    #469250

    I use both query below.

    SELECT @@VERSION

    SELECT CAST(@@SERVERNAME AS NVARCHAR(50)) 'ServerName', RTRIM(CONVERT(Char(20), SERVERPROPERTY('ProductVersion')))

    + ' = ' + RTRIM(CONVERT(Char(20), SERVERPROPERTY('Edition')))

    + ' - ' + RTRIM(CONVERT(Char(20), SERVERPROPERTY('ProductLevel')))

    'SQL Server Version'

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

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