Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    4

    Unanswered: Why does the linked server syntax stop working?

    The servername.database.dbo.tablename syntax no longer works on my SQL 7 db however the OPENQUERY syntax works.

    Why is that?

    Can someone post an example of how to do a DELETE with OPENQUERY syntax?

    Thanks

  2. #2
    Join Date
    Aug 2002
    Posts
    20
    Hi,

    Your syntax can be correct but if the table on the linked server does not have an index your delete or update will not work.

    /Mada

  3. #3
    Join Date
    Sep 2002
    Posts
    4
    Originally posted by Mada
    Hi,

    Your syntax can be correct but if the table on the linked server does not have an index your delete or update will not work.

    /Mada
    Can you give me the an examplefor update and delete using OPENQUERY?

    Actually, how come the servername.database.dbo.tablename syntax would stop working when it was working before?

Posting Permissions

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