Are you seeing any specific messages in the MSrepl_errors table stored in distribution database.

Can you check this link to see if it is applicable in your case.

Tom,

When I saw this question related to "normal forms", I knew it must be from you. Thanks for the question as we got to know some interesting...

I am not quite sure on this one.

Don't remove it. It is a requirement.

Any reason?

Good question, helped me to recollect some things I learned before.

I came across this link, can you just check if this is applicable to you. This refers to merge replication but I guess this is worth a look.

its running since quite a while and its still on step 2. Will this ever finish or suppose to finish or will this ever suppose to reach to step 3...

You can go to SQL ServeR Agent -> Jobs-> Job Activity monitor-> and sort the jobs by 'category'

you would find all your replication related jobs.

Hi Perry,

Very nice to see your article. I will definetly try this out. Thank you for sharing your knowledge on these topics.

Did you query sysservers to find out if 'Server_2005' exists srvname column

Nice to know setup is working fine :hehe:

Nice question to start the week. Apparently, this protocol would be removed in future versions.

First, go to SQL Server 2005 management studio and type

select @@servername

Then go to SQL Server 2000 Query Analyser and replace the above result in @server and @datasrc parameters for...

Hoping that you have done the right corrections to your script, it shouldn't cause any harm to your database.