Internal SQL Server Error using OPENROWSET in SQL Server 2000 SP4  
Author Message
BitDrifter





PostPosted: Top

SQL Server Developer >> Internal SQL Server Error using OPENROWSET in SQL Server 2000 SP4

Hi.
I have a query that ready values from a Access database and update a table
in a SQL Server 2000 database with this values.
The query is:

UPDATE Tabela2
SET Tabela2.Descricao=Tab2.Descricao
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'C:\teste.mdb'; 'Admin';
'',Tabela2) AS Tab2
WHERE Tab2.Id = Tabela2.Id AND Tab2.Id IN (SELECT ID FROM Tabela2)

In this query:
-> The table "Tabela2" in the Access Database dosen't have primary key.
-> The field "Descricao" in the Access database is a memo field, and in the
SQL Server database is a ntext field.

In a server with SQL Server 2000 SP3 everything works fine, but in a SQL
Server with SP4 the query result in a "Internal SQL Server Error".

Can anyone explain me this?

Another question, is that I download the "Cumulative hotfix package for SQL
Server 2000 Service Pack 4 build 2187" to try fix my problem, but I can
install the hotfix because always I get an error of the instalation wizard.
Anyone can help?

Thanks,
Sérgio

SQL Server240