MSDE - How it works

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I am new to this. I understand that for SQL server you need a standalone
serve which processes all client queries.

How does it work for MSDE...do we pick up any machine on the network as
"server" to install MSDE and then the rest is the same as for SQL Server? or
do we need to install MSDE on each machine like access?

How many concurrent users does MSDE support?

Thanks

Regards
 
Hi John,

Yes. As long as you are not using exotic features.
"
Other items not included in the Desktop Engine include analysis capabilities
(such as OLAP, data mining, and data warehousing features) and SQL Server
Books Online. Desktop Engine also limits database size to 2 GB and employs
the same concurrent workload throttle described earlier for Personal
Edition."

excerpt from info.

Check the docs:
 
MSDE is SQL Server, only restricted. To connect, you use a connection string
equivalent to a SQL Server connection string. It can support 5 concurrent
users, which means 5 live connections at any given fraction of a second.
These 5 can equate to many users if you follow JIT opening of the connection
object and ASAP closing of the connection. A good example:

conn.Open()
dataAdapt.Fill(dataSet)
conn.Close()

With readers and large amounts of data to process, you can run out of
connections easier, although I still would use DataReaders for small amounts
of read only data.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
As long as you are not using Enterprise features of SQL Server? Yes!

MSDE is either being labeled SQL Server Personal, or that was a name it was
floated under for awhile (not sure). Either way, the engine is SQL Server.
You just have limited connections and no SQL client tools. If you have SQL
Server client tools, you can use them to administer MSDE, however.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
Back
Top