Replication problem... Please Help!

Hi,
I have the following problem with a Transactional Replication between two SQL Server 2000:
- One Database is replicated from one server to the other and it works well.
- I have cancelled the distribution, the publication and the subscription in the right order. So technically, there should be no trace left of the replication.
- Then I try to run a script to alter the type of a column and I get the following error message : "Cannot alter column because it is 'REPLICATED'."
- When I look at the colstat value (in syscolumns) for this column, it has a value greater than 4096 which means that it is effectively marked for replication.
Why is that happenning?
What can I do the remove the replication traces, and then be able to change the column type?
Thanks for all your help!!!
Jenny
Hi,
When I say I "cancelled" the replication, I mean that I have deleted everything related to the replication. So in my opinion there should not be any trace left of
the replication in my tables info. Is there a way to remove the replication info on a particular table? I really don't know what to do!
Thanks,
Jenny
"ChrisR" wrote:

> When you say you cancelled distribution, do you mean you
> got rid of the distribution db or turned off the agent? If
> you mean turned it off, Im not sure where, but this info
> is still in one of the system tables probably in the
> distribution db. Ive had to mess with these before for the
> same thing. Id figure it out right now for you but Im a
> bit pressed for time. Id be willing to bank on it being in
> the MSArticles table though. Let us know if thats not it
> and if you cant figure it out.
>
>
> Replication between two SQL Server 2000:
> and it works well.
> the subscription in the right order. So technically, there
> should be no trace left of the replication.
> column and I get the following error message : "Cannot
> alter column because it is 'REPLICATED'."
> this column, it has a value greater than 4096 which means
> that it is effectively marked for replication.
> be able to change the column type?
>
|||Assuming that you actually went and ran the Disable
Publishing and Distribution Wizard so you no longer have a
Distribution database, I wouldnt know what to tell you.
Chane the column value that you were talking about and see
if that help.

>--Original Message--
>Hi,
>When I say I "cancelled" the replication, I mean that I
have deleted everything related to the replication. So in
my opinion there should not be any trace left of
> the replication in my tables info. Is there a way to
remove the replication info on a particular table? I
really don't know what to do![vbcol=seagreen]
>Thanks,
>Jenny
>"ChrisR" wrote:
you[vbcol=seagreen]
If[vbcol=seagreen]
info[vbcol=seagreen]
the[vbcol=seagreen]
in[vbcol=seagreen]
it[vbcol=seagreen]
other[vbcol=seagreen]
and[vbcol=seagreen]
there[vbcol=seagreen]
means[vbcol=seagreen]
then
>.
>
|||Use this stored Procedure sp_removedbreplication
This should solve your problem. (If you have removed using one of the wizard)
Rakesh
"ChrisR" wrote:

> Assuming that you actually went and ran the Disable
> Publishing and Distribution Wizard so you no longer have a
> Distribution database, I wouldnt know what to tell you.
> Chane the column value that you were talking about and see
> if that help.
>
> have deleted everything related to the replication. So in
> my opinion there should not be any trace left of
> remove the replication info on a particular table? I
> really don't know what to do!
> you
> If
> info
> the
> in
> it
> other
> and
> there
> means
> then
>
|||Hi Jenny,
Some of your columns are still marked for replication - see
http://support.microsoft.com/default...b;en-us;811899
for a workaround.
Cheers,
Mark
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!