We are using Push subscription in our transactional replication setup in SQL
2K and I noticed that the SQLSERVERAGENT service is started by a local
account called replicationAgent.   Is it a problem for me to change it to a
different local account?  If it is ok to change it, do I ...

I used "select * from replicate_table_name" in my stored procedures and my
application.Now i want to replicate that tables.
Will it affect my application and Replication.
Please Advice me.

where can i find a goog tutorial for mssql server replication step by step ?
thanks for answers

We are testing with the CTP Sept. version of SQL 2005 in hopes of
moving to the released version of SQL 2005.  We have a table that has
an autoidentity range, with "Not For Replication" set to yes. (Is in a
merge-snapshot publication.)  In SQL 2000, you used to be able to

I am planning to do a snapshot regularly once a month to make sure that the
publshing database and subscriber database are always in sycn.   Our system
is 24x7 but night time and weekend are relatively quiet.  Is the correct
process for this is to do the 'Reinitialize All ...

I had a merge replication running between a publisher/distributer and 4
subscribers. Every thing was going well until I decided to reinitialize the
subscriptions, this was due to changing some stored proedures at the
publisher and I wanted them to be replicated to all other ...

We are setting up a test laptop to use with Merge replication to a SQL 2K
server that serves as both Publisher and Distributor.  I was hoping to
create a push subscription but that needs a register server setup that does
not work.  When I go to register the server (MSDE on ...

I have MERGE setup between SERVER A (Publisher)---- SERVER B (Subscriber).
in a table on SERVER A i am importing data from an excel sheet say 100
records. But these records are not reflecting on SERVER B even after merge
agent runs several time.

I read that we can optimise from 10 to 15 % the performance of a replication
by changing the default value of the HistoryVerboseLevel and the
OutputVerboseLevel of the Agent Profiles
For exemple for the Distribution Agent we have to use

How do I get rid of the red X's in Replication Manager?  They were there
when 1 synch with distributor failed, but then I fixed the problem and
synched again successfully but the red X's are still there.  Thanks.
David

We're planning on upgrading our SQL Server 2000 publisher to 2005.  It has
several MSDE pull subscriptions.  I am trying to get Northwind as a
Publisher to one MSDE subscriber but I've been having lots of difficulty.
I have created the publication and the pull subscription, but ...

I cannot get a pull subscription to work at all, push works, anyone have any suggestions as to why?  
I currently have 1 subscription pulling from this server, but I can't add any new pull subscriptions, I receive an error message:
From EM, on Choose Publication (Using Wizard) - ...

I created transaction replication with DTS transformation. Next I want to
move all data from publisher to subscriber - apply snapshot to subscriber.
Subscriber have different schema but no data. How it is possible to do? I
expected snapshot will use same DTS, but it not use it. ...

I meant to cross-post this over here, but not having much response in SQLCE
forum ...
I'm in the process of a 'forced' upgrade (my client bought newer PocketPCs).
Soooo .. what I would like to know is whether there are any issues

We are using transaction push replication and like to shut down the
subscriber server for some maintenance maybe 3~4 hours.   What is the best
way to shut down the replication or do I even need to worry about it?  
I am thinking about stopping the distribution agent or maybe ...