DBCC Opentran - possible causes for results

Have you tried sp_removedbreplication?
I'm assuming the database has been restored from another copy where it was
replicated, for the replication metadata to have got in ther in the first
place.
Here's a link for removedbreplication (from BOL 2005, but applies to 2000 as
well)
http://msdn2.microsoft.com/en-us/library/ms188734.aspx
you won't lose any objects. It just removes replication information which
will hopefully stop your t-log growing.
It doesn't drop any objects.
|||I thought you said it wasn't replicated? Now you're telling me it's your
publisher? You should make your mind up.
Running sp_removedbreplication will NOT remove any of your user objects. It
ONLY removes replication metadata. You can run it with a clause, e.g. 'tran',
'merge' etc. if you only want to remove transactional- or merge- replication
metadata.
I think you need to reassure yourself what is actually going on with your
database, i.e. is it being replicated or not. 'Cos the signals you're sending
out are somewhat mixed.
"Susanne Wenzel" wrote:

> Am Tue, 28 Nov 2006 00:54:01 -0800 schrieb thomarse:
>
> Are you sure about that? I've looked it up again in BOL and it says there
> it deletes all replication objects in a database. I would assume that means
> that all replication tables and stored procedures for replication will be
> removed. As the said database is our publisher that wouldn't come too
> good..
> Greetings
> Susanne
>

dbcc checktable(sysindexes)

I'm trying to attach a copy of a database to another server. When I do
this, the attach fails due to an index problem. The error message
indicates that I should run:
dbcc checktable(sysindexes)
when I run this on the original server (where the database is attached)
I get a missing sysindexes object error.
However, I am able to run this:
select * from sysindexes
without any apparent problem.
What do I do now?
FYI: dbcc checkdb reports no problems.
TIA.Hi Karl
Did you try DBCC CHECKCATALOG?
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Karl" <karlt@.nospam.nospame> wrote in message
news:O6WspeMbGHA.3740@.TK2MSFTNGP03.phx.gbl...
> I'm trying to attach a copy of a database to another server. When I do
> this, the attach fails due to an index problem. The error message
> indicates that I should run:
> dbcc checktable(sysindexes)
> when I run this on the original server (where the database is attached) I
> get a missing sysindexes object error.
> However, I am able to run this:
> select * from sysindexes
> without any apparent problem.
> What do I do now?
> FYI: dbcc checkdb reports no problems.
>
> TIA.|||Thanks for the reply.
DBCC CHECKCATALOG reports no errors. It also doesn't give any other
information other than that command completed successfully.
Now what?
Kalen Delaney wrote:
> Hi Karl
> Did you try DBCC CHECKCATALOG?
>|||Karl
So , you don't see the database since as you said the attach command is
failed, am I right?
Do you detach the database on the "source" server?
Can you perfom BACKUP DATABASE on the source server , then copy the .BAK
file to the "destination" server and run RESTORE DATABASE command? Do you
get the same error?
"Karl" <karlt@.nospam.nospame> wrote in message
news:%23iKyzWPbGHA.3376@.TK2MSFTNGP05.phx.gbl...
> Thanks for the reply.
> DBCC CHECKCATALOG reports no errors. It also doesn't give any other
> information other than that command completed successfully.
> Now what?
>
>
> Kalen Delaney wrote:
>> Hi Karl
>> Did you try DBCC CHECKCATALOG?

dbcc checktable(sysindexes)

I'm trying to attach a copy of a database to another server. When I do
this, the attach fails due to an index problem. The error message
indicates that I should run:
dbcc checktable(sysindexes)
when I run this on the original server (where the database is attached)
I get a missing sysindexes object error.
However, I am able to run this:
select * from sysindexes
without any apparent problem.
What do I do now?
FYI: dbcc checkdb reports no problems.
TIA.Hi Karl
Did you try DBCC CHECKCATALOG?
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Karl" <karlt@.nospam.nospame> wrote in message
news:O6WspeMbGHA.3740@.TK2MSFTNGP03.phx.gbl...
> I'm trying to attach a copy of a database to another server. When I do
> this, the attach fails due to an index problem. The error message
> indicates that I should run:
> dbcc checktable(sysindexes)
> when I run this on the original server (where the database is attached) I
> get a missing sysindexes object error.
> However, I am able to run this:
> select * from sysindexes
> without any apparent problem.
> What do I do now?
> FYI: dbcc checkdb reports no problems.
>
> TIA.|||Thanks for the reply.
DBCC CHECKCATALOG reports no errors. It also doesn't give any other
information other than that command completed successfully.
Now what?
Kalen Delaney wrote:
> Hi Karl
> Did you try DBCC CHECKCATALOG?
>|||Karl
So , you don't see the database since as you said the attach command is
failed, am I right?
Do you detach the database on the "source" server?
Can you perfom BACKUP DATABASE on the source server , then copy the .BAK
file to the "destination" server and run RESTORE DATABASE command? Do you
get the same error?
"Karl" <karlt@.nospam.nospame> wrote in message
news:%23iKyzWPbGHA.3376@.TK2MSFTNGP05.phx.gbl...[vbcol=seagreen]
> Thanks for the reply.
> DBCC CHECKCATALOG reports no errors. It also doesn't give any other
> information other than that command completed successfully.
> Now what?
>
>
> Kalen Delaney wrote: