Error 7105, how to fix it?

Hi
I am getting error 7105 Severity: 22 on one of my tables (about 1000
record), It seems 2 of the records has been corrupted. I can select other
records and edit the records as long as these 2 records are not part of
select query.
I have read microsoft support and they say that service pack2 should solve
this problem but my server already has service pack 3.
I can not choose these records to delete it, what is the solution, any idea?> I am getting error 7105 Severity: 22 on one of my tables (about 1000
> record), It seems 2 of the records has been corrupted. I can select other
> records and edit the records as long as these 2 records are not part of
> select query.
> I have read microsoft support and they say that service pack2 should solve
> this problem but my server already has service pack 3.
> I can not choose these records to delete it, what is the solution, any
idea?
What does DBCC CHECKDB report?
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Error 7105, how to fix it?

Hi
I am getting error 7105 Severity: 22 on one of my tables (about 1000
record), It seems 2 of the records has been corrupted. I can select other
records and edit the records as long as these 2 records are not part of
select query.
I have read microsoft support and they say that service pack2 should solve
this problem but my server already has service pack 3.
I can not choose these records to delete it, what is the solution, any idea?> I am getting error 7105 Severity: 22 on one of my tables (about 1000
> record), It seems 2 of the records has been corrupted. I can select other
> records and edit the records as long as these 2 records are not part of
> select query.
> I have read microsoft support and they say that service pack2 should solve
> this problem but my server already has service pack 3.
> I can not choose these records to delete it, what is the solution, any
idea?
What does DBCC CHECKDB report?
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Error 21776

I am using SQL 2000 and must have corrupted a database file because I get the following error message:

Error 21776: [SQL-DMO] The name 'MyDatabaseName' was not found in the Databases collection. If the name is a qualified name, use [] to separate varios partes of the name, and try again.

I am not able to detach, open, or remove this database and continue to get this message everytime I try an do anything. I know the MDF is there because I can look at the drive and see it.

Some of the threads recommend using various sp_?, Would I put these in query analyzer? If so, what database should I select to write my T-SQL? Are these global sp_? or should they be specific to the code?

If anyone has the answers, please let me know. Thanks

Perhaps the database has been 'detached' from the server.

Refer to Books Online about using sp_attach_db, or sp_attach_single_file_db

|||

You could be getting the error from already having removed the database - right-click the Databases folder in
Enterprise Manager and select Refresh.

-Sue