MS03-031 updates the SQL 2000 Server to version 8.00.0818.

Tim S

Here's what I started using last week on some table doc I am doing in excel

SELECT

TABLE_NAME, COLUMN_NAME,

COALESCE(DOMAIN_NAME, (DATA_TYPE + COALESCE('(' + NULLIF(CAST(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(4)),...

I would try re-istalling the SP for SQL Server not the MSDE; it fixes about half these types of problems for me. I would guess that the MSDE changed an...

It does not update the MDAC on XP & 2003 machines. I would guess the MDAC is in use so it had to re-boot to replace some files.

Tim S

select * from t1

where exists (select * from t2 where t1.c1 = t2.c1 and t1.c2 = t2.c2)

Tim S

The Windows 2000 server is on SP 3 for SQL 2000 and it is Service Pack 4 on the windows OS. So if you want it to be SQL SP4...

Does it have the correct version number of 8.00.2039.

Most people confuse the OS version number as being the SP version.

Tim S

"Windows 2003 Server requires SQL 2000 SP3"

MS ONLY supports SQL 2000 SP3 or higher on Windows 2003 Server.

No idea of the best way to upgrade, but I would upgrade to...

I just saw it on a test server SQL 2000 RTM upgraded to SP4 running under Windows 2003 SP1

Tim S

Link for above quote

http://support.microsoft.com/?kbid=884525

In addition, Support is being dropped for some of the OLD protocals in SQL 2005; the one I am aware of is DB-LIB support.

Tim S

I had the problem, but it went away after re-appling SQL 2000 SP4 Beta; I assume I just broke SQL 2005 in some way when I did it.

Tim S

Note: Above...

select c.client_no,

Client_Name = decode(c.given_names,null,c.agency_name_surname||decode(c.section,null,'',', '||c.section),ltrim(c.title||' '||c.given_names||' '||c.agency_name_surname))

from clients c

where c.parent_client = 'CLC'

or c.agency_name_surname like ('%COMMUNITY%')

order by c.client_no;

The excel I last used 6 months ago...

I would create a view if the number of AttributeId was 16 or less in total.

But, from you post I would guess higher.

If the total number of AttributeId per product...