How do I run a DBCC Checkdb? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

How do I run a DBCC Checkdb?

Author

Topic

HolmesChiro
Starting Member

9 Posts

Posted - 2009-11-16 : 14:39:39

Hello,

I hope this is the right place to post. I have zero experience with SQL and I googled my work's program error and found this place.

My work is running Lytec 2007. It's unsupported by the Lytec Tech people because they want us to buy their new version. So anyway, we have the Multi User program and Lytec is installed on 3 computers. My computer is also the server.

Reposting this from another forum.

A few days ago I tried to print something in Lytec. I got this error:

Attempt to fetch logical page (1:138440) in database 'Holmes Chiropractic' belongs to object 'syscomments', not to object 'Billing Detail'.

I restarted the computer, but still got the error. Nothing has changed or been updated in Lytec. The weird thing is computer #3 prints just fine, but my computer and computer #2 get this error. Occasionally, if we try printing 5+ times, we get lucky and the document will print despite the error.

I've downloaded managment studio but I have no idea what I'm doing. I made a "new query" and pasted what I found in google:

declare database_cursor CURSOR for select name from master..sysdatabases
declare @database_name sysname

open database_cursor
fetch next from database_cursor into @database_name
while @@FETCH_STATUS=0
begin
print @database_name
dbcc checkdb(@database_name) with no_infomsgs
fetch next from database_cursor into @database_name
end

close database_cursor
deallocate database_cursor

and I got this error when I hit execute:

Holmes Chiropractic
Msg 916, Level 14, State 1, Line 9
Server user 'SERVER\Holmes Chiropractic' is not a valid user in database 'Holmes Chiropractic'.

Can anyone help me fix this?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-16 : 15:56:44

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=135900

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources