hi , i am using transactional replication between two Sql server 2000 . my tables have identity columns as the primary keys with the identity property set to Yes( not for replication). Now when I am generating the replication intrinsic stored procs for the subscriber , I have a problem with th...more >>

Ever get this wonderful error? "Cannot alter the table 'XXXX' because it is being published for replication." Many of the posts I have seen regarding this subject suggest that you "trick" the server into thinking that the table is not being replicated by messing with the system tables. The...more >>

I have one corporate server that acts as both publisher and distributor. Remote locations all have SQL server loaded and act as subscribers. This setup has worked great until yesterday. Somehow, and it is still under investigation, the corporate server "lost" all subscriptions and became disco...more >>

Why are float values not replicated exactly? For example: 33.333333333333343 -> 33.333333333333336 233.33333333333331 -> 233.33333333333334 I saw a previous post about this, but I'm not satisfied with the answer "float is an imprecise data type". Note that I don't have this problem with...more >>

I am using transactional replication with queued updating. The publisher is located in Norway, with a single subscriber in the US. The Queue Reader Agent starts successfully, and transactions originating on either side are properly replicated. However, the Queue Reader agent eventually shut...more >>

Hi I've got a win2k and win2k3 server both running sql2k sp3. There are 5 transactional publications on one and corresponding pull subscriptions on the other. Replication appears to be working fine for all 5 but under 'subscriptions', 2 of them are red and their statuses are set to 'never sta...more >>

Hello: Is there a way to set up an alert to DBA (via email and such) when merge replication encounters conflicts (so DBA doesn't have to check it manually via Enterprise Manager)? Thank you. Chai W. ...more >>

I am trying to create a merge publication with a snapshot that includes all tables, views, procs, and UDFs using SQLDMO. I have no problems creating the publication with tables only. When I try to add procs using the following code I get the error The @schema_option parameter for a procedur...more >>

I am trying to replicate a database where the table owner is not [dbo] but [docsadm]. When I replicat the database to the subscriber all the tables are duplicated where one set of tables has [dbo] as owner and the another set of tables has [docsadm] as owner. I tried to set the flag 'keep the...more >>

I had a problem that required me to delete all my merge subscriptions. The end result was the articles in the publication that require identity ranges to be managed lost their information. The setup was never documented properly and I am re-initializing them blindly. Since the numbers for ea...more >>

Hi All, I have an SQL server 2000 as a distributor & Publisher, in other box SQL Server 2000 as a subscriber. Also I have one replication successful running and when I try to create a new Publication I got the same error for many tables. SQL could not initialize an article base on table 'tabl...more >>

I get this error when I Push New subscription and indicate NO, to initialize schema and data. the wizard dialog is: Initial Subscription, and I am choosing: No, subscriber already has schema and data ...more >>

Hi to all, i have a win2k machine with sql server 7 on it, that is beeing fed with data by another one, using replication. The other machine is an sql server 2k and is the Publisher of the replication The machine with sql server 7, needed a windows update and so i did it this morning. ...more >>

What does this error mean? Cannot load the dll xprepl.dll, or one of the dll's it references. Reason: 126(the specified module could not be found). ...more >>

Hello all, apologies if i've posted this in the wrong forum! I have 2 databases development and live. Development has the correct structure (SP's and tables) and live has the correct data. I would like to make live match the development database but not to loose any data. Is replication the...more >>

Hi Can anyone guide me, I have following doubts. I need to filter tables records to my subscribers dependign upon their area for which I want to implement Dynamic filtering, now problem is that some where I have read that for dynamic filtering I'll need to implement Dynamic snapshot I don't ...more >>

Hi all, How can I remove a list of subscriptions from the server? My server acts as PUBLISHER and SUBSCRIBER at the same time, but both features has been disabled. So, I can't delete the subscriptions list because I have no PUBLISHER and SUBSCRIBER now. I've tryied with differents com...more >>

