<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{font-family:Tahoma;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>I am in the process of repairing a corrupt table.</span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>My backup software is failing with the following message: ‘Table
Corrupt: Object ID 734690461, Index ID 2. Keys out of order on page (1:78526),
slots 145 and 146.’</span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>It seems table MSmerge_contents has become corrupt.
This table is used in the replication with another SQL Server.</span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>I ran DBCC_CHECKDB to make sure this was the only table
with corruption issues. Now I want to run the repair option, but am
prompted with a message stating the database needs to be in single-user mode in
order to repair. I tried putting the db into single-user mode, but am
prompted with an error message telling me the option can’t be changed
while another user is in the database. I’m pretty sure no one else
is in it, but am thinking the subscription to the other server needs to be
removed to do this.</span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>Has anyone dealt with this sort of issue before?</span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>How can I tell if anyone is connected to the database?</span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>TIA,</span></font></p>
<p class=MsoAutoSig><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>Mark Boyd</span></font></p>
<p class=MsoAutoSig><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>Sr. Systems Analyst</span></font></p>
<p class=MsoAutoSig><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>McBee Associates, Inc.</span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
</body>
</html>