Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: MSDE 2K vs SQL2K

    Hello,

    For my application I need to know how I can see the difference (by query) between a MSDE and SQL server.
    I need to know if the server is MSDE or SQL...

    Is there any information in the system tables where I can see it?

    Thank a lot for your informations

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    I believe this will do it
    Code:
    select @@version
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    This query returns a string wich described the version of the server.
    I'm looking after a number version or something else wich does the same thing. I don't know if it exist... Maybe i'm looking for something that doesn't exist?

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    select @@version on my pc gives this

    Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

    I believe you can check whether or not your pc is a MSDE or SQL server 200o etc using this.

    [edit]
    I just forgot this ... from the Holy Book (SQL server Books Online)
    SERVERPROPERTY
    Returns property information about the server instance.

    Syntax
    SERVERPROPERTY ( propertyname )

    Arguments
    propertyname

    Is an expression containing the property information to be returned for the server. propertyname can be one of these values.

    Property name Values returned
    Collation The name of the default collation for the server.
    Returns NULL if invalid input or error.

    Base data type: nvarchar

    Edition The edition of the Microsoft® SQL Server™ instance installed on the server.
    Returns:

    'Desktop Engine'
    'Developer Edition'
    'Enterprise Edition'
    'Enterprise Evaluation Edition'
    'Personal Edition'
    'Standard Edition'

    Base data type: nvarchar(128)

    Engine Edition The engine edition of the SQL Server instance installed on the server.
    1 = Personal or Desktop Engine
    2 = Standard
    3 = Enterprise (returned for Enterprise, Enterprise Evaluation, and Developer)

    Base data type: int

    [/edit]
    Last edited by Enigma; 12-15-03 at 09:37.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •