Solved

Server: Msg 7105, Level 22, State 6, Line 1 afer running DELETE query.

Posted on 2006-10-29
9
1,217 Views
Last Modified: 2008-01-09
Hello

I have a Deepmetrix LiveStats server running on MSDE 2000 SP4.
I have been having problems with logins and Deepmetrix support asked me to run this query on my database:

DELETE FROM EventQueue WHERE EventType IN
(4001,4010,4000,4020,3000,6000,5000);

When I run it through Query Analyzer:

I get the error:

Server: Msg 7105, Level 22, State 6, Line 1
Page (1:2318), slot 33 for text, ntext, or image node does not exist.

Connection Broken

When I run it through osql queries via the command line, I get the following error:

Msg 21, Level 22, State 1, Server EGGSTER\DEEPMETRIX, Line 1
Warning: Fatal error 7105 occurred at Oct 29 2006  7:23AM

Deepmetrix support is very incompetent and I'm not very good with SQl myself. What would you suggest me to do?

I even backed up the DB and restored to an SQL 2000 server to see if it makes any difference, but it doesn't.

0
Comment
Question by:eggster34
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 40

Accepted Solution

by:
Vadim Rapp earned 500 total points
Comment Utility
Run DBCC CHECKDB ('name-of-your-database',REPAIR_REBUILD)
0
 

Author Comment

by:eggster34
Comment Utility
Server: Msg 7919, Level 16, State 2, Line 1
Repair statement not processed. Database needs to be in single user mode.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
0
 
LVL 10

Expert Comment

by:AaronAbend
Comment Utility
To get your db in single user mode,

shut it down.
In DOS, Go to the program files\microsoft sql server\MSSQL$DEEPMETRIX\binn directory
start up sql server with this command:  sqlservr -m

then you can use OSQL  to run the dbcc


0
 
LVL 21

Expert Comment

by:Kevin3NF
Comment Utility
What it all means is that you have data corruption in your database.  Running CheckDB without the repair options will tell you where (tables, indexes, etc.)

0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:eggster34
Comment Utility
I start the sql in single user mode with the -m switch, but on that command prompt, it does not allow me to run any queries.
How can I enter commands through osql after starting the server with the -m swtich?
0
 
LVL 21

Expert Comment

by:Kevin3NF
Comment Utility
If you get a "1>" you type your query and press enter.

You should then get a "2>"

Type GO and press enter again.
0
 

Author Comment

by:eggster34
Comment Utility
I don't get a 1 or a 2 or anything.. it just shows a black window that says recovery is complete and does not allow me to enter any commands..
0
 
LVL 40

Expert Comment

by:Vadim Rapp
Comment Utility
it shows black window in the window where you started the server.

Now open another command prompt in the same directory, and start osql there.

So you have 2 command prompts - one for hte server, another for osql where you will be entering the commands.
0
 
LVL 40

Expert Comment

by:Vadim Rapp
Comment Utility
...to stop the server, in osql window enter SHUTDOWN and then GO.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now