Error: 644

I get this warning when I do a dbcc checkdb:

Server: Msg 2750, Level 16, State 4, Line 2
Warning: Page (1:300465), Slot 9 in object 2009058193 Index 0 Column Val value -1.#QNAN is out of range for data type "real". Update column to a legal value.

A service using a stored procedure result in the following errir in the event log:

Error 644, Severity: 21, State 5
Could not find the index entry for RID '16ca8880200' in index page (1:31928), index ID 7, database 'BPS'.

I have tried 'dbcc checkdb' and 'dbcc checktable' both with option REPAIR_REBUILD and I have tried 'dbcc reindex' but none of them helped.

Are there other options or can I find the column that shall be updated to a legal value?Did you get any error messages when your ran the DBCC's?

Sounds like a corruption problem to me...

Can you export the data? You may need to do it in ranges...you'll find there will be probably 1 corrupt row...

SELECT * FROM myTable WHERE identity < 1000
and so on...do a binary search..start at the middle your data...

In either Case, you'll either need to do a restore (which hopefully isn't corrupt), or export the data and build a new db...don't know what else could be hosed..

But that's only my own opinion (MOO)|||Have you tried to drop the index and recreate it ?
Have you used the REPAIR_ALLOW_DATA_LOSS option ?

Error with install of sept CTP Enterprise edition

Does SQL Server 2005 Sept CTP not support installation on XP? When I am installing, it gives me a warning that some things may not work with this OS, then when I get to the next screen I can't install anything.

Have you checked the pre-requisites such as .NET framework and IE version etc.
BTW what is the edition of XP & edition of CTP used?|||I am trying to install the september ctp enterprise edition on a machine with xp/sp2. I have reviewed the prereqs and I meet all of them. It says XP with sp2 and 512 ram; both are satisfied. I don't see any prereqs for .NET and I think that is because it installs .NET 2.0 when it installs. Any other ideas?|||Here is the warning I get when starting the install of the september CTP Enterprise version on a machine with XP/SP2 installed. If i continue to the components available for install, then the only thing enabled is 'Workstation components, ...'. All the actual database stuff is disable for install.

- SQL Server Edition Operating System Compatibility (Warning)

Messages

SQL Server Edition Operating System Compatibility

Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.

|||Enterprise Edition needs a server OS. You can install Express, Workgroup, Std and Developer Editions on XP, ie Desktop OS's|||I figured that was the problem. However, the download site does list XP/SP2 as a compatible OS for the enterprise edition. The bullet below was copied directly from the download page.

Supported Operating Systems: Microsoft Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows XP Service Pack 2

Error while updating INDEXES

I was updating few indexes in one of my database tables when I got this warning message:
"Warning! The maximum key length is 900 bytes. The index 'IX_cc_statusText' has maximum length of 1024 bytes. For some combination of large values, the insert/update operation will fail."

Can anyone help me out as to:
1. Why this warning was thrown?
2. What are the implications of the same?
3. How to rectify this?

Here is the script I was using to update the indexes:

CREATE INDEX [cc_programEnrollment14] ON [dbo].[cc_programEnrollment]([cc_company_uid]) ON [PRIMARY]
GO

CREATE INDEX [IX_cc_program_uid] ON [dbo].[cc_programEnrollment]([cc_program_uid]) ON [PRIMARY]
GO

CREATE INDEX [IX_cc_status_uid] ON [dbo].[cc_programEnrollment]([cc_status_uid]) ON [PRIMARY]
GO

CREATE INDEX [IX_cc_CompanyID] ON [dbo].[cc_programEnrollment]([cc_CompanyID]) ON [PRIMARY]
GO

CREATE INDEX [IX_cc_statusText] ON [dbo].[cc_programEnrollment]([cc_statusText]) ON [PRIMARY]
GO

CREATE INDEX [IX_cc_initiatedDate] ON [dbo].[cc_programEnrollment]([cc_initiatedDate]) ON [PRIMARY]
GO

CREATE INDEX [IX_cc_initiatedBy_uid] ON [dbo].[cc_programEnrollment]([cc_initiatedBy_uid]) ON [PRIMARY]
GO

CREATE INDEX [IX_cc_SponsorID] ON [dbo].[cc_programEnrollment]([cc_SponsorID]) ON [PRIMARY]
GO

CREATE INDEX [IX_cc_SponsorDistributor_uid] ON [dbo].[cc_programEnrollment]([cc_SponsorDistributor_uid]) ON [PRIMARY]
GO

CREATE INDEX [IX_cc_programEnrollment] ON [dbo].[cc_programEnrollment]([cc_isDealerEligible], [cc_uid]) ON [PRIMARY]
GO

Thanks in advance
DexterHey Dexy,

you're index creation is failing because your column cc_statusText is longer than 900 bytes. You should try and create your indexes on the smaller columns, as I'm quite positive larger columns will take a bit longer to look up in the index.

Have a look here...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_0ldf.asp

Regards,
-Kilka