Did you check the error logs ?

Of course :-), there is no errors, according to the install, the service pack installed fine, however if i look at the active databases, they are all still running SP3. I have tried the MSDE SP4 install just in case its an MSDE engine, but its not. I know little about the original install of SQL on this box and it wouldnt surprise me if i am running the wrong update.....though saying that, SP4 is SP4......

Yes, version 8 is SQL Server 2000.

A few checklist items:
1. Check that the query you are firing against the database to determine the version is being executed against the correct instance, i.e. no aliases are defined. To do this, go to Programs -> Microsoft SQL Server -> Client Network Utility -> 'Alias' tab. There should not be any entries here
2. Did you reboot your SQL Server services (if possible, the OS) after installing SQL 2000 SP4?
3. SQL 2000 SP4 does not support WinNT 4.0. It would be great if you could share a bit of your hardware information
4. As told by "anesshattingal", have any errors been reported during the proess?
5. What query are you exactly firing against the server?

run this to get the current sp of your server

SELECT SERVERPROPERTY('ProductLevel')

1. Yup, No Aliases
2. 3 times so far with 3 installs of SP4
3. No probs, Server 2003 SP1 sitting on an IBM X346 with Dual Xeons and a Gb of Mem
4. No errors, the Install appears to be fine, but when i open enterprise manager - navigate to my DB's, and choose properties, they are at SP3, when i try and install my new app it says i need SP4.
5. No Query, As above, just looking at properties

If of any use, this is where I got my Service pack files from

http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx

As i mentioned, I am not too bad with servers, but SQL is foreign to me, it would not surprise me if i have missed something really obvious such as an update query or something like that, all i have done i run the .exe files

aneeshattingal,

Query shows SP3

In the properties pages, check for "Compatibility level". Ensure that it is 80.

level 80 it is

Ah i think i get what you are saying, howerver, i have say a Veritas Database (Instance?) and a WSUS Database (Instance?), If i go to the properties of either on of these i can see that they re running SP3

SQL Servers
  -- ServerA
        -- (local)(winnt)   (Has version type)
        -- Veritas Backup Exec (has version type)

 there is no remote servers, this is a standalone DR server

So i take it that this mean I have one instance locally with two databases attached?

Bugger it, decided to install SQL 2005 and go from there, hopefully i can convince the client to do the same.....ha!

Ill give the points to clockwatcher as at least I now know the difference between an Instance and a DB...lol