Take the tour ×  I am changing the increment (making it 2
instead of 1) in identity of a column. SQL Server giving me the
following error while making change to DB. I searched on
internet but some of people saying that this can be a hardware
issue but I've tried the same thing on different machine but it
is giving me the same error. Following is the error...  Unable
to modify table. SQL Server detected a logical consistency-based
I/O error: incorrect checksum (expected: 0x0c413292; actual:
0x0c413282). It occurred during a read of page (1:21513) in
database ID 7 at offset 0x0000000a812000 in file 'C:\Program
Files\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TimeCommerceV5.mdf'.
Additional messages in the SQL Server error log or system event
log may provide more detail. This is a severe error condition
that threatens database integrity and must be corrected
immediately. Complete a full database consistency check (DBCC
CHECKDB). This error can be caused by many factors; for more
information, see SQL Ser