Thank you for the explanation/clarification.

This is greatly appreciated.

I can't change the trigger without breaking our support contract.

So I'll have to disable the triggers and do an update.

Again I really appreciate...

Yes.

There are two triggers causing this.

V_AU_CUSTOMER

V_AU_CUSTOMER1

I could disable triggers and the update works.

But I'm not sure of the impact yet.

The trigger names are the sames as the actual tables impacted.

V_AU_CUSTOMER

V_AU_CUSTOMER1

These...

Lowell,

Thank you.

Any thoughts on how SoldToAddress could represent all columns in the address?

tia,

Todd

MysteryJimbo (1/3/2014)

---

You can export the execution plan from the buffer cache using this dmv. You can find many examples of the queries if you google this dmv.

http://technet.microsoft.com/en-us/library/ms189747.aspx

Export the execution plan...

arnipetursson (1/3/2014)

---

What type of storage do you have?

Thin provisioning?

Did you see disk queues go up during these events?

Does it happen on the same days of week/time of day?

Any maintenance going...

Chris,

The only way I know of discovering the query is to set a trace, execute the action, and stop the trace.

Then I could copy it from the trace file and...

After reading these links this sounds promising.

Thank you both (Greg and MysteryJimbo).

The next occurrence of the problem should be somewhere around the 15th +/- a day or two.

We will have...

MysteryJimbo (12/31/2013)

---

This may or may not be of help. We had a similar problem, on an older version of windows, and this was related to not enabling "background memory...

We...

yes...

I did...

It worked...

Thank you for helping.

-Todd

Gail,

Thank you.

Still downloading BOL to my new laptop. Another 6 minutes to go.

But your comments really helped I think.

Would this work?

INSERT into user_def_fields

(

program_id,

id,

Document_id,

Line_no,

Del_Line_no,

Label,

Data_Type,

Display_Format,

Tab_or_Table,

Tab_ID,

Table_ID,

Sequence_No,

UDF_Required,

String_Val,

Number_Val,

Bool_Val,

date_val

) ...

HanSHi,

I want to thank you for your help and pointing me in the right direction.

All worked out well. I learned a lot through this event.

Its back to zero based...

OK this was good but one more issue:

When I change to single user mode and stop all sql services i cannot login. It says only one administrator can login.

So i...

I have a backup of the master from the 13th at 8:00pm

If I use that what would the impact be on my data?

i have never had to restore the master db.

Is the process the same as restoring any other database?