August 12, 2009 at 4:28 am
I am moving some databases that Crystal Reports queries from one server. The server environment is SQL 2000 SP4 on both servers.
To move the databases I did a detach, copied the files across then attach for all 4 databases. One of the databases has views which are select * on tables in one of the other databases, but apart from that nothing perculiar.
When I execute the SQL query to return results on the original server (SQL query analyzer), I get the results expected. Executing the same query on the new server brings back no results. Changing the INNER JOIN commands to OUTER LEFT JOIN still brings back no results. A simple query on the table for one of the variables works fine though.
Originally the new server had a collation which wasn't the same as the original server, although the databases had the correct collation. I've done a rebuildm.exe to designate the correct collation.
Re-running the original query still brings back no results.
How can I track down what is causing this problem as it has left me scratching my head, just a little bit?
Geoff
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply