I installed sql server 2000 sp2 standard edition on Windows 2003, when
installing, it said "This version is not supported on this os", but I was told
to continue installing the software and that I could install the latest
security patches to bring it up to date. Will that work? Do I need to do
anything else? SQL Server 2000 is up and running on the box. When running
the statement " select @@version" it informed me that I was at 8.00.194
patch level. How can I tell if SQL Server 2000 is 32 or 64 bit? I was
trying to download the lasted patch and it asked for that info. Thanks.--
New to SQL Server
Unless you paid over $20,000 for SQL Server, it is probably 32 bit. I think the 64 bit version of SQL server states in @@version that it is 64 bit, so if you do not see anything, you very likely have 32 bit.
You need SQL Server SP3 to run on Windows 2003 with no problems. Just download the patch, run it, and you should be all set.