Can SQL's service run as a local admin if it's replicating? Or does it need to run as a domain admin? SQL 2000 thanks, Don ...more >>

We had a two-site system go badly wrong as a result of something. The net result of this was that the publisher had to be completely reformatted and reinstalled. The server has, as a result of this, been given a different name (went from being a named instance to not being one). Currently the ...more >>

I'm trying to find a central website/group that lists what is possible with regards to replication depneding on your OS. For example, is transactional replication supported on XP Pro and SQL Server Standard Edition? I have a scenario where a machine has XP PRo and SQL Developer's Edition. If ...more >>

What is the syntax for the snapshop location setup referring to the "Client path to this folder from the FTP root"? When my pull connects, it doesn't seem to issue any change directory commands and does not find the snapshot files which are there. ...more >>

Hi all, One of the subscribers I am managing is displaying a message saying that the pull subscription has expired although the publication properties on the publisher is showing that the publication never expires. Is there a way to "reactivate" the expired subscription without re-initializing i...more >>

I'm running snapshot replication, and there will often be new tables (and other objects) added to the publisher that I'd like to automatically include in the subscription. Any ideas on how to do this? I've thought about creating a script that lists all the tables, etc., in a publisher, and the...more >>

Hi, I have a transactional replication between 2 SQL servers 2000 that are linked via a T-1 connection. I know that my VPN is not too great; almost everyday I have to reboot the VPN to have a connection to the remote location to the SQL server. Until I can resolve the Network problem; I would ...more >>

Hi People, I need some help. I am using SQL Server 2000 and have created a publication using Merge Replication. One of the tables are filtered as follows: SELECT <published_columns> FROM [dbo].[tblFingerPrint] WHERE recordid in (select fingerprintid from tblKeyHolder) The reason I d...more >>

hi guys, Publication is in pending status. I don't know what is the problem.. = I am using DOMAIN account(administrator). Publisher and subscriber are = on same machine. =20 Error I got in my event viewer. SQL Server Scheduled Job 'Replication agents checkup' = (0xF2F0DE84FCFB1B46A0094...more >>

Question: I have posted several times to this newsgroup - going back at least six months. I needed to refer back to one of those posts. But when I do a search on my name, the results only show four posts?!? I know thi isn't right because I've done the exact same search and received a LOT...more >>

I have been trying to get replication working for a month now with no luck. I have tried all of the suggestions to fix 'ERROR 18456' and none have worked. Most of the suggestions talk about enabling mixed mode authentication. The server has always been in mixed mode and I can login to query ...more >>

Hi everyone! I have a problem with my replication. I've done merge replication, I have one publisher and one subscriber. The connection between servers is via ADSL. The merge replication does fine, when there is an active connection. But when the connection (ADSL) drops, my merge agent stops...more >>

Hi After doubling the query timeout in Replication -agent profile, i am getting error message 'The process could not perform retention based meta-data clean up in database 'Databasename' in one of the databases quite often ( i have 50 databases all of them are being Merge replicated) I ...more >>

My Scenario: I have two database for Merging Replicate: "db_AAA" (publisher) and "db_BBB" (subscriber). Both "db_AAA" and "db_BBB" contain a "tbl_KKK" table. "tbl_KKK" are the same structure in both "db_AAA" and "db_BBB" but not the same records number. So, when I update a record in "db_AAA" t...more >>

Hi Freinds, SQL 2000 I have a publication with more than 800 articles and so often I get a structure update for publisher database.Sometime we have new table too. I am using transactional and merger replications to push the data to 2 subscribers. What is the best way to update the subsc...more >>

Publisher has delete stmt executed against transactionally replicated table. 270K rows deleted in 1 stmt. 1 Subscriber connected with T1 How best to replicate all the 270K simpleton delete calls to sp_MSdel_tablename at subscriber through distr agent? What parameter adjustments to make...more >>

I have a nightly routine that deletes 270K rows from a replicated table via transactional replication. My distr agent is using the built-in Verbose profile, -CommitBatchSize set to 100 Subscriber is connected via T1 line in building across street, I stopped my distr agent after 100K rows ...more >>

Quick question – I have 2 SQL 2000 SP3 boxes. Server A is the distributor Server B is the Subscriber. If I make a change on server B why do those changes not replicate to server A What am I missing ...more >>

After replication done, both source database and subscription database have a extra column--rowguid. SQL server did not clean them up. Should I clean then one table by one table manually or there is a was to clean them up. Thanks ...more >>

If using of Double-Take or similar type of software, for SQL Server databases replication advisable? I am most concern about the software interfering into the I\O path and the possibility of data corruption and performance degradation on the source server. ...more >>

