That's the entire trigger. Also, sorry about the confusion. I didn't understand what was missing in my replies.

It is the ACCPAC ERP software that provides an interface to the OEORDH...

There is no trigger on the table the trigger in question is inserting into. From what I understand, you are saying that creating a clustered index on the ACCPAC_FedEx_Middleware table...

Well, the trigger was actually meant to update a table residing in a different database after a row is inserted into the table residing in the current database, namely the...

You are right. I had written it incorrectly. The reference to the table actually had to be something like the following:

Derived_DB.dbo.tbl_ORDERS

I had mistakenly swapped the database name and the identifier...

Dear Mr. Moden,

You are right. It was carelessness on my part not to have taken heed of your post. And I apologize for that.

Now, to tell you the truth, I...

INSERT INTO dbo.Derived_DB.tbl_ORDERS

SELECT ORDER_ID, ORDER_DATE, CUSTOMER_ID

FROM OEORDH;

Yes, this is all I have in it.

Yes, it's true that this is a duplicate post. There were two reasons why I posted the same question here:

1. The final reply confirmed that I was not the only...

I appreciate it, sir. As you said, the application is very, very important and it's more important to protect the app than the database. Kindly pass me the links of...

David,

I was able to follow your response up until the point you began talking about freeing up the index. I might be a little confused here. Did you mean restore...

I don't remember the DBA who quoted this but he did make a statement regarding taking a log backup after a full database backup. But thanks for your response anyway.

David,

Your reply was very helpful and thought provoking. I didn't, however, understand the last couple of sentences in your response that state the following:

Also, this allows the backup chain to...

Yes, log files mean the virtual log files of the transaction log.

David,

Thanks a lot for your reply. I do have a couple of questions, however:

• You said that there may also be checkpoints that occur...during database recovery. I am wondering why a...

David,

Thanks a lot for your reply.