SQL MSDE  
Author Message
vividpresence





PostPosted: Thu Jul 07 09:25:10 CDT 2005 Top

SQL Server >> SQL MSDE

I have another instance running on the same server, it might be a msde
verion, how can I find out if it is msde or other?

Thanks a lot.

SQL Server59  
 
 
Kevin3NF





PostPosted: Thu Jul 07 09:25:10 CDT 2005 Top

SQL Server >> SQL MSDE Select ServerProperty('Engine Edition')

Result:

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




--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions




>I have another instance running on the same server, it might be a msde
> verion, how can I find out if it is msde or other?
>
> Thanks a lot.



 
 
Kevin3NF





PostPosted: Thu Jul 07 09:25:00 CDT 2005 Top

SQL Server >> SQL MSDE Select ServerProperty('Engine Edition')

Result:


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions




>I have another instance running on the same server, it might be a msde
> verion, how can I find out if it is msde or other?
>
> Thanks a lot.


 
 
Kevin3NF





PostPosted: Thu Jul 07 09:25:27 CDT 2005 Top

SQL Server >> SQL MSDE Select ServerProperty('Engine Edition')

Result:

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


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions




>I have another instance running on the same server, it might be a msde
> verion, how can I find out if it is msde or other?
>
> Thanks a lot.


 
 
Kevin3NF





PostPosted: Thu Jul 07 09:25:12 CDT 2005 Top

SQL Server >> SQL MSDE Select ServerProperty('Engine Edition')

Result:

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




--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions




>I have another instance running on the same server, it might be a msde
> verion, how can I find out if it is msde or other?
>
> Thanks a lot.



 
 
Jens





PostPosted: Thu Jul 07 09:29:07 CDT 2005 Top

SQL Server >> SQL MSDE

OR

SELECT SERVERPROPERTY('Edition')



HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---





>I have another instance running on the same server, it might be a msde
> verion, how can I find out if it is msde or other?
>
> Thanks a lot.


 
 
CatelinWang





PostPosted: Thu Jul 07 11:34:14 CDT 2005 Top

SQL Server >> SQL MSDE Thanks guys, I just tryed on my computer , it is desktop engine.



> I have another instance running on the same server, it might be a msde
> verion, how can I find out if it is msde or other?
>
> Thanks a lot.