<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<body text="#000000" bgcolor="#F1E9D9" link="#0000EE" vlink="#551A8B" alink="#FF0000">
<br>Thank you very much.
<p>serge
[quoted text, click to view] <p>Sue Hoegemeier wrote:
<blockquote TYPE=CITE>To determine the service pack level, execute: select
<br>@@version
<br>You can check the version against the list here:
<br><a href="
http://www.aspfaq.com/show.asp?id=2160">http://
www.aspfaq.com/show.asp?id=2160</a>
<p>The fixes are the same but the install files are different
<br>for MSDE SP 3 and SQL Server SP 4. You can download SP 3 for
<br>MSDE from:
<br><a href="
http://www.microsoft.com/downloads/details.aspx?FamilyID=90dcd52c-0488-4e46-afbf-acace5369fa3&DisplayLang=en">http://
www.microsoft.com/downloads/details.aspx?FamilyID=90dcd52c-0488-4e46-afbf-acace5369fa3&DisplayLang=en</a>
<br>The file you want is: SQL2kdesksp3.exe
<p>-Sue
<p>On Fri, 17 Mar 2006 09:41:41 -0400, Serge Myrand
[quoted text, click to view] <br><info@softdelirium.qc.ca> wrote:
<p>>Hi,
<br>>
<br>>In MS online books for SQL Server 2005 express it is written that
(in my
<br>>words) there is a possibility of port number confusion when connecting
<br>>to the server if MSDE is installed and the MSDE sp3 is not installed.
<br>>
<br>>How to know the last service pack installed?
<br>>
<br>>
<br>>When googling for MSDE sp3 it leads to SQL Server sp3a. Is it the
same
<br>>service pack?
<br>>Is it the one to install?
<br>>
<br>>
<br>>thank you in advance
<br>>serge</blockquote>
</body>
</html>