sql server msde: I have a few apps that are based on and required MSDE instances.

I would like to load SQL Express on the same box as those MSDE instances
reside.

Any issues I might encounter?

Memory. Each loaded instance consumes RAM. Otherwise they should peacefully
coexist--kinda like lots of cooks in the kitchen. The bigger the kitchen the
fewer problems you'll have.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

Thanks. I like the analogy too :)

I am new to SQL Express - does one generally have multiple SQL Express
instances going like one did with MSDE when each app needed its own Or will
SQL Express allow apps to coexist within one SQL Express instance?

Thanks again!


[quoted text, click to view]

hi,
[quoted text, click to view]

you should maintain the "shared" template as long as possible, to reduce
hardware contentions... so install the "default" computerName\SQLExpress
"shared" instance for all your needs...
do not use User Instance.. :D
if you "start" seeing "memory" problems becouse of the "limited" memory
usage (1gb) or if you need to complitely separate access (for security
reasons, for different collations clashing your tempdb, ....) you can start
thinking about a separate instance, if your hardware supports it...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply

Andrea is right. Try to share the common SQLEXPRESS instance if possible.
Consider that each instance consumes RAM. I agree with the admonition
against the User Instance approach. While it seems attractive, it's
expensive and must be fully understood before you commit to this strategy. I
discuss these strategies in my book.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]