Solved

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

Posted on 2006-10-29
9
1,269 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 40

Accepted Solution

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

Author Comment

by:eggster34
ID: 17828826
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
ID: 17829254
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 21

Expert Comment

by:Kevin3NF
ID: 17829678
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
 

Author Comment

by:eggster34
ID: 17836799
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
ID: 17837056
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
ID: 17837136
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
ID: 17837398
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
ID: 17837508
...to stop the server, in osql window enter SHUTDOWN and then GO.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

624 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