In Sql Server 2008

When I run below query:

SELECT COUNT(*)

FROM [COMPASSPROD]..[COMPASS].[VW_CTP_SS_GRP_FUND_DATA]

it gives 200 records which is incorrect.

When I run Same query in Oracle DB

SELECT COUNT(*) from [COMPASS].[VW_CTP_SS_GRP_FUND_DATA]

it gives me...

Evendata() can be used to audit events in database level.Assuming that you are using SQL Server 2005 then please refer below link

http://msdn.microsoft.com/en-us/library/ms173781(SQL.90).aspx

Thanks for the help!!!!

I think I cannot repair sysindexes table as it is a system table. It seems that I need to create a new database and export all tables...

When I perform dbcc checktable on sysindexes table I get below error:

Server: Msg 8929, Level 16, State 1, Line 1

Object ID 2: Errors found in text ID 3192586240 owned by...