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 !!!!!
Sorted it out !
ALTER DATABASE database_name SET SINGLE_USERGO
DBCC CHECKDB('database_name', REPAIR_REBUILD)GO
Your database will remain in single-user modfe only.
to return to multi-user mode:
ALTER <database-name> SET MULTI_USER
Thank you for the update, greatly appreciated.Mike