Are there any missing entities in your join? I'm (probably wrongly) assuming that there can be several contributiong factors to an accident/driver. What is the definition of the...

Can you test on another server at SP4 to possibly isolate whether it's indeed an SP4 problem or maybe a problem with your server's tempdb?

Cheers,

- Mark

Unfortunately job notifications will not show such information. You need to look at the job history to see such information.

Cheers,

- Mark

It appears your database is truly corrupted and attempts to reset the status will not be successful (as you've found out).

Do you have a recent full backup to restore from?

Were...

quote:

---

What am I looking at when I run "DBCC MEMUSAGE"? dbid and objectid I got, but units of measurement is "Buffers",...

Look up "editions of SQL Server" in BOL's index. The most relevant topics are "Maximum Capacity Specifications" (where, if you scroll down, you'll come to number of CPUs and...

quote:

---

now that we will soon be having an Access forum

---

Are we? Shows how much...

I've tried another method of grabbing the middle rows. Using TOP to get the top half (and a bit) of the rows, and TOP again to get the bottom...

Do you get any joy from a RESTORE HEADERONLY or from a RESTORE VERIFYONLY?

Cheers,

- Mark

Edited by - mccork on 08/14/2003 9:48:27 PM

I don't know if this is the right forum for Excel to Access questions, but I'll have a go anyway....

Is it possible that any of the column headings aren't valid...

I could only think of "warnings" (in which fapel isn't interested). I have no facts on why it wouldn't work. I can only strongly recommend following documented MS...

Your could create a UDF that could be called from a CHECK constraint to prevent unwanted characters being entered. Or, it could be used by an INSERT/UPDATE trigger to...

Unfortunately you can't BCP between tables.

Maybe a future version will have a BULK EXTRACT to complement BULK INSERT, or BULK INSERT from a table?

You can use DTS but...

Thanks Jimmy.

Time zone sometimes prevent a prompt reply.

Cheers,

- Mark

quote:

---

The conversion error is actually happenning when I attempt to set the value of @_Out_TradeCID

---