I like to change a filter of a article. I'm using sp_changemergefilter but I need the name of the filter. I have the names of the filters with sp_helpmergefilter but only give me the join filters. I like to know if sp_changemergefilter only works with join filters? And how can I change a filt...more >>

Hello, I have two databases set up for transactional replication on a central server. Two databases are replicated to the subscriber databases. I need to rebuild one of these two databases. How to drop one database and leave another alone? I droped the publication for the database I am goin...more >>

I had to restore my msdb and distribution databases at my DRP site because they went SUSPECT on me. I had scripts to create and delete the subscriptions to three of my database. I ran the scripts and all but one is working. The snapshot error message I receive is "The process could not bulk co...more >>

We've been successfully installing a VS.Net application on about 40 clients so far and have run into one machine where our subscription agent jobs fail with the following error: "An execption occurred in the Distribution subsystem. The step failed" What does this error mean? Interestingly, ...more >>

may I push a subscription to a server while that 'machine' is running the application which is accessing the database? ...more >>

Rebuilding of subscription servers master database caused to lose subscription procs. Distribution is not able to distribute because it is looking for all those procs. How can I rebuild those procs? One thought was to look at different subscription and copy over all those objects to master ...more >>

I follow the considerations definied by document, but I have an error when I insert data into a table, because it has an identity field, and the replication return the following error: An explicit value for the identity column in table 'SAR_Callejero' can only be specified when a column list is ...more >>

I'm trying to get this filtering configuration stuff worked out so that I can really understand it and it's been a little difficult finding a complete example to go by. Let me illustrate my situation this way: Tier1 <--> Tier2 <--> Tier3 So, we have data being created at Tier1 that is bein...more >>

I have defined an alternate snapshot location on a machine which is on a different domain from my sql server. I have created a user on the remote machine with administrative privileges and created the same user/pass for my sql server machine. I have created a shared folder on the remote mach...more >>

Hi, I am writing an application that must run on two or more non-networked computers. The MSDE 2000 database is merge replicated between the two on a semi regular basis. I have setup Win2k Pro in Vmware for testing and installed SQL Server 2000 SP3a. I cloned the Vmware virtual machine to...more >>

Hi All We have a really strange situation with merge replication here at the office: The subscriber is SQL CE 2.0 Merge replication between SQL CE and SQL 2000 works a treat...until... 1)The publication is changed (recreated) and so the snapshot agent needs to run again. 2)The SQL CE devi...more >>

Hi ! I can't alter a table because of an old problematical replication. I've already tried to clean the replication informations with sp_removedbreplication and sp_msunmarkreplinfo. I've already update sysobjects to set replinfo to 0 for the table that I try to update. I've also the data...more >>

I am planning to use replication from 400 databases to the master database on a periodic basis. Do you see any issues with that ? All databases have the same structure...more >>

Hi All I want to do a transactional replication from DB2 to SQL Server.(snapshot replication can also do) I have looked and executed the heterogenous replications samples provided my Microsoft. I am more of a VB/VB.net/C# programmer. and knowledge is restricted on VC++. In the example m...more >>

Hello, I have an SQL2000 server, which acts as the distributor and as the publisher. The clients are Pocket PC's, using SQL Server CE. I have the latest SP for both. The replication is a merge replication, with a lot of join filters, more than 100 articles (only tables, no views or procedures...more >>

I have a Merge Replication with 48 subscriptions and I like add a new article, but I don't like reinitialize all my subscriptions. I try to use the sp_addarticle, sp_addarticle [ @publication = ] 'NamePublication' , [ @article = ] 'NameArticle' , [ @source_table = ] 'source_table' ...more >>

Please can some one help me with this problem I am having with the Log Reader Agent? Basically everytime I run the Log Reader Agent it just gets stuck and from the Replication Monitor it shows the status of the Log Reader as being 'Idle' and the last action as bine 'No replicated transacti...more >>

Guys, I hope you'll come out with a book and some materials on SQL 2005 as soon as the product is out and not years later . If you'll don't I will :) Get it out in time and launch it with the Inside SQL Server 2005 book . Do you guys not get special MS access that they can help you out like how t...more >>

