Breaking News
Loading...
Monday, 11 May 2015

Info Post

SQL Database error and Solution

Could not retrieve row from page by RID because the requested RID....

Solution

Execute below query one by one at once using Query Analyzer


Use database_name
GO
ALTER DATABASE database_name SET SINGLE_USER
GO
DBCC CHECKDB('database_name', REPAIR_REBUILD)
GO
ALTER DATABASE database_name SET MULTI_USER
GO

0 comments:

Post a Comment