tia -comb...more >>

Hi! I have a schema that looks like this, on my main server: table Files: FileID (PK) FileName table FileProperties PropertyID FileID (FK Files.FileID) (PK) PropertyName (PK) PropertyValue table Hosts_Files HostName (PK) FileID (PK) Now what I want to achieve ...more >>

How can I see what the pending transacions are for a given server?? Is there an app that will show me this, or do I have to query a table? TIA, Larry.... ...more >>

I have a deadlock problems with my merge agents. Situation: - 1 Publisher, 3 Subscribers - All three merge agents are stopped (to simulate a network connection failure, so temporary no replication) - On each database a lot of items (for example 1200) are inserted in table X - Then all three ...more >>

thx Christian and Paul fro previous answers! I have a SQL2000 server that hosts our accounting database and I want to replicate it to another SQL2000 server so I can write reports etc, and do not want to use the production server for these tasks. I tried to setup a "snapshot" and was somewh...more >>

Good morning, I would like to use the sp_dropmergepullsubscription procedure to drop (and later cleanup) an anonymous pull subscription. My SQL Server (containing the subscription) is local, also IIS 5.0 and the ASP.NET application. I have added the ASPNET user to the db and gave him the ...more >>

Hi all... While setting up my merge replication through the replication wizard in I read that the use of HOST_NAME() in the dynamic filter returns the Subscriber's Machine Name. However the only thing that ever matches and causes replication of the data to fire is the Machine Name of the ...more >>

