Hi

Does anyone know how to use sql server desktop engine with the enterprise
Manager vs using osql?

Thanks,
Cindy

Hello, Cindy

SQL Server Desktop Engine (MSDE) does not include the graphical
management tools (Enterprise Manager, Query Analyzer, etc) and,
usually, you are not allowed to use the management tools included with
another edition of SQL Server to manage a MSDE instance.

However, the page
http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_67ax.asp
(and also http://www.microsoft.com/sql/msde/howtobuy/msdeuse.mspx )
says:

"You can manage instances of MSDE 2000 using the graphical tools
included with another edition of SQL Server only if you acquired
MSDE through SQL Server 2000 (Developer Edition, Standard Edition,
or Enterprise Edition), and if you are using MSDE in conjunction
with a properly licensed copy of SQL Server 2000."

It's not clear to me what is meant by "using MSDE in conjunction with
[...] SQL Server 2000". Maybe this means that MSDE accesses the data
from the other SQL Server (using replication, linked servers, etc).

For more informations, you should contact Microsoft Licensing and/or a
lawyer specialized in this field. Also, see:
http://www.microsoft.com/licensing/index/worldwide.mspx
http://groups.google.com/groups?q=MSDE+%22Enterprise+Manager%22+conjunction+MSFT

Razvan