Can you please help me to set up a trace, I never did it. Thank you

Thank you, I am trying to upgrade to SQLServer 2005 and wanted to get rid off old databases before upgrading,so your sugesting put a trace on databases?

Oh thank you, for some reason never saw replied I will check

Thank you this what I was looking for

Thank you,but this is not what I am looking for:

I need to convert that field at the end = to 3/15/2011

datepart I thought,but can't figure out correct syntax

Nothing in sql logs

remove from replication

ii) make changes

iii) re-sync. This will take a fresh snapshot.

Guys, I just checked the schema and data was replicated to the other table, but they don't see it on the webside, so I think this is not replication problem....

Onestly, I am afraid to create a new publication, because this data goes to production, that we don't support. Another provider have access to production server and I ran replication...

Can I put tabel to the same publication?

Can try this

1.Pull the table out of replication

2.Reinitialize all subcriptions

3.Put back my table to the publication original

4.Reinitialize all subcriptions

Originally, I Pull the table out of replication, made changes,put it back...

In that situation getting the snapshot to recognize the changes can be sometimes problematic. The steps I sent should work IF you are ok with pushing a new copy of...

Did you put the table back in the same publication? Are there other tables in that publication?

Yes, I put the table in the publication and yes there is other...

1.Removed out of the replication

2.Modified table

3.added to the replication

4.Reinitialized with a new snapshot.

I already did it bunch of times and when I do it renitialized and check monitor it showing...

Both