Upgrading SQLServer 2000 STD Sp1 to Sp4

Hello

After installing Sql server 2000 STD Sp1 on a server with Windows 2003 server, i have upgrade my Sql server to Sp4.

All the setup has been terminated without errors, but if i execute on Q.Analyser : "Select @@version" on the end of line of my query result , i have ....(Service Pack 1)

I don′t know , if effectively the upgrade has been terminated with sucess.I try to restart my server several time , but the result of my query is always the same "....(Service Pack 1)"

Also, on my firewall server , i ′am create an UDP port 1434, because my ODBC client machine was enable to connect to my server.

Could you give me an explanation about, this question, and if i really done the upgrade to my sqlserver.

Many Thanks

Luis

[795 byte] By [lafs] at [2007-12-22]

«« Transparent images inC#.NET Compact Framework
»» Partition on Value

# 1

The "Service Pack 1" in this case refers to the Windows Service Pack, not the SQL Service Pack. The SQL build number should reflect the update. It should look something like:

This is an entry from SQL Server 2005, but SQL 2000 behaves the same.

Thanks,
Sam Lester (MSFT)

SamuelLester-MSFT at 2007-8-30 >