|
|
|
Author |
Message |
vividpresence
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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.
|
|
|
|
|
|
|