[font="Verdana"]Create a new DTS package and add 'Transfer Jobs task'- Used to copy jobs from an instance of SQL Server 7.0 or SQL Server 2000 to an instance of SQL...

Can't you simply create a DTS package using the service account and schedule it?

Any links to the information on these bugs? 🙂

This might be what you are looking for, even if it is not; it does give you a pretty good idea of how to start working on it 🙂

After a little bit of research revealed that the data is intact and the fields for date, month and hour have numeric values because these tables are used for datamining...

Paul Randal (12/2/2008)

---

Hmm - I don't think the corruption was in the nonclustered indexes - I think the corruption was (and still is) in the base table itself. All the...

No errors 😀 :w00t:

The command(s) completed successfully.

Paul: Thank you, for all the insights and advice 🙂

Gail: Thank you, for showing me the way 🙂 I will take up the...

This is the full code that I was supposed to post 🙂

CREATE

INDEX [IDXOUT1_54] ON [dbo].[OUT_54] ([YEAR], [MONTH], [DAY], [HOUR], [UPLANLINEID])

WITH

DROP_EXISTING

ON [PRIMARY]

GO

CREATE

...

Ran this:

CREATE

INDEX [IDXOUT1_54] ON [dbo].[OUT_54] ([YEAR], [MONTH], [DAY], [HOUR], [UPLANLINEID])

WITH

DROP_EXISTING

ON [PRIMARY]

Restarting the CHECKDB, it will take about 3 hrs to run :)...will update...

😀 will take it up with them.

By the way, the earlier attachment was not the right one.

I am adding the full details here.

Attached!(sorry, wrong attachment)

Do you have checkDB running as a regular job? If so, when...

So,Finally DBCC finishes execution and the output is posted below:

Consolidated:

----------------------------------------------------------------------------------------------------------------

CHECKDB found 0 allocation errors and 201 consistency errors in table 'OUTP_54' (object ID 434152642).

CHECKDB found 0 allocation errors and 197...

Sorry, Completely missed answering the question. Yes, we do have backups configured via SnapManager. And, I should have mentioned this earlier; the corruption happened while doing a database shrink.

Thanks for...

DBCC TRACEON (3604) -- just directs the DBCC PAGE output to the current connection

GO

DBCC PAGE ('LG_REFRIDGE', 1, 20951542, 1)

GO

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

PAGE:...

Thanks for the inputs. And yes, it is a SQL Server 2000 Enterprise Edition, SP4. I will post the results once, I have them.

Regards,