Hi,
I am getting an error when i select a table.
Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.
2 Days back my database has gone into suspect mode and i solved it.
When I did DBBCC Checkdb by below syntax
ALTER DATABASE POSS SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
BEGIN TRANSACTION;
DBCC CHECKDB ('POSS');
ALTER DATABASE POSS SET MULTI_USER;
I am getting following errors
Msg 8992, Level 16, State 1, Line 3
Check Catalog Msg 3858, State 1: The attribute (max_length=0) of row (object_id=119007505,column_id=8) in sys.columns has an invalid value.
Msg 226, Level 16, State 6, Line 4
ALTER DATABASE statement not allowed within multi-statement transaction
Thanks
Sanju