MSDE Essentials
MSDE has been around since Visual Studio 6, and you can find additional information about using it from Microsoft at http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp. Table C-1 lists the differences between SQL Server and MSDE.
Feature |
SQL Server |
MySDE |
Storage limit |
None |
2 GB |
Concurrent user limit |
None |
5 |
CPU limit |
Depends on the version, typically 4 to 32. |
2 |
Clustering |
Yes |
No |
OLAP |
Yes |
No |
Replication |
Snapshot, merge, and transactional |
Merge and transactional (subscriber only) |
Graphical tools |
A full suite, including tools for database design, performance tracing, and running queries |
None, although you can perform some tasks through Visual Studio .NET or Microsoft Access. You can also use the command-line OSQL.exe utility or the SQL Server Enterprise Manager if it’s installed. |
Licensing |
Server license plus concurrent user license |
Free. |
Though MSDE lacks a graphical tool for executing SQL queries and commands, you can use the OSQL command-line utility. It allows you to execute Transact-SQL statements, system procedures, and script files interactively from a command line. Behind the scenes, the OSQL utility uses ODBC to communicate with the server.
To log on to an MSDE instance that uses integrated Windows authentication, enter the following command line:
osql -E
To log on to an MSDE instance that uses SQL authentication, enter this instead:
osql -U sa
To access an MSDE instance on another computer, ...
Get ADO.NET in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.