SQL Server 2000/MSDE/SQL 2005 Express mixed environment

Posted by Terrible Tom on August 1, 2006, 8:01 pm

Please log in for more thread options

In my network, HQ & Store Ops for one store run on SQL Server 2000 (part of
SBS 2003). The registers & office pcs in that bldg all run MSDE.

In store two, the server (Windows Server 2003 Std) hosts Store Ops with MSDE
and all the registers & PCs run MSDE.

I just rolled out store three (just like store two), and again used MSDE
everywhere - but I toyed with the idea of downloading and using SQL 2005
Express.

In a few weeks, I'll be rolling out store #4. Is there any reason why I
cannot run 2K5E in one store and MSDE elsewhere? Eventually, I suppose I'll
end up with 2K5E everywhere (except maybe the HQ server, and even that's not
a foregone conclusion). Will I have to make the switch all at once?

Posted by Jeff on August 3, 2006, 4:36 pm

Please log in for more thread options

: quoted-printable

TT,

Works fine.

--=20
*
Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment. If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz

**********

In my network, HQ & Store Ops for one store run on SQL Server 2000 =
(part of=20
SBS 2003). The registers & office pcs in that bldg all run MSDE.

In store two, the server (Windows Server 2003 Std) hosts Store Ops =
with MSDE=20
and all the registers & PCs run MSDE.

I just rolled out store three (just like store two), and again used =
MSDE=20
everywhere - but I toyed with the idea of downloading and using SQL =
2005=20
Express.

In a few weeks, I'll be rolling out store #4. Is there any reason why =
I=20
cannot run 2K5E in one store and MSDE elsewhere? Eventually, I =
suppose I'll=20
end up with 2K5E everywhere (except maybe the HQ server, and even =
that's not=20
a foregone conclusion). Will I have to make the switch all at once?
------=_NextPart_000_0382_01C6B701.CA3AF6B0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.2912" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>TT,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Works fine.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT><FONT color=3D#008000></FONT><BR>-- =
<BR>*<BR>Get=20
Secure! - <A=20
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
</DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment.  If you are not using a =
reader,=20
follow<BR>the link below to setup Outlook Express.  Click on "Open =
with=20
newsreader"<BR>under the MS Retail Management System on the right.</DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><A =
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV>**********<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Terrible Tom" <<A=20
=
om</A>>=20
wrote in message <A=20
=
39A38-AFD7-4373-B655-CA3BFF242F86@microsoft.com</A>...</DIV>In=20
my network, HQ & Store Ops for one store run on SQL Server 2000 =
(part of=20
<BR>SBS 2003).  The registers & office pcs in that bldg all =
run=20
MSDE.<BR><BR>In store two, the server (Windows Server 2003 Std) hosts =
Store=20
Ops with MSDE <BR>and all the registers &  PCs run =
MSDE.<BR><BR>I=20
just rolled out store three (just like store two), and again used MSDE =

<BR>everywhere - but I toyed with the idea of downloading and using =
SQL 2005=20
<BR>Express.<BR><BR>In a few weeks, I'll be rolling out store =
#4.  Is=20
there any reason why I <BR>cannot run 2K5E in one store and MSDE=20
elsewhere?  Eventually, I suppose I'll <BR>end up with 2K5E =
everywhere=20
(except maybe the HQ server, and even that's not <BR>a foregone=20
conclusion).  Will I have to make the switch all at=20
once?</BLOCKQUOTE></BODY></HTML>

------=