In SQL2005, You can use an ALTER statement and that does not resnapshot. It will just alter the table in the other end. If you are using SQL 2000, you...

There is still hope:-)

Let us say that your Server is not in the domain, Create a local account for example "SQLService" and run the SQL Server and the agent...

It is much easier and safer using VPN connection. But I think it is possible to use FTP protocol to replicate between two cities. But I have never tried it...

Way out of my league. I think you should contact Microsoft Support.

Next time that guy writes an article, he will surely think twice, Maybe three times before posting it... All of you ripped him apart I guess... Poor guy...

Local domain?

Do you mean Local System? If so run the SQL Service and SQL Agent under domain account.

jcrawf02 (8/7/2009)

---

Paul White (8/7/2009)

---

You don't have to be psychic to help out around here - but it certainly helps.

Actually it's quite spooky how often people post questions about things that...

Edit : Read it wrong.

When you set up the SS replication, did you specify what interval you wanted the snapshot to restart?

That is why it is happening. Disable the snapshot...

You are in the wrong section of the forum to post replication issues. That too SQL 2000.

But from what I know about Transactional replication, you usually run Snapshot or...

Sreedevi,

Read this article.[/url] I think the user is trying to explain the fix for the same issue that you are having. But read carefully before you actually do something.

I have...

Hasib - MCP (8/6/2009)

---

Try deleting user account and then recreating it. Do this with SQL rather than via Enterprise Manger. The following sequence cured the problem on the server where...

What kind of replication are you talking about?

Also it would be better if you post replication questions under Replication section in this forum.

anish_ns (8/6/2009)

---

Mmm! I never had a filter on textData...only enabled it on Duration and DBID.

Actually, we haven't upgraded our build yet.....but, I did try the trace again after running DBCC...

Is your service running under domain user account or local system?

Cant you just take a back up and restore?