do not give DBO access to any user.

Setup 3 environments and take your changes throught them >> develoment >> testing  >> staging >> production, I have the same problem and this is...

when you setup replication it has tenticales all over the place.

Recomendation:

1)stop all replication , give time for things to settle down.

2)script out replication.

3)remove replication from publisher.

4)complete backup of the database (makes...

You will need to drop replication from the database, fix the problem with the table -- then re-enable replication.

I would recomend scripting out the replication before droping it. you can...

please excuse the previous reply -- I have no idea what happened, here is what i was trying to say.

1st: look for the longest running process in the sysprocesses table...

Are you running EM on the server or on the client, if on the client un-inastall/re-install the SQL Server client tools. if on the server just re-install the SQL client...

I have been working with replication for 2 and a half years. You can't successfully move replication from one server to another, unless you have a few (2,000,000) brain cells...