Consistency Error

Hi

I have execute a script on my SQL Db (script to create indexes and views) and got the following error

Server: Msg 823, Level 24, State 2, Line 1
I/O error (bad page ID) detected during read at offset 0x000000232fe000 in file 'D:...filename.mdf'
ODBC: Msg 0, Level 16, STate 1
Communication link failure

DBCC CHECKDB returned

Database '' consistency errors in sysobjects, syscolumns, or systtypes prevent further CHECKDB processing..........

dbcc checktable ('syscolumns') returned

Server: Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID 0, page ID (1:86382). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID 0, page ID (1:86383). The PageId in the page header = (0:0).
Server: Msg 8928, Level 16, State 1, Line 2
Object ID 3, index ID 0: Page (1:86382) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 2
Object ID 3, index ID 0: Page (1:86383) could not be processed. See other errors for details.
CHECKTABLE found 0 allocation errors and 2 consistency errors not associated with any single object.
DBCC results for 'syscolumns'.
There are 2059 rows in 133 pages for object 'syscolumns'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'syscolumns' (object ID 3).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (databasename.dbo.syscolumns ).


Please help to solve this issue

Thanks & regards,
Eldho