Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Drop Failed: Access to Table dbo.suspect_pages is blacked

Avatar of gtrapp
gtrapp asked on
MySQL Server
1 Comment1 Solution969 ViewsLast Modified:
Hi,

I am trying to drop a database, but seeing an error and can't drop the database. This is an old unused WSS 3.0 database, and I have SQL Server 2005 on the server. I tried dropping the database within Mangement Studio.

Drop Failed For Database "WSS_Content_81"

Access to table dbo.suspect_pages is blocked because the signature is not valid. Problems recording information in the msdb..suspect_pages table were encountered. This error does not interfere with any activity expect maintenance of the suspect_pages table. Check the error log for more information. Microsoft SQL Server, Eorror: 33002)

I also tried the drop command, but received a:

Cannot drop the database 'wss_content_81', because it does not exist or you do not have permission.

Now a restart of the server, MS SQL and SharePoint services may resolve this problem and the database will be gone. However, can you suggest other solutions?

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of dkempton
dkempton

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answers