Hi, Is there anyway to provide weekly status report of the replication. Like -- 1. Which tables are replicated. 2. When replication is not possible with reason. Thanks in advance....more >>

Hai all, I need to do the following... declare @strwhere varchar(100) set @strwhere = ' and col2 = 6' -- where columnname is an integer datatype. select * from <tablename> where col1 = 'B' + @strwhere but the above query is not working when @strwhere takes a where condition for an inte...more >>

Hi, When a SQL Server Subscriber is running, is there any way to determine the total number of records that is being replicated? And also how many records are left before replication is completed? Thanks for your help Ben...more >>

Hi, I would like to ask if it is possible to modify stored procs that are being merge replicated. I figured out how to modify tables that are being merge replicated (sp_repladdcolumn... etc.) Is there an equivalent to that for stored procs? Thanks, Caine ...more >>

I have trnasactional replication one publisher and one susbcriber, i updated one table at publisher ( approximately 3200000 rows) and at susbcriber i don't see changes also after few minutes that update is finished i can't perform select on this table on subscriber - time out maybe it's ok...more >>

I have found that a table that is being merge-replicated to each branch office has a different INDENT_CURRENT value in each branch. Is this correct? Basically, I have a table called "Batch" in two database servers (one for each branch office). Let's call the database servers dbsOne, and dbsT...more >>

I am using merge replication. I would like to know how sp_addtabletocontents works? I think it works as below..... 1. msmerge_content and msmerge_tombstone are searched for rowguid's.... 2. For rowguid's which are theare in the above 2 system tables and not in the table in question, a ...more >>

I am using merge replication. I would like to know how sp_addtabletocontents works? I think it works as below..... 1. msmerge_content and msmerge_tombstone are searched for rowguid's.... 2. For rowguid's which are theare in the above 2 system tables and not in the table in question, a ...more >>

I am new to replication in SQL Server, and am investigating which option would be best for my solution. I have a SQL Server (Server) on our network, and another on in our DMZ. They have access to each other, and I need to replicate a database from the SQL Server (Server) on my network to the b...more >>

I have a publication created using SQLDMO on the server. ..PublicationAttributes = SQLDMO_PUBATTRIB_TYPE.SQLDMOPubAttrib_AllowPull + _ SQLDMO_PUBATTRIB_TYPE.SQLDMOPubAttrib_ImmediateSync + _ SQLDMO_PUBATTRIB_TYPE.SQLDMOPubAttrib_IndependentAgent + _ SQLDMO_PUBATTRIB_TYPE.SQLDMOPubAttrib...more >>

Hello. I need to schedule a job on a database that subscribes to a transactional publication on another server. Replication between these two servers goes down frequently. I've been told the job that runs at the subscriber needs to determine if replication is up and current at the time the jo...more >>

Hi In replication shedule properties i gave the option continuesly,i think what ever modifications we made same time it will replicate.with out setting any time period how can i do the replication manualy. -- Thanks...more >>

Hi, I tried to make a replication between two databases, a merge replication... But at the end, when the replication agents started, I found lots of errors that tells me that it don't knows who is the column 'rowguid'. This column was added only on the publisher. Can somebosy tell ...more >>

I have always assumed that I must completely disable replication to make any sort of change to published articles, but these article seem to say otherwise: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replimpl_22pf.asp http://msdn.microsoft.com/library/default.asp?u...more >>

I am trying to set up a test replication publication from my laptop and get the above message in the Specify Snapshot Folder box. I am guessing its because the machines name has dashes "-" in it? (bla-bla-bla) What can I do about this? TIA, ChrisR ...more >>

I am using transactional replication with queued updating between two servers running SQL Server 2000 SP3. Publisher and distributor run both on the same server (a cluster machine). There is one subscriber. The Queue Reader Agent starts successfully, and transactions originating on either side ar...more >>

Hello. While trying to publish any database that uses a collation different from server's default, I get this error in the step after selecting the articles to be published: --- Error 21423: You do not have sufficient privileges to view the publication information. Your administrator ma...more >>

Hi, As i know for preventing possibles errors there must be same sql server version with same service packs on distributor, subscribers and publishers, my question is what way to check it?? TNX -- Message posted via http://www.sqlmonster.com...more >>

We have salesmen with laptops and want to use merge replication that they will start via a synchronize button (I will use the ActiveX merge object). Each salesman should only have data for their own customers. Can the filtering be done at the subscriber during the pull subscription, or do I hav...more >>

Hi, I am looking at Snapshot Replication for an MIS system I have built. Server1 contains 3 databases and I want to replicate tables from these databases and publish them to a single MIS database on Server2. I would only have to run the snapshot once a day. All good so far. The only issue i...more >>

Hi, I read Paul Ibison's article about "Replication Across Non-Trusted Domains or Using the Internet". Me (and my company) need to take a very tough decision whether using SQL server 2005 merge replication or building our own synchronization engine. Our big problems are: 1. Everything h...more >>

We restored out database from a backup. we are using merge replication with ranged identity supor t on some tables. The restore screwed up the identities. I found an earlier post on how to fix this. Her's what I've done. I ran dbcc checkident(tablenaem) and it returns: Checking identity infor...more >>

