Need basic technical MSDE information.

Hello, I'm looking for a technical faq for MSDE. I need to know the
essentials for, example, the number of simultaneous connections that MSDE
permits, etc.
Thanks
hi,
"Narwe" <Narwe@.discussions.microsoft.com> ha scritto nel messaggio
news:22828EB8-E242-4E8F-B115-96E7B768D366@.microsoft.com
> Hello, I'm looking for a technical faq for MSDE. I need to know the
> essentials for, example, the number of simultaneous connections that
> MSDE permits, etc.
> Thanks
the pricipal feature can be seen at
http://www.microsoft.com/sql/msde/pr...fo/default.asp
and some comparison beteen edition at
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
the specific question, regarding connections, is answered at
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp ,
but you have to keep in mind the Query Workload Governor kicking in when 8
concurrent workloads are executed, like explained in
http://msdn.microsoft.com/library/?u...asp?frame=true
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||www.qmsdnug.org/DAT306_LOW.ppt might also help.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2rllhiF1c75oqU1@.uni-berlin.de...
> hi,
> "Narwe" <Narwe@.discussions.microsoft.com> ha scritto nel messaggio
> news:22828EB8-E242-4E8F-B115-96E7B768D366@.microsoft.com
> the pricipal feature can be seen at
> http://www.microsoft.com/sql/msde/pr...fo/default.asp
> and some comparison beteen edition at
>
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
> the specific question, regarding connections, is answered at
>
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp ,
> but you have to keep in mind the Query Workload Governor kicking in when 8
> concurrent workloads are executed, like explained in
>
http://msdn.microsoft.com/library/?u...asp?frame=true
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Need assitance to Launch MSDE and create a new database.

Installed MSDE. Icon on system tray shows "not connected". Start, Stop &
Pause are greyed out. I am trying to connect to a database. Please help.
Regards,
Shah.
hi, Shah,
Shah wrote:
> Installed MSDE. Icon on system tray shows "not connected". Start,
> Stop & Pause are greyed out. I am trying to connect to a database.
> Please help.
the "problem" with the SQL Server Service Manager can be related with
http://support.microsoft.com/default...;EN-US;814132, but you
should be able to connect to your MSDE instance anyway...
please verify in the service management applet your instance is (correctly)
installed and running...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Need advice

Hi,
I have a few offices accross the country running MSDE and my HQ SQL 2000. I
need to port the data nightly to the HQ. Should I consider Replication?
Whatever is done on the MSDE at the offices are not needed after copied to
the HQ. I was thinking of creating an app (running at all offices) to copy
the data nightly to the HQ but I am worried if the connection goes down
during the copy?
Please advice.
Thanks
I would do this with DTS instead of replication since you don't have a
requirement to maintain the data in MSDE after it is transferred and it
doesn't appear you are sending anything from HQ back to any of the offices.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:574D914C-55A2-48B3-B606-55DD5D9E02BC@.microsoft.com...
> Hi,
> I have a few offices accross the country running MSDE and my HQ SQL 2000.
> I
> need to port the data nightly to the HQ. Should I consider Replication?
> Whatever is done on the MSDE at the offices are not needed after copied to
> the HQ. I was thinking of creating an app (running at all offices) to copy
> the data nightly to the HQ but I am worried if the connection goes down
> during the copy?
> Please advice.
> Thanks