Repairing or checking a SQL Server database / table

DBCC commands

Full listing of DBCC commands can be found here:
http://msdn.microsoft.com/.../ts_dbcc_217n.asp

DBCC CheckTable
http://msdn.microsoft.com/.../ts_dbcc_40o5.asp

DBCC CheckDB
http://msdn.microsoft.com/.../ts_dbcc_00gy.asp

Additional non-MS information:
http://www.informit.com/...qlserver&seqNum=30&rl=1

Just execute right out of the SQL Query Analyzer

As always backup first