nscott (6/22/2009)

---

Hello,

I am trying to insert 489 records in Access from one linked SQL 2005 table to another and get the following message:

[ODBC--insert on a linked table 'dbo_WKORDER' failed.

[Microsoft][ODBC SQL...

Run this query:

select * from sys.event_notifications

What is happening on the network during that time? Any network backups, large data transfers between systems, heavy user activity? Anything that may cause a delay on the...

rob.patterson (6/22/2009)

---

Yeah, I saw that in BOL also. But it HAS to be stored...

Sorry, but according to BOL (Books Online) that information is not stored in metadata.

It could be an intermittent network issue. The best thing to do is actually perform all your backups to a local directory and then move (or copy) the backup...

Echo...

This site was mentioned earlier in the thread...

NEI, Not Enough Information. At this point, please read the first article I have referenced below regarding asking for assistance. Without knowing the table definitions and how the...

I don't know what is going on here, but for some reason I can't post my code directly in this thread.

Attached is the code I put together for your problem....

Is Order the name of a column in the table? If so, put brackets around it, like this:

tablealias.[Order] -- Please note, I didn't use yout table name, short term...

How about posting the code for dbo.udf_GenerateNextFilename?

businessintelligence2010 (6/22/2009)

---

Hello -

What is not right below? I am trying to pull a data from another table where 'Inncode' from tblOTSOrder = first 5 character from 'Site_Id' from tblSRO378.

select

tblOTSOrder.InnCode,

tblSRO378.Order

FROM tblOTSOrder

INNER...

Actually, if I did the search correctly, I found 5 SELECT DISTINCT statements in the code.

Edit:

And 3 cursors.

I have to agree whole heartly with Grant on this one. I'd want to get paid to work on that one. Lot of code, not a lot of...

Isn't this, optimized cursor an oxymoron?? 😉