jeffrey yao (6/22/2009)

---

I guess this argument is meaningless. We...

You won't find it under tables, you will find it under System Views.

Run this: select name, log_reuse_wait_desc from sys.databases

jeffrey yao (6/22/2009)

---

Michael Valentine Jones (6/22/2009)

---

jeffrey yao (6/22/2009)

I think "no primary keys, no constraints of any kind, no indexes, all columns were nullable, and dates were stored in varchar(8) instead...

And we have another one who can't seem to read.

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...