Yesterday I posted my problem on the group I would like to explain it a bit so that I be able to make things more clear. 1. I have set up a Sql server as publisher/Distributor. 2. Setup MSDE as subscriber 3. Login mode to publisher/subscriber/Distributor is Sql Server Authentication a...more >>

Hi everybody. I am using sql2000, and considering shifting to SQL2005. I am facing lot of problem each time we need to change the schema of a database. Do you have any idea if any utility is available to update the schema of databases in case of a merge replication ...more >>

Hi guys Just a quick couple of questions regarding the best practice(s) for maintaining a database on two servers: The situation: I have a database on my server which I am constantly working on (modifying structure and content) and I have also placed a copy of the same database on my cli...more >>

I only have MSDE installed on Win2000 pro machines. Can I still set up the database replication, such as "transaction replication"? The SQL Server 2000 Standard edition can not run on Win2000 Pro, right? Thanks a lot, FL ...more >>

Hi, We are using merge replication, and the subscribers are pull subscribers. One subscriber crashed, before it could synch up (We need this data), but we were able to retrieve the entire mssql DATA folder. I created a new machine (Exactly like the crashed machine, same name, ipconfig, e...more >>

We have about 20 tables setup for replications . All std. setup . Replication is using stored procs created by SQL Server instead of the Statements. All tables are fine except one table stpped changing data at all. No errors etc. What should I do. Table has 2 coulms as PK . using SQL...more >>

Is this possible? Can I just use the client network config utility and change that to 1500? I am trying to do it right now, but just show the distribution agent as always "starting". It never gives any errors. I can telnet to the wan connection at the other end on 1500 so I know he is ...more >>

Hi, I have implemented a merge replicaiton between two of SQL Database servers. Now i came across an issue for wichi I need an expert advice. If I want to change schema of a published article, how can I propogate to subscriber without re-establishing the whole replication setup process. ...more >>

Hi, I have a pull merge replication configured on two of my servers. These servers replicate over the internet and use the sa password to connect to the publisher. I know it is not a good practice to use the sa login for replication purposes. But it has been configured this way. It would be...more >>

Error in replication Merge: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)} The process could not enumerate changes at the 'Subscriber'. (Source: Merge Replication Provider (Agent); Error number: -2147200999) Incorrect syntax near the keyword 'and'. (Source: SERVIDOR (Data source); Error number: 156) ...more >>

I have to create a replication for a database thar have 7 Gb. The time that consume is very important: almost 7 hs. Exist a procedure more efficient?? How can I generate a replication restoring a backup, instead of make an snapshop (like Informix). Thanks in advance ...more >>

Hello All, I am implementing Pull merge replication over internet, I have a sql server which I have set as Publishe/Distributor and MSDE which I have set a subscriber. I have a sample Database FTP_REPL which I have published. whenever I try to run merge Agent it succssfully connects to the publ...more >>

I have an existing trans repl set up and want to manually add 3 more tables and all its indexes and 2 sprocs to it .. How can I programatically do so ? Please provide an example.. Thanks ...more >>

[ Merge Replication ] I work with a software that the act deletion and creation of the table and deletion and creation and change of the field by the users happens so much. for deletion of the table using this command : sp_dropmergearticle @publication='DB_Doc', @ar...more >>

Hi, I have installed (attached) a new database. I need to change the length of a field using this command: ALTER TABLE CDRData ALTER COLUMN Locality varchar(10) NULL But I got this error: Server: Msg 4929, Level 16, State 1, Line 1 Cannot alter the table 'CDRData' because it is being publishe...more >>

Dear friends I am trying to setup a email notifcation at the event of failuer of Replication. so that i can take the corrective actions. But when i test the same It is giving me error: Microsoft SQL-DMO (ODBC SQLSTATE: 42000) Error 22022: SQLServerAgent Error: The SQLServerAgen...more >>