I have ran the command DBCC CHECKDB ('database name', REPAIR_REBUILD) to correct 3 consistancy errors in a table.
I have placed the server in single user-mode i.e.
Stopped all SQL Services, from the CMD Prompt <directory name>\sqlservr.exe -c -m
Went to Query Analyser to execute the command again and it tells me that it needs to be in single user-mode ! It is !!!!!