I can see one potential problem right away. Activity_id in the journal table is a varchar(50), but in the query you're joining that to a decimal. That's going to cause...

I hate...

And read through this - http://www.sqlservercentral.com/articles/64582/

Access doesn't have a query analyser. There's the query design too inside Access, but that's all I know of for it.

Maybe. But if all you're doing is changing the temp...

ALZDBA (12/28/2008)

---

GilaMonster (12/28/2008)

---

Unfortunately, it's not the image/text pages that are damaged. The checkDB output points to 4 pages of index 0 (the heap) that are the ones with problems. If...

Jeffrey Williams (12/28/2008)

---

I would recommend that you don't get rid of the data corruption forum. It should be one that stands by itself for those cases where someone is...

ALZDBA (12/28/2008)

---

Does this point to a table that contains text or image columns ?

Try to export the data without these column, so you only lose the text/image stuff if these...

If it's not marked as a deprecated feature (which, if you check, DBCC DBReindex and DBCC...

Does your copy of Books Online say that CheckIdent is deprecated?

Why don't you come...

Well, DBCC certainly is old. Some of the commands have been around since SQL 6, but then that's true for a select statement too.

Many of the DBCC statements are deprecated...

He's a repeat offender who just doesn't seem to get it. I have several unpleasant memories of that guy's...

leonp (12/27/2008)

---

Also, you mentioned single row inserts .... was that based on the logs or profiler output I shared ... I thought the app was running transactions spanning 10,000 row-inserts....

leonp (12/27/2008)

---

when I run bulk inserts from the flat file into the SQL server, (which is ~thrice the total volume read), 35 million rows (18G) are loaded in server...