How to find is full SQL or MSDE

[Ambientguitar]

Hi,
We run around quite a few sql servers ,half of which are MSDE only. I have written a procedure to copy a database to a new DB when it has reached 1900 mb then truncate all the tables.This is only used as an archive. Anyway the problem is this, I only want to run this where the server is MSDE. How can I find this out? I have tried @@version,xp_msver,select serverproperty('productversion').All of these return info but nothing that helps or am I missing the obvious?

 

[bborissov]

Check

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

http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-01/5261.html

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[Ambientguitar]

These only give me the results that I have prior to asking my question? I can get edition info , service pk info etc. but what distiguishes between SQL server and MSDE?

 

[bborissov]

http://support.microsoft.com/kb/819334/EN-US/

If you are not sure what edition of the SQL Server 2000 database engine or MSDE 2000 you are running, view the last line of output returned by SELECT @@VERSION. The last line will match one of the following:
•	Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 2)
•	Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
•	Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
•	Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
•	Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
•	Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[Ambientguitar]

Thanks for your help Boris greatly appreiciated , I think select serverproperty(Edition)
select serverproperty(EngineEdition)
select serverproperty(Productlevel)

EngineEdition returns int

1=Personal or desktop Engine (MSDE 2000)
2=Standard
3=Enterprise (Returned for Enterprise,Enterprise evaluation or Developer)


Once again many thanks .