I am curious to know if i script the replication scripts for creating publisher, publication,etc on 2000, can i safely run them on sql 2005 or are there some changes to the metadata ? Thanks ...more >>

Hi, I have replication between two instances of SQL2K. I have created the subscription with choosing option of "do not initialize schema and data...". Imagine I have Customers and Orders table in publisher and subscriber that CustomerID from orders references CustomerID in customers. Both publ...more >>

Hello there I create new transactional replication envirnment. If some server is being used as subsriber only as part of replication and no data is being changed there, Can i install minimal sql server on that server without many functionalitiys that normal server needs like: Locking, Agen...more >>

I recieved an error message, "The merge process could not retrieve column information for table 'dbo.TableName' -- sp_MSenumcolumns(?,?)" while doing merge replication using Sql 2000 and SqlCe. The database in question has 7 publications, 5 of which are working properly, and the other 2 spontane...more >>

I'm having trouble when trying to apply a snapshot to the subsciber. The distibution agent reports error "unexpected EOF found in BCP data file error" in addition it reports " duplicate key error". I have filtered the data being sent and choosen to delete the rows at the subscriber table tha...more >>

We have implemented SSL Encrytion on one of our SQL Server 2000 box to encrypt DTS Packages. I'm having a hard time trying to find anything about encryption during replication. I did find that you can configure encrytion in the Replication Merge Agent in SQL 2005. Does anyone know how to ...more >>

In a federated server, you create the same table on more than one server and use a view to link them all together. I have two questions: 1) Can modulo division be used to determine which server a row goes on? My reason is that modulo division will give the most even distribution of...more >>

Hi, I have problem with high CPU utilization using by replication. I found, that this command takes a lot of time (for example 21 seconds in my case) by using standard cluster index: ---------------------------------------------------------- select @max_xact_seqno = max(xact_seqno) from MS...more >>

Hi all, I got this error in my distribution agent today it was The process could not execute '{call sp_MSget_subscription_guid(25)}' Can anebody tell me what caused the error and also what does the procedure sp_MSget_subscription_guid actually do. How can i avoid such errors in future. ...more >>

I have 3 droped publication, but these still appear in replication monitor. How can I delete these information, cause any these publication exists at any publisher? Sds! -- Message posted via http://www.sqlmonster.com ...more >>

Hello there I have one server that recive data, and 1 or more servers who just presenting the data. From my knowlage there are two way to do that: 1. transactional replication, 2. Windows clustring. I'm wondering which one of them are better. ...more >>

I am working enhancements to a database that uses transactional replication to keep a disaster recovery version of the database updated in a separate office. This DR database is not actually used or updated but there for emergencies. The problem is not having had experience working with rep...more >>

Hi, i have the following problem: i have a publisher and a subscriber in the same sql server 2005 machine. All the process (the Log Reader Agent and the Snapshot Agent) works fine. Even the snapshot files are being created in the UNC path (\\Desa5el1\Paso), but when attempt to run synchroni...more >>

Hi, I have a replication environment with SQL Server 2005 SP2, where I work with 358 subscribers in a publisher called SQLDB3. They are distributed in four publications with diferent schedules between each others, the subscribers run every two minutes. When it starts delivering the comma...more >>

Hi, we have an SQL Server on Domain A that need to replicate to a client on Domain B. There is no trust between the two domains. What are the options we have to have a replication setup between the 2 SQL? Thanks in advance for any answer!!...more >>

hi all, I have this message error (subject) when snapshot finish and subscriber try to download for the first time all updates delete and insert .... my subscriber have populate all the table with data of snapshot, but when start download updates from publisher, give this error. I have only this me...more >>

Hi all, I've set up a merge replication using sql server 2005. All settings for "Copy Use Triggers" were set to false All Identity ranges were set to be handled automatically. There is a table - "Stock" - which has an ident field. An insert trigger on this table inserts a new record into ...more >>

Hello there I have system i need to upgrate. Here is the servers schema. 3-6 servers: 1. Publisher server in the replication 2. passive server which is failover cluster of the publisher 3-6. are subscrivers servers that use only to display data and not to update. the subscribers are part...more >>

I tried to use that on the Distribution database and even though is documented on BOL it does not exists ? ...more >>

I'm monitoring my transaction rep subscriber and see the biggest time hogs are sp_mscreate_sub_tables (1 minute) and sp_msdistribution_cleanup (4 minutes). I'm doing synchronization every minute. Are these times too high? Pub is SS2000, subscriber is SS2005. Is this too frequent of a syn...more >>

I have a large central server. I need to replicate the data to around 50 smaller sqlserver at various locations. The subscription is decided by a join between two tables and the where clause is a specific location_id. The larger table in central DB is around 200 million rows and the local DB i...more >>

I'm wondering if its reasonable to use clustering combined with table partitiions to distribute a heavy load? (OLTP app) My basic thought is that I want to distribute product data across many hard drives (and I/O busses) such that the database server knows which drives contain the data it n...more >>

We created a couple of subscriptions to our SQL 2005 merge publication. During the process we had some bizzare things happen. We created the subscription and tried to run it and it created a merge agent on the server and then failed. We tried to run it again and it created a new duplicate ...more >>

Hi, I have just resinstalled my server and restored the backup of my database. I am now trying to re-setup replication and I get the above error. The server configuiration: Win2k3 SQL Server 2000 SP4 Replication: Distributor & Publisher (intended Push Publisher) Snapshot S...more >>

I have a linked server called 'syb' created in MSSQL 2005. I am connecting to this linked server through the provider Sybase.ASEOLEDBProvider. I am able perform "SELECT" query using the four-part naming convention eg Select * from syb.mdb.dbo.tblUser However, i CANNOT EXECUTE ANY STORED ...more >>

Hello all, I am trying to set up a snapshot replication from SQL2000 SP4 Enterprise (publisher) to MSDE2000 (subscriber). It contains about 20 tables. Some of the table names contain blanks, which seems to cause problems. The snapshot works OK, but then the push keeps giving me "Wrong synt...more >>

Hi i have a server X with user A who has restricted access to Server Y. We want to set up a replication from Server X to Server Y. But when i set up the replication i get a table owned by the user A but i want to replicate to the table owned by me. How can this be done???? Thanks in advance...more >>

Hi, I am using mobile devices as subscribers and a desktop as a publisher. If i want to use dynamic filters, do I really have to use host_name? If the mobile devices have a web service method called ReturnId() that returns the unique id that identifies the mobile device and the id can be...more >>

Any help please? I have replication working between two SQL 2000 servers. When I examine the schema on the Subscriber - to my surprise - I find that all my primary keys appear to have been converted to 'clustered indexes' only. No primary keys. Is this normal? Is there a setting that I shou...more >>

Which query gives me the no of synchs in Merge replication? If a user is synchronizing 10 times I need the information of all the 10 synchs. I am using the following query, SELECT a.subscriber_db ,runstatus ,start_time ,end_time ,duration [Synch Duration] FROM db...more >>

We have a merge replication db that we have to drop a table index, add a different index and change the relationships in one table. Will the laptops pick up all of this or do I have to re-create the snapshot and also the subscription? Thanks. p.s. I assume I can't do this in EM? David ...more >>

I have an off-site server that received log shipments every 30 minutes. It's been working fine for years. However, the off-site server lost network connectivity for a few days. This was more time than was permitted by the out-of-sync threshold. Once the network connection was restored, t...more >>

Hi all, I have two servers A and B whcih act as a subscriber. due to some requirement i had to Rename Server A to B and Server B to A. Now when i execute the query Select @@Servername i get a different result then when i execute Select Serverproperty('Servername') can somebody tell me ho...more >>

I am getting deadlocks in my database but I am not seeing any error in the SQL log. how can be able to get info in the SQL log? Thanks ...more >>

My distribution Database is set to Simple mode , but the log file is filling up every few days. the error is as follow The log file for database 'Distribution_CCMSQL' is full. Back up the transaction log for the database to free up some log space.. what is going on how can I backup the trans...more >>

Hi, I'm trying to create a publication in a SQL Server 2005 server. I right clicked on Replication tab in management studio and selected 'New Publication'. The management studio waits for a long time and then nothing happens. It does not start any 'New Publication' wizard nor does it report a...more >>

Hello there I have huge database (approx 50Gb) of data which get 20 insert/update messages each second. On that database there are are 2 main softwars that use it: the import of the data and the software that present the data. there are 5 or 6 main departments that use the database at t...more >>