My Snapshot was successful but an error occurs when I try to run the distribution agent. Invalid object name 'PA_COLUMN_NAMES1_V'. (Source: ADMIN1SERVER\ADMINSQL (Data source); Error number: 208 ------------------------------------------------------------------------------------------------...more >>

Hello - I am using Merge replication, pushing subscriptions to clients, and SQL Server 2000. I need to change the field size in one of the tables that is in a publication. Basically, from nvarchar[4] to nvarchar[8]. Can I do this without having to drop/add all subscribers? I'm hoping ...more >>

We have set up a new SQL environment that has to replace our current SQL environment. On our current environment we apply a snapshot every night from our production database (the production database is hosted on another environment). This means every night approximately 15GB is being copied to...more >>

Is it possible to have 4 SQL instances in Cluster on 2 windows server. Active/passive set-up. In detail, what i mean is: I have 2 windows OS - WinClustA with WinClustB On WinClustA - SQLInstA (active) and SQLInstY (passive) On WinClustB - SQLInstB (passive) and SQLInstX (active) In case o...more >>

Silly question that came to mind as I was driving back from a poker game: What would happen if one publication sets an identity range at say, 100,000 and another publication (in the same database) has the identity range set for 50,000 on the same table? ...more >>

My replication system consists of a Publisher with Windows NT4 w/ SP6a and SQL Server 7 w/ SP3 and 35 subscribers, with the same windows and sql server versions, beeing synchronized by a schedule. When i am trying to synchronize a subscription manually my cpu is running up to 100%, blocks wer...more >>

Hi, I created a publisher for "transaction with updateable subscription". I created a subscriber for the publisher. (both the subscriber and publisher are running in the same machine. i'm using hierarchical topology) Now, when I update the subscriber, i get the following error. Msg 2107...more >>

So what happens when the Distribution Server blows a gasket? Somehow I get the feeling that restoring from last nights backup isn't going to get things back to normal? I ask because we are going to build a replication solution that will fall under Sarbanes Oxely issues, one of which is documen...more >>

Hi, I use dial-up connection to replicate data between to servers. Our replication type is Merge and I'm worried that what happens if the connection fails when merge agent is working. Will the synchronization be rolled back or I must necessarily use Transactional replication? Thanks in advance,...more >>

We have publisher and subscriber sitting in their own VLAN and domain accounts are restricted to login on both machines. We can only login locally to these machine. Is replication possible without using domain accounts in above situation. Thanks...more >>

i am working on a publication which has about 400 tables. i want to define dynamic filters, but i dont want to use EM. how can i add the filters on query analyzer? ...more >>

I've got a scenario where my bright but non-technical users may need to create their own publications on a daily basis. Essentially, they would just need to use a template and do transforms on 3 of the tables to narrow the WHERE query. Is this wise? Is there an alternative solution? ...more >>

Hi, I am dealing with merge replication. For identity columns EVEN seed value is set in Publisher database and ODD seed value is set in Subscriber database(increment value 2) to avoid insertion conflicts. For a particular table, usually the records are inserted from subscriber(through a...more >>

Hello, When I first started experimenting/testing Merge Replication about a year ago, I found that the default Merge Replication speed seemed to be a full minute. After doing some research, I tried creating a profile and changing the -PollingInterval parameter from 60 to 1. This got changes ...more >>

Is there a way to have just the posting into the Distribution database = portion of a snapshot resubmit after some process blocks the snapshot? This is the 3rd time the job is attempting to get the snapshot = completed. After 50 minutes of processing it became deadlocked & was = chosen as the...more >>

I have been trying to setup SQL Server Replication between two SQL Server 2000 SP3 servers. I have configured the Distributer and publisher on the same SQL Server. I modified the Publisher Snapshot folder to a non default ie. \\server\is\Replication\TLIS. Note \\server is a file serve...more >>

Hello, We are getting the replication data from some other database. Our replication method is push method. How to find out the frequency of the replication process per day? I have to find out this from the subscription database side. Regards, Sunil...more >>

I'm seeing some odd behavior: When applying an initial snaphot to a subscriber, I keep getting errors saying the log for the database is full and a rollback occurs. The weird tying is that I have the recovery model set to BULK LOGGED and I also created a job that dumps the transaction log ...more >>

Hi, I deleted all the jobs in SQL Server Agent. I tried to run the publication wizard. I got the following error. Please explain what i shd be doing in order to correct the error and to create the publication. TITLE: New Publication Wizard ---------------------------------------- SQL ...more >>

I have been pulling my hair out with this for some time now: I have a small db which I need to merge replicate with a number of PocketPC devices. NT Authentication is used. If I do not enable the automatic identity range option, the PocketPC clients can connect without error. However, if I...more >>

Hi, I have a problem with the merge replication. One of the tables is not updating at the subscriber side even if i make updates at the publisher side. My configuration is as follows: publisher: win2k sp3a subscriber: winXP Personal Edition Replicacion Type: merge (although changes on ...more >>

In a pull subscription is there a way to to set query time out for the merge agent prior to creating the pull subscription?...more >>

I have a production DB server that I want to mirror/replicate to a second server to be used as a fail over in case of a localized network outage. I'm in the beginning of the planning stages and have no experience in SQL replication. Where can I find some "Best Practices" for doing this? During r...more >>

I'm trying to troubleshoot a merge replication with a single pull subscription on a remote server. We have a merge agent that is staying in the retrying status. The intiial problem appears to be a query timeout, which we've changed. We can right click and see history and modify agent profi...more >>

Hi, We have been asked to develop an application for a auction company. (Real auctions, not on-line). They want the clerks to walk around with a tablet notepad P.C. and enter the sales information as the auction is progressing. I plan to write that in ACCESS. I am thinking of using MS SQL...more >>

I did a sp_dropsubscription followed by sp_addsubscription with sync_type='automatic' to resnapshot one article. I ran the snapshot and it said that nothing has been reinitialised. Do I also need to drop the article and recreate it ? ...more >>

SQL 2000 SP 3a (build 8.00.818) on Windows 2003 Is is necessary to have the xp_cmdshell operational when setting up Replication? I ask because our hosting company have built our SQL server with the xp_cmdshell renamed to close up a security hole. When I try to install replication on the SQL...more >>

How I can publish tables wihout primary key in transactiona Replication? ...more >>

We have a client on SQL Server 2000 sp2 whose merge replication had the following error: The merge process could not update the last received generation. Does anyone have an idea as to the possible causes? thanks ...more >>

I am trying to understand what the value of installing the distribution database on its own server. Performance is going to be an issue for clients accessing the subscribing databases and I want to minimize the impact of the replication process as much as possible. And by performance, I am no...more >>

Using transactional replication and all my transactions and commands are replicated to all my subscribers. There is nothing to be delivered from the msdistributionstatus view , but yet when i run the distribution cleanup, the commands and transactions are still in the msrepl_commands and trans ta...more >>

Hi everyone, Is it possible to have three publishers who also subscribe to publications from each other? All are pull subscriptions participating in merge replication. The physical design is represented by a triangle. My understanding of the suppported replication topology precludes such a desi...more >>

Hai, Can i find out the tables and columns which are not part of replication? is there any Built in SP for this? Thanks, V.Boomessh...more >>