Hi, I i have transational replication two sql servers 2000, one publisher and one susbscriber, distributor is on publisher server, everything worked fine but yesterday i got an error on ditributor: The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there ar...more >>

I am trying to better understand my replication options with MSDE. I am pretty sure that with merge replication the remote MSDE database will track the changes in a set of state tables. However with transactional replication I have read conflicting information as to whether it tracks change...more >>

I'm still fairly new to replication and was wondering what will happen when the value that's being used to filter rows to subscriber changes? For example (using merge replication), let's say the publisher is filtering records to subscribers based on a 'SalesPersonID' column. For whatever r...more >>

I need to delete about 3 million rows from a table that is part of a merge publication. I think that I will have to copy out the rows that I want to keep into a temp table and truncate the table and then copy the rows back in. My question is how best to go about this? I think that the best wa...more >>

I am the two stored procedures below, used in a similar way, to add a subscription. But for some reason, the replication completes but it does not stop. If I add a subscription using Enterprise manager (EM), the job does stop. I scripted out the subscription that EM had created and noticed tha...more >>

Hello, I have a merge replication setup between two sql 2000 servers. It works fine, but there is some data in one table that I wish to hide - at the subscriber database. That particular table is not needed, but if the someone at the subscriber logs into the database and selects from the t...more >>

I have 2 identical systems in my LAN. I want to set up merge replication = between these. I am bit confused among PULL or PUSH subscriptions. Gurus can you suggest me best option Regards Javed...more >>

Hi, i had a server that was a publisher/distributor. We decide to change the server name. When we want to execute the sp_dropserver and sp_addserver display some errors, so we decided to disable the the publisher/distributor option. When we did it, the distribution database wasn´t deleted. D...more >>

I've got once a day snapshot replication working between 2 servers. I take a copy of most of a database for MI and adhoc query processing purposes. This has been working okay for several months now but I've noticed that the time to load the database is gradually taking longer. I don't thin...more >>

I would like to set up one way replication from a production environment to a test server. Updates must be allowed on the test server but the must not be propagated back across to the live environment. Which replication type would be the most suitable? Is there a way to set the subscriber as upd...more >>

I have just discovered that subscribers in transactional replication with immediate or queued updating cannot update text columns. : "INSERT, UPDATE, and DELETE statements at the Publisher on text and image columns are supported with no special considerations. However, these columns cannot...more >>

Hello all, I apologize, If my question has been answered already here, but I wasn't able to find a solution for my problem. I configured transactional replication for a customer who needs a copy of a central database at another site. It's a very simple setup: 1 publisher and 1 subscriber. I...more >>

Is it possible to have more than one transactional replication publications which will be containing differenr list of tables and will be synchronizing at different times. If yes pls. tell me how ? Thanks in advance. ...more >>

Hi I am using msql2000.I have created a publication for replication.The replication is doing well.Now i want to add more tables in the existing publication.I have tried goint to publication properties .in article tab ,i can see unpulished artilcles but the checkbox is activated for adding ne...more >>

I have SQLDMO setup to create the initial subscription, merge articles, and snapshot. But, the snapshot uses the default parameters so it wants to run the snapshot agent everyday at like 11pm. I want the snapshot agent to run once a month (the first Sunday at 1am). I can't understand the Books O...more >>

We have an application that is working at many different customer sites great using Replication (merge with push subscriptions, no filtering). We are now developing an application for salespeople to run on their computer which will use replication once a day (or whenever they connect to the inte...more >>

Hi, I am using mergereplication for doing .1 miliion records /day. I find the replication is getting stuck because of a few deletes/updates. Is there a better way to handle this? ...more >>

Hello, I have SQL Server 2000 on window Server 2003, I have a laptop client with Win XP , I want to install MSDE 2000 on this client and keep weekly updated with Server. Is it possible , If yes, How ? or any other alternate. Any hint will be sincerly appreciated.. Harsha. ...more >>

Hello, I have an application with SQL data. I want to deploy this application with data. How can I ???? Harsha ...more >>

I have an application where I want to use merge replication to link up with Pocket pc's running sql sever ce. I have the queries written that will extract the data I want to replicate but can not figure out how to set it up in the replicate filters. Here is one of the queries. SELECT ...more >>

We are thinking of using Transactional Replication with Queued Updating. Our clients run XP Pro so can only support the Personnal Edition of SQL Server. I understand we can not use transactional replication from our clients, but can we perform the Queued Updating from these clients if they o...more >>

I need to distribute data from a central MSDE instance to never-connected remote MSDE instances. The data flow is strictly uni-directional, from central to remotes. No data will ever be replicated back to the central instance. The instances are NEVER connected (the remotes are laptops used i...more >>

Does anyone know if there is a reason why some uniqueidentifiers would be getting a number like {00000001-0001-0000-9090-C05BCE1ED94D} when using merge replication. Do these zeros mean anything? Its causing us problems because it is saying that the key already exists in one of the subscriber ...more >>