satya, I can connect to the subscriber using query analyzer when using the SQL security, but not when using windows security, so I just want to...
so you are saying there is no way after initial push setup of the merge replication subscriber to change the connection from windows security to SQL...
Currently, the connection is using Windows Authentication, so it is administrator which does exist. But, since it isn't working (I can't connect from...
We have a customer that has 2 sights, both running SQL 2000 using merge replication. Everything was working fine until the subscriber had internet...
Where is that option?? Darin
We have a customer w/ merge replication setup and has been functioning. Their server's were hacked. We have spent 3 days on the phone w/ MS and...
Interesting request. Roji, your query will only work if all of the JOIN "tables" were actually tables and not other views. If he is doing a SELECT...
I have seen this error on one of our customer's machines. We upgraded to SP4 and it solved the issue. I seem to recall it had something to do with an...
Thanks a bunch. Darin
That is just irritating. I assume since create constraint isn't valid you are meaning to use the alter table and add a constraint. I'll be honest, I...
How come: ALTER TABLE ICHistory ALTER COLUMN ihst_amount decimal(18,7) NOT NULL DEFAULT(0) gives me an error: incorrect syntax near the keyword...
of course all of the additional talk and there is no clue from the original poster if his issue is fixed or not. Darin
There are a couple of options: 1. Stop the merge agent from the enterprise manager. This allows you to stop one or the other. 2. Stop the SQL Server...
Thanks for the info. Darin
Has anyone had any issues w/ having a SQL 2000 publisher & distributor replicate to a SQL 2005 server using continuous merge replication. I just want...
Separate names with a comma.