BOL = Books On Line

You have to be on Master also you should have rights to do it as well.

I dont see anything wrong with the script. The script is what is shown in BOL as well.

Is CHECK_EXPIRATION and CHECK_POLICY set to ON for this user? MUST_CHANGE should...

Is this a SQL User or windows user?

Your publisher is 2005...Right? You cannot set it higher than 90 that you have.... I am not sure why you are not able to replicate from 2005 to 2008. There...

It depends on your business needs. How critical is your data? If it is critical, I would say set up a DR Plan. If you have a good DR plan...

Can you please let us know what compatibility level you have set for your publisher and subscriber?

Hi Suresh,

It is always better to start this question as a new thread. Then it will be noticed better and you could get answer more quickly. It does not matter...

GilaMonster (6/26/2009)

---

Grant Fritchey (6/26/2009)

---

And if things get REALLY bad, we'll just toss Gail into the middle of them. Although, that might be considered a cruel thing to do to a...

You dont have to worry about a thing... We are the best mannered professionals here. If...

Truncate is not allowed on a table that is being replicated. It will just error out

It is very difficult to give an answer on this without knowing the structure of the tables, Indexes that are present and query.

But if you just take the face...

This is usually a network error. This could be caused by packet drops or badly configured Firewall/Switch. Please check if you have remote logins enabled. You can check it using...

Glad I could help..:-)

Yes, please do so... There should not be any replication jobs on the distributor when you set it up once again

Congrats Flo.... 😀

You get to host the Party...:-)