|
Home > Archive > MS SQL Server New Users > March 2006 > SQL Server 2005 and MSDE
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server 2005 and MSDE
|
|
| Serge Myrand 2006-03-17, 9:24 am |
| Hi,
In MS online books for SQL Server 2005 express it is written that (in my
words) there is a possibility of port number confusion when connecting
to the server if MSDE is installed and the MSDE sp3 is not installed.
How to know the last service pack installed?
When googling for MSDE sp3 it leads to SQL Server sp3a. Is it the same
service pack?
Is it the one to install?
thank you in advance
serge
| |
| Sue Hoegemeier 2006-03-21, 3:30 am |
| To determine the service pack level, execute: select
@@version
You can check the version against the list here:
http://www.aspfaq.com/show.asp?id=2160
The fixes are the same but the install files are different
for MSDE SP 3 and SQL Server SP 4. You can download SP 3 for
MSDE from:
http://www.microsoft.com/downloads/...&DisplayLang=en
The file you want is: SQL2kdesksp3.exe
-Sue
On Fri, 17 Mar 2006 09:41:41 -0400, Serge Myrand
<info@softdelirium.qc.ca> wrote:
>Hi,
>
>In MS online books for SQL Server 2005 express it is written that (in my
>words) there is a possibility of port number confusion when connecting
>to the server if MSDE is installed and the MSDE sp3 is not installed.
>
>How to know the last service pack installed?
>
>
>When googling for MSDE sp3 it leads to SQL Server sp3a. Is it the same
>service pack?
>Is it the one to install?
>
>
>thank you in advance
>serge
| |
| Serge Myrand 2006-03-21, 3:30 am |
| <!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
<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/...;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
<br>& lt;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>
|
|
|
|
|