Ben, That is so true!

Although I am leaving my current employer, I was faced with the same scenario as you, more support less development!

Im glad to be moving on.........

Thanks ill give that a shot

Hi Jeff

Thanks for the reply

I like your PERSISTED column idea.

Do you mean add another column to my cards table that is populated with a 1 if all those conditions are...

Thanks for the reply.

This has now been resolved

Sean Lange (8/21/2013)

---

imran.adam (8/21/2013)

---

It basically gives each record a unique number

see this http://technet.microsoft.com/en-us/library/ms186734.aspx%5B/quote%5D

That is the correct link but your description is incorrect.

Using PARTITION in the context of...

It basically gives each record a unique number

see this http://technet.microsoft.com/en-us/library/ms186734.aspx

Thanks for all the replies, there wasnt really an issue, it was just slow as the log reader agent was trawling through the log and skipping any tables not marked...

GilaMonster (7/15/2013)

---

That is corrupt beyond the point of being able to identify objects. You've got fatal metadata corruption and allocation page corruption.

You're going to be very lucky if you get...

OK, here is the output from the CHECKDB (i cannot see the objectname?)

Msg 8946, Level 16, State 12, Line 2

Table error: Allocation page (1:28502112) has invalid PFS_PAGE page header values....

george sibbald (7/15/2013)

---

check also the minimum repair level checkdb reports.

If its a non-clustered index that turns out to be corrupted you may be able to just drop and recreate it.

Do...

GilaMonster (7/15/2013)

---

2000 questions should go in the SQL 2000 forums.

You have database corruption, so that object id is very likely invalid, especially given the nonsensical index id listed (max index...

GilaMonster (7/15/2013)

---

You've got database corruption.

The table name will be printed as part of the CheckDB output. Please run the following and post the full and complete output.

DBCC CHECKDB (<Database Name>)...

Sorry that did not work, it came back with NULL

GilaMonster

Just double checking, even if I was to...

Thanks GilaMonster

I will do as you suggested.