Skip to main content

Deferred prepare could not be completed

This is usually an error that is encountered while querying a remote database on a different server instance which says

OLEDB provider "SQLNCLI" for linked server "ABCD" returned message "Deffered prepare could not be completed"

Msg 8180, Level 16, State 1, Line 1
Statement(s) could not be prepared.

This is the way I could rectify, though this is not the lone mistake that gives this error every time.

Just set the default to the database that is being querying to the user through which the Linked server is connecting to the database.



















Comments

  1. AnonymousMay 9, 2012 at 7:29 PM

    That was it! Thanks. Prefixing the table names in the FROM clause inside the OPENQUERY with the DB name that the tables are in on the linked server fixed the problem.

    ReplyDelete
  2. KenMarch 9, 2013 at 1:49 AM

    Wow. That was easy. I was pulling my hair out over this...

    ReplyDelete
  3. UnknownJune 16, 2014 at 2:32 PM

    Thank you very much, this post was a great help to me.

    Regards,

    ReplyDelete
  4. AnonymousFebruary 16, 2015 at 12:43 PM

    problem is hard to indentify, but solution is simple.. really Thanks

    ReplyDelete

Post a Comment

Popular posts from this blog

Transaction Log Full

Its often to have issues on transaction log getting full with an error: The Transaction Log for the database ABC is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in the SYS.DATABASES System catalog view. If we execute the following query in the query editor, select log_reuse_wait_desc from sys.databases where name = 'ABC'; we get one of the follwing possibilities: Reuse of transaction log space is currently waiting on one of the following: 0 = Nothing Currently there are one or more reusable virtual log files. 1 = Checkpoint No checkpoint has occurred since the last log truncation, or the head of the log has not yet moved beyond a virtual log file (all recovery models). 2 = Log backup A log backup is required to move the head of the log forward (full or bulk-logged recovery models only). Note: Log Backup do not prevent truncation 3 = Active backup or restore data backup or a restore is in progress (all recovery...
Post a Comment
Read more