In BOL it says that you can use a UDF in a dynamic filter, passing in one of the system UDFs. However, when I try this I get a syntax error, e.g. SELECT * FROM [dbo].[SiteData] WHERE SiteId IN (SELECT Value FROM dbo.Split(HOST_NAME(), ',')) where dbo.Split is a UDF that splits a list of val...more >>

My customer asked me to evaluate if it will be better to work throught terminal server or connecting the remote computer with ODBC to the server or using terminal server, in order to get rid of all the problems that replication has. He is tire and sick of us saying that the replications stop...more >>

Hi, Anyone know how I can transfer my stored procedures from one sql server to another over the internet? I tried using the DTS, but kept getting an "Objects cannot be transferred" error. Thanks ...more >>

Hi All, Can I replicate from one sql server to another over the internet? Regards, Mekim...more >>

Error details: Replication failure. File 'p:\sql\ntdbms\srvrepl\src\replicat.cpp', line 1677. (Source: MSSQL2 (Data source); Error number: 18759) Have anybody solved this error? Best regards, Konstantin ...more >>

Hello there I have a created a puclision When i create the subcription it tells me that the subscription was succedded but it didn't faild creationg the agent. 5 - Access denied What can cause the problem and how can i deal with it? ...more >>

Hello I've tried to change sa password. I've changed logging mode of all subscribers ( for sa with new password, and even for some different account with System Administrator privs. ). Then I've created a Bidirectional Transactional Replication.: A -> B When I upload data to A it is ok - in fe...more >>

PROBLEM: I'm setting up merge replication on sql server 2000 sp3. While creating publication the following message was received: ------------------ Server: Msg 50000, Level 16, State 1, Procedure sp_MSreseed, Line 40 there is no identity column in this table Server: Msg 20009, Level 16, Stat...more >>

Hello every body. How can I find the tables or files where the replication log is stored. I mean, I would like to know how the replication worked during the weekend and what data insert, update or delete. Thanks a lot, Lina...more >>

I have a merge replication the last weekend, these fail and send me the message error "you would reinitialice the snapshot because the snapshot was obsolete", but whe I try rerun the snapshot, it send me another error like "i couldn't find the jobid @ x x x x x x x x x ". whatever I mad...more >>

I have two SQL servers and I am trying to create a new replication database. Both my servers are running 4 CPU's and have 4GB and 2GB of RAM. I am using the 2nd server as the distributor. I'm getting the error message "The process could not bulk copy out of table" when trying to create a snap...more >>

Hello, I am having a problem with fulltextindex. when i do replicate a table the full text index on the table in the destination server is repopulated. As the Table size is very big, i am looking for any way to skip the repopulation and update incremental. Please Help. Thanks and Regar...more >>

I have 5 offices that are running their own local copy of a database. Each office performs updates that need to be replicated with the other 4 offices. What kind of replication topology should I look for? At a first glance seems like implmenting a start with a 6th db acting as master could wor...more >>

I'm doing a test. I dropped a subscription on Subscriber-A I performed some transactions on Subscriber-A. I pushed a new subscription to it and indicated that it already had schema and data. I'm trying to get those new transactions to the publisher. I chose then to re-initialize the subsc...more >>

I know this has been covered a while ago but after spending two hours hunting round for the solution thought a repost might be useful to someone. Hilary Cotter's suggestion stop the merge agent and do a dbcc dbreindex Did the job a treat. To reindex all tables try something like this: ...more >>

An unusually large number of updates were processed against a database that we replicate. Normally, we see no issues with replication. However, we had several Log Reader Agent failures with the error message mentioned above. I updated the QueryTimeout parameter from 300 to 750 after finding...more >>

Hello all! I have just started to fiddle with replication and already getting some basic understanding how it all works, but I need some real-world examples and some good tutorials or books about this subject. What I've found so far is more for reference instead of good learning material. ...more >>

There is almost twice a much traffic coming back to my distributor from a wan subscriber then being pushed out. This is a push subscription so I would think that very very little information would be talking back to my sql distributor. Maybe just a few commands. What would be the reas...more >>

Hello Can a Subscriber of a Merge Replication be Publisher ( also Merge Replication ) of the same data base for another servers ? f.e. : A -> B -> C A - Publisher ( publication TestFromA of database testDB ), B - Subscriber of TestFromA and a publisher of publication TestFromB ( the same data...more >>

Hi, I am setting up replication between two computers and over the Internet (FTP). Question, and a bit stupid such, is that do I need to have other ports than FTP 21 open for the server (would seem bit weird if it would, but strill...)? I have tried the setup on LAN and I'm not sure if it w...more >>

We have 3 sites that are setup using Merge replication, continuous updating. It worked fine for months, but then 3 days ago, the 2 subscribers wouldn't get connected. We played with it for 2 days. Last night I completly shutdown replication, deleted the publications, and disabled the publishe...more >>

What is the best method to insure the replicated database cannot be = updated? For example; How can I insure my MS Access power users can't link tables = in the replicated db & update them?...more >>

Hi all, The command is as follows: BCP asdos+_reports..StageCONTACTINFO OUT C:\16E8.tmp -w -b10000 -t"|" -r\n -Sblrkec28791d\sqlserver -Uadmin -Padmin -eC:\ERRCONTACTINFO.txt Here, since the first argument(database name) has a special char '+' in it, the command gives a syntax erro...more >>

hi, I have a database that has Primary Key constraints on every table. Yet when I run the replication wizard and try to configure merge replication the wizard notifies me that it will create a rowguid on the tables even though they already have a primary key. anybody know how to avoid the rowgu...more >>

Hello alltogether, i'm working on a database-plattform which should work with fail-over-technics. Therefor 2 identic machines with internal RAID are available, which work in single-host-netloadbalance on win2003-server. Because of the internal RAID and caused by costs, a solution without ex...more >>

Hi NG, I'm looking for Useful Replication Alerts. I've found: error: 2601 Cannot insert duplicate key row in object with unique index. 2627 Violation of constraints. Cannot insert duplicate key in an object. 20598 The row was not found at the Subscriber when applying the replicated ...more >>

Hi, I have the following setup, SQL1 and SQL2 These server are windows 2003 and sql 2000 and both located in different offices connected by a 100MB WAN link. I have successfully created Transactional replication for failover....If SQL1 the publisher goes down, users will be redirected to S...more >>

We have built a system with merge replication through division. Now we need to change the schema. 1. one replicated table needs alter to add identity to a column of a composite primary key. 2. one column needs to be drooped from a composite primary key, and one column needs to be added in t...more >>

Hi All I am getting the following error from the snapshot agent, while first setting up transactional queued replication. "Line 1: Incorrect syntax near '000'. (Source: distribution (Data source); Error number: 170) " I have read the KB articles saying I should install SP3 and the problem w...more >>

Hi, I have a single subscriber using queued transacation replication that causes a conflict when I try to insert a record. Distributor is on the same box as the publisher. This is a SQL 2000 installation. Conflict policy is publisher wins, there are no F.Keys on the subscriber. There...more >>

We have merge replication including tables, sp's, and views. We change our view from time to time. We have so many sites, the views have to be updated at each site. I tried to replicate the view, it did not update the changes. If you have replicate view and update with merge replication, pl...more >>

Hi There, I wish to remove an article from the publication. I have already actiove subscribers connected to the article. What is the best way of deleting the article? Please suggest. Thanks Vivek ...more >>

All, I've been configuring Transactional replication in accordance with the 'High Availability' standards, and it seems the initial snapshots have been transferred but when looking at my distribution agent I can see this error: Last Command: {CALL sp_MSdel_Alliance UniChem Norge (RBO)$C...more >>

For anyone interested, I have a full pass to the SQL Connections conference in Las Vegas next week which I won in last year's drawing. I cannot go and so I am selling it for the best offer I get. Just reply to this post if you are interested. The full cost of this pass is $1395. Don't miss o...more >>

hello, I need to replicate data in several clients of SQL server. The replication I do it by means of a dynamic filter, according to suser_sname. The problem is that I need the client can change the user and replicate another data set, but only the created new data from last time that the same ...more >>

Hi, I am trying to restore a database from a different server to my server and also with a different name. But it gives me an error. ODBC-SQLState 42000 Device Activation Error. Does anyone know what this is ? Any help is appreciated. ...more >>

I have a customer with 30 stores replicating data to a central SQL Server and back out to all the other stores using MERGE replication. About once a 6 months or so, transactions from one store fail to replicate out for a period of a few hours or a day. This could be due to a network outage and ...more >>

Hi, Is it possiible to re-seed the identity column on a subscriber which is using merge replication. I am getting PK constraints when inserting a row. Thanks ...more >>

Hi NG. I'm looking for TSQL-commands and SPs to monitor MSSQL2k transactional replication without EPM. I found: Pub: MSrepl_transactions, MSrepl_commands Abo: MSreplication_subscriptions sp_xxxx_validation (check consistence) sp_browsereplcmds sp_replshowcmds sp_repltrans...more >>

When setting up the Create Publication, the wizard specifies a default path for the snapshot folder. And the note indicates that it must be a "network path". Yet it defaults to a windows administrative login path (part of the path is F$) and if you try to change this to an actual path (part of...more >>

Since deleting a lot of data from our server, we are having a problem with one of the (push) merge-replicated servers. Data was deleted from one table ("Scan" table) Table has ~ 60 million rows, we deleted in batches, a total of about 3 million rows. ...more >>

Tansactional immeidate updating subscription. Red X with Failed status but appears to be still running. Error Message: DELETE statement conflicted with TABLE REFERENCE constraint 'FK_tblEvents_1__14'. The conflict occurred in database 'TEGDB', table 'tblEvents'. Error Details: DELETE s...more >>

Hi, I have bidirectional replication configured between 3 servers. Server A as the distributor and publisher. 1. I have A publish to B and C. 2. A subcribes to B and C (push to A from B and C) 3. B publishes to and subscribes only to A. (push to A from B) 4. C publishes to and subscribes o...more >>

Hi, Would someone plase help with this issue of the identity ranges. I have run the sp Sp_adjustpublisheridentityrange on the problem table but it still does not fix it. The current identity is 75035 using the command DBCC CHECKIDENT ('LogEntries', NORESEED) The next starting range val...more >>

Within Properties of a Publication, on the "Subscription Options", I need to enable the option: "Use a Distribution Agent that is independent of other publications from this database" However, this option is "greyed-out" on the properties screen. How can I enable this option? -- Will G. ...more >>

Running Win 2k & SQL 2k. My snapshot agents are scheduled to run in the AM on Sundays. Every Monday when I check the replication monitor, there is an error on one if not more of the agents stating.. Error: The process could not create file 'd:\SQLData\MSSQL\ReplData\unc\SERVER_DataBase_Pu...more >>

I have snapshot files on CD , how can apply to subscriber offline , without connecting to publisher pl guide thorugh example or link thanks Fatiya...more >>