Wednesday, March 28, 2012

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 informationsI believe this will do it

select @.@.version|||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?|||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.

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

No comments:

Post a Comment