Hi All, I am a new learner of SQL2000. Recently I learned to setup log shipping. I have Primary Server (A) and 1st Secondary Server (B) at my head office. I also have 2nd Secondary (C) at a remote site. Server A log ship logs to server B and C. Server C is my monitor server also. One of the lo...more >>

My requirement i want to create publisher in access 2000 and subscribe the data from sql server by using pull replication Thanks in advance for any reply...more >>

I've created a merge publication with automatic range management. Insert fails because the ranges assigned have already been used. How do I specify that I want the new identity ranges to start above those which have already been used? I created this publication by backing up my production d...more >>

I'm testing SQL 2005's Mirroring capabilities. I need to implement a high-availability solution to the 1-server problem, but without a cluster server ($$$$). So SQL Mirroring is the key. SERVER_A (main) and SERVER_B (backup) holds replicated data. SERVER_C is the "Synchonize server" (I think ...more >>

I am using transactional replication running on SQL Server 2000, sp4 (OS is Win2K server). Replication had been running fine for several days when the following Log Reader error was logged: The specified begin LSN (001d8547:00007da4:0001) for replication log scan occurs before replbeginlsn...more >>

Environment: SQL Server 2000 with SP3a on sqlpubserver and sqlsubserver. Error Example One: The process could not deliver update(s) at the 'Publisher'. (Source: Merge Replication Provider (Agent); Error number: -2147200989) ---------------------------------------------------------------------...more >>

Hi guys, I have a question, not sure if it's do-able. I have a transaction replication setup on Server A (Publisher) and Server B is my Subscriber) I have over 100 tables in this publication. I want to change order of columns to just one table in Publisher. is there a way that I ...more >>

In case of any problem with transaction replication....Is disabling Log Reader and Distributor Agent jobs good enough to disable replication or do we need to drop the publications..?? Ravi...more >>

Trying to detach a DB from the publisher/distributer via EM from another PC on the network. The detach box has the message: ATTENTION: The database cannot be detached while it is being replicated. And the OK button is disabled. I took this as you cannot detach during replication. But it i...more >>

Hi, Is there any better means of replicating table indexes, triggers, and constraints than simply reinitializing the article everytime their definitions change or a new one is added? This is in Microsoft SQL Server 2000 SP3. -- Many thanks, Oskar ...more >>

Hi, group!! Sorry if off-topic, I need to backup / read / access locked files on almost every windows flavor. How can I do this? Thanks! Eduardo....more >>

We have replication setup concurrently. In this scenario does the transactions will get commited only after replication? What happens if the replication fails due to one of these errors a) Invalid subscription b) Waiting for a connection The reason for this question, quite often when we g...more >>

Hi , In order to mimic the time out error in our application, I have doubled the query time out in agent profile from 5 minutes to 10 minutes. But, now I am getting the below error messages frequently, 1. The process is running and waiting for a response from one of the backend c...more >>

I am trying to set up bi directional tran. replication. I have been able to successfully configure replication from machine A to machine B but I am not able to configure the other way round. 1st process -- created the distributor on machine A, made machine A the publisher and Machine B the s...more >>

How can I set QueryTimeOut for snapshot Agency? According BOL I can write some code using VB or I can set withCommand promt. It take time. Can I do it with SQL Server Enterprise Manager? I tried modify the default Agency Profile for snatshot. the Enterprise Manager does not allow me to E...more >>

Hi, We have two servers, one in North America, one in Europe, that are connected by a firewall VPN. The firewalls have built-in encryption processors, so the VPN encryption doesn't cause a speed issue. We are running SQL 2000 SP3 on Windows 2003 Server. We are currently hosting about 2...more >>

We would like to complete the setup of a new SQL Server in our Data Center. However, we need to establish a new subscriber for a 13GB database. After reading various Internet sites and searching these forums, I cannot find the answer for the following questions: 1) What does the "Snapshot...more >>

We've been using Replication for over two years now. And we have views, tables and Jobs that have been automatically created in our database. Some are almost two years old. How do I know what I can delete, remove, discard without effecting the replicating? Thanks, Matthew Mark...more >>

I am currently investigating issues with the Transaction Log size for a customer's database. Only the database's data is currently backed up - the database is not mission critical, and the customer has no need to frequently backup the TLOG. The database is a publisher for transactional repl...more >>

Hi to all! i m tryiing to establish replication between two servers but when i start to configure replication it gives me a message "SQL Server agent" on "Computer Name" currently using system account,which causes replication between servers to fail" . which account i should use to config...more >>

Hi , I have to delete large amount of data from a table that is one of many articles in Transaction publication. I want to dropt the specific article , delete the data and than add the article again (initial the specific article only) In order to save transfer the heavily transac...more >>

hi guys Can I change the row filter without disable the whole republication in sql 2000? ...more >>