Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2001


    instcat is used to update the catalog SPs which get the database schemas for various things so would have something to do with the area you have problems.

    Are both servers sp2?

    What do you mean when you say 'write any select query from one server to another' - a query over a linked server?
    I would suspect that you have ended up with incompatible servers in that case or one has some corruption - maybe a failed service pack. The best solution is probably to make sure all servers are at the same level.

  2. #2
    Join Date
    Dec 2001
    Yes. Both servers are having SQL 7 SP2 and MDAC 2.5 SP1 version (This config is forced to keep since our major clients are having same version). both service packs didn't resulted any errors during installation.

    I am executing a select statement from server 1 to server 2

    for ex. following query running from server 2. the database restored a copy from server 2.

    select col1, col2 from server1.database.dbo.tablename

    if I execute from server 1 the following query is working fine.

    select col1, col2 from server2.database.dbo.tablename

    Please let me know if you have any answer. Thanks for your kind help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts