May 17, 2004 at 11:39 am
Does anyone know of a way to determine if a SQL server install is MSDN or not? I've looked through BOL and I know about the SERVERPROPERTY function and @@VERSION, but this only tells you the edition. It doesn't mention if it is MSDN or not.
Thanks.
May 17, 2004 at 2:22 pm
No, I have seen no way of telling a difference and my understanding is other than being for developement use there wasn't any.
May 18, 2004 at 11:08 am
How about reading the SQL error log? Would this give you what you need?
Microsoft SQL Server 2000 - 8.00.679 (Intel X86)
Aug 26 2002 15:09:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4)
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
MSDE on Windows NT 5.0 (Build 2195: Service Pack 4)
Linda
May 19, 2004 at 12:34 am
For what reason do you need to determine the origin of the install media?
SELECT @@VERSION
EXEC xp_msver
Return similar information about the editition and build number of SQL Server.
SQL Server itself only comes in the following editions: Enterprise, Enterprise Evaluation, Standard, Personal, Developer, Desktop (MSDE), and Windows CE Edition.
Julian Kuiters
juliankuiters.id.au
May 19, 2004 at 7:41 am
try this:
SELECT convert(char(20),serverproperty('productversion')) Version, convert(char(20),serverproperty('productlevel')) ProductLevel, convert(char(25),serverproperty('edition')) Edition
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply