<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1264" name=GENERATOR>
<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 vLink=purple link=blue>
<DIV id=0></DIV>
<DIV><BR><SPAN class=551023715-10102003><FONT face="Courier New" size=2> if
you do it really quick you may get by with it:</FONT></SPAN></DIV>
<DIV><SPAN class=551023715-10102003></SPAN> </DIV>
<DIV><SPAN class=551023715-10102003><FONT face="Courier New" size=2>select
'kill', spid from master.dbo.sysprocesses</FONT> <FONT face="Courier New"
size=2>(nolock) where db_name(dbid) = 'your_database'</FONT></SPAN></DIV>
<DIV><SPAN class=551023715-10102003><FONT face="Courier New" size=2>print "exec
sp_dboption 'your_database', 'single', true"</FONT></SPAN></DIV>
<DIV><SPAN class=551023715-10102003><FONT face="Courier New" size=2>print "dbcc
checkdb('your_database', <FONT face="Times New Roman"
size=3>REPAIR_ALLOW_DATA_LOSS )</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=551023715-10102003><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=551023715-10102003><FONT face="Courier New" size=2>copy the
output into the qa window (make sure you're not in the database, use master to
do it) and run it.</FONT></SPAN></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><SPAN class=551023715-10102003><FONT face="Courier New" size=2>if this
doesn't fly, - yup, remove the publication. But I would also try to
offload the table in question to a temporary permanent table, truncate the
original table, and see if the results of dbcc checkdb
changed.</FONT></SPAN></DIV>
<DIV><BR></DIV><SPAN id=hbblock><LABEL id=HbSession
SessionId="2596082453"></LABEL>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
dba-sqlserver-bounces@databaseadvisors.com
[mailto:dba-sqlserver-bounces@databaseadvisors.com] <B>On Behalf Of </B>Mark
Boyd<BR><B>Sent:</B> Friday, October 10, 2003 8:47 AM<BR><B>To:</B>
SQLServerList<BR><B>Subject:</B> [dba-SQLServer]Repairing a corrupt
table<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">I am in the process of repairing
a corrupt table.</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; 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 face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Has anyone dealt with this sort
of issue before?</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">How can I tell if anyone is
connected to the database?</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">TIA,</SPAN></FONT></P>
<P class=MsoAutoSig><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Mark Boyd</SPAN></FONT></P>
<P class=MsoAutoSig><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Sr. Systems
Analyst</SPAN></FONT></P>
<P class=MsoAutoSig><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">McBee Associates,
Inc.</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></BLOCKQUOTE></SPAN>
<P></P></BODY></HTML>