I have two servers with MSSQL 7.0 SP 3.

First I had a problem with remote queries: when a table was altered on the remote server, then queries referring it did not work any more, but gave "Error 7356: inconsistent metadata". I solved this problem by manually running the SP3's Instcat.sql, as advised.

Now it doesn't makes an error, but behaves rather odd, giving back only 1 row for certain queries. Why? OpenQuery solves the problem, but why does OpenQuery work better than the 4 part table names?

Thanks,
Gergely

-------

SELECT field FROM server.mydb.dbo.table WHERE key=601
(266 row(s) affected)

DROP TABLE xxx
SELECT field INTO xxx FROM server.mydb.dbo.table WHERE key=601
(1 row(s) affected) ?????

INSERT INTO xxx
SELECT field FROM server.mydb.dbo.table WHERE key=601
(1 row(s) affected) ?????

SELECT * FROM OPENQUERY(server,
'SELECT field FROM table WHERE key=601')
(266 row(s) affected)

DROP TABLE xxx
SELECT * INTO xxx FROM OPENQUERY(server,
'SELECT field FROM table WHERE key=601')
(266 row(s) affected) !!!!!!!

INSERT INTO xxx SELECT * FROM OPENQUERY(server,
'SELECT field FROM table WHERE key=601')
(266 row(s) affected) !!!!!!!