hi, i have one server that's same publisher and distributor, i use transactional replication with updatable subcribers (four subscribers), all servers use SQL Server 2005 Standart. For two times i have the same situation. With no explanation the subscritions reinitialize, but more interest, ...more >>

OUr distribution agents keep shutting down due to ODBC timing-out. I think the batch size is too large (default) and that long-running queries block the stored procs. Any comments on how to minmize these time-outs? Thanks! Hiss!!...more >>

Hi to all. I am trying to start replication process and I got this message: ODBCBCP driver error. I look for version number and publisher and subscriber are different. What should I do to make both environments equal? Regards, José...more >>

Hi everyone, I have a server and several clients. I plan to make a mirror from server's database. Can you all please help me how to do it step by step? Thanks, Nassa ...more >>

Hi Everyone, I want to start database mirroring in SQL server 2005 -Microsoft SQL server management studio Express-,I use windows XP P2. I try to use database mirroring but it doesn't work.What should I do?Which Operating System, and SQL server should I use? Thanks, Nassa ...more >>

Hi, A member of my team recently made a few minor changes to our database. Several (not all) subscribers are now failing to replicate with the following error: The schema script 'exec sp_repldropcolumn '[dbo].[IP_Application_Updates]', 'update_id', 1' could not be propagated to the subscri...more >>

Hi: How do we confirm that execution of the stored proc is replicating and not the actual transactions. Actually we are doing massive update and delete in publishers using procs and we are also replicating the execution of the procs. Our replication environment is backed up. We want to m...more >>

I have the following scenario. I am merge replicating 2 servers over the Internet. The snapshot is downloaded by the subscriber from the publication via FTP over the Internet. The "schema scripts" are successfully downloaded and applied to the subscriber, but when it gets to the last (in alpha...more >>

I have a table partitioned in 2005 EE and also replicate it to other SQL Server databases. There is a filter on the replication, so not all the records are replicated. So, with the fewer number of records, I don't want to include the partitioning on the subscriber databases. Also, I'm not 100%...more >>

Dear All! can someone forward me any good links for replication for sql 2000 & 2005 Regards, Jami *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi, can you tell me please, is there a way to set "not for replication" flag on existing table field (ID) which is defined as identity and primary key, to N number of tables using sql script. e.g.: alter table tableForReplication alter column ... and so on. Thx. Vedran ...more >>

Hi everyone, I've got a major issue on a state production system that I need to resolve in 24 hours. I have two servers running with Merge Replication, and when editing web gui data, only one of them saves correctly (performs a valid INSERT). The other server gives the following exception any...more >>

During a test setup of replication on SQL2005, I received an error indicating that I had to connect to the server with the actual server name (and then it gave me the name). PRoblem is that the computer name actually changed after SQL2005 was installed so I am now connecting with the actual ...more >>

Hi I have a script that is run before the snapshot that disables a set with primary and foreign keys on the subscriber. This is to be able to delete some data before i reinsert new data. I also have a script that runs after the snapshot that restores these keys. But, if something goes wrong w...more >>

I am able to find the PublisherID in almost 10 tables in SQL 2000. Why am I not able to find the table that links the PublisherID to the PublisherName? For example, I can see that PublisherID 1 is making the XXXDatabase available for replication, but who the heck is PublisherID 1 (i.e. the...more >>

Group, I have a situation where I need to sync data over a VPN (T-1 connectivity) on a semi-realtime basis. This data is not highly dynamic, at most a few thousand rows change per day. I have SQL 2000 on one end and SQL 2005 on the other. Can 2000 and 2005 work together? What is the bes...more >>

A lot of our replication has TSQL scripts to create and drop publications,articles,subscriptions,etc. I want to know if they would work as is on 2005 or do we need to modify. Obviously I would test it, but wanted to hear from you prior to my undertaking. This is for transactional replica...more >>

How can I determin if a Trans publication is a Trans or a Trans w/updates?? Larry.... ...more >>

Just wanted to check. Running merge replication on SQL 2000. If I add a column to a table that is a published article, I assume I just run sp_repladdcolumn is that correct and is that all I need to do in order for the laptops to get the change with their next synch? Also, what do I set the...more >>

When creating a merge publication the process created a snapshot schedule of once a week. Isn't that excessive? Don't you only need a new snapshot when you have schema changes to the articles in the publication? It seems to me that you could just do this manually whenever you had design cha...more >>

I am having the common "distributor_admin does not exist" error when trying to set up a machine as its own distributor. (First time after setting up about 200 distributors). I get this whether I'm doing it remotely, or on the machine itself. The wrinkle is that the login "distributor_admin"...more >>

I am attempting to subscribe to a publication and I receive the following message.... SQL 2005 & Win 2005 on both ends. =================================== SQL Server could not create a subscription for Subscriber 'r99s-sqla'. (New Subscription Wizard) ===============================...more >>

Hi everyone, Can anyone tell me how I can create a mirror database? please give me the information step by step. Thanks, Nassa ...more >>