We find our end users can see every publication in the database even if they don't have access. Is there a way to limit the publications they can see? rb ...more >>

How many characters can contain a table_name for replication? I use MS-SQL Server 2000 SP3. Thank you in advance! Regards, Cornel Gligan-Ignatescu ...more >>

Where can I get the resolution for this problem: Violation of Primary Key constraint '%.*ls'. Cannot insert duplicate key in object '%.*ls'. This problem is fixed for SQL Server 2000 Service Pack 2 systems that are running version 8.00.0733. The problem also exists in SQL Server 2000 S...more >>

We have a situation wherein a large amount of data (4-5 GB) is applied during the initial snapshot(Merge replication). Some of our clients use dial-up connections, over phone lines. Needless to say, these connection are inherently unstable and passing such huge amounts of data across them is rea...more >>

Thanks in advance for the help! I've got SQL Server 2000 and goinf thrua nd getting replication setup and everything so far has been fine until I tried to create a new publication. I go thru the wizard and on the window where you select the database, my database that I want to replicate is not...more >>

Is it possible to implement log shipping of a database which contains some tables without primary keys? I think that replication requires primary keys on all tables, but I am unable to find any documentation on log shipping without primary keys. If it cannot be done, is there some type...more >>

I would like to set up a "warm" standby server as backup for a production server. Would it be better to use snapshot replication or a Backup/Restore solution. Transactional replication may be ruled out because the tables do not have primary keys (I did not design the db). It could be po...more >>

Hi I keep getting this error: Server: Msg 548, Level 16, State 2, Line 1 The identity range managed by replication is full and must be updated by a replication agent. The INSERT conflict occurred in database 'SecurePerfect ', table 'FacilityTable', column 'Id'. Sp_adjustpublisheridentit...more >>

Hi, I am using Transactional replication to replicate an archive db. unfortunately the database is very big and my bandwidth is very limited. Is there a way to backup the database and restore it at the second end then run the replication ??or detach it and attch it at the second end ?? I tr...more >>

Hello, Here's my question. I'm adding transactional replication and replicating 6 tables. But the servers that I'm replicating too have the same schema and data so I don't want the snapshot agent to run when adding the subscribers as it will fail with PK violations. So, easy enough, I ...more >>

Hi, I am looking for all the aspects of server overhead and system resources for my replication. Can any one tell me Merge or Transactional be good one for all the sql perspectives. Thanks In Advance. Bob....more >>

I want to create snapshot replication for offline databases using MSDE. The system will be set up with 5 branch databases updating a consolidated DB at HQ. At each branch data is inserted, updated and deleted and then weekly all the updates will be sent via snail mail to HQ (no communica...more >>

I am converting my Access 2k database to SQL 2k and also setting up merge replication. The upsizing of the database has completed successfully, and I have successfully setup and tested the Merge Replication. It is setup so that all the remote locations can update the Publisher and the publisher...more >>

We have a large website of around 100,000 users. The site is in english. We are trying to 1 more language to the site, ie: users can browse the website either in English or Arabic. So, in our development enviroment (Our local mirror of the database which we work on), we added extra fields ...more >>

Is there a known issue in merge replication of text, ntext, image data? For some reason, I'm hitting a limit of 32K. Not using replication, the data transefers (programmaticaly using TSQL, DTS, etc.) OK. TIA, Kiril...more >>

Hi We have a couple of sites across a WAN that need access to live data. There are a few access databases set up to link to this data at source - but the problem with access is that it pulls all the data across the line to process it locally. This is very slow for some of our further away sit...more >>

Hi Please help me URGENT How do i make an tableField with a Auto-Incr, the same like in an access DB where it's called AutoNumber Thanx in advance __________________________________________________________________ Flemming Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact m...more >>

I have the following situation: Clients connect to a SQL Server which is located elsewhere on a leased line. Now when this line fails no more reading or writing is possible anymore. To avoid this I thought it might be possible to put a SQL Server locally on the site and implement replication....more >>

MS Client this is the latest version of security update, the "September 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to maintain the security of your computer from these vulnerabil...more >>

Microsoft Customer this is the latest version of security update, the "September 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three new vulnerabilities. Install now to maintain th...more >>

MS Customer this is the latest version of security update, the "September 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to hel...more >>

Microsoft Partner this is the latest version of security update, the "September 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now ...more >>

Microsoft Consumer this is the latest version of security update, the "September 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to continue keeping your computer secure from these...more >>

Microsoft User this is the latest version of security update, the "September 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to ...more >>

SQL 2000 SP3 Transact replication/immediate updating subscribers. Is there a table that stores all of the Agent's activities. I'm interested in reading messages related to "timeouts". thx, Don ...more >>

We are running SQL Server 2000 and whenever we reboot a server that is replicating we have to go restart the agents. Is there a way to set SQL server to automatically restart all the agents on a reboot?...more >>

Any special actions I need to take for this? Do I need to set up the subscriber as if it's on the Internet even though it's on the LAN? I couldn't find a whole lot in BOL addressing this scenario, so any ideas are welcome. Breakdown - we provide a small portion of our data to a web applicatio...more >>

Note that the %DTable is the NAME of a table in our database. SQL Standard has no restrictions on using % in a Table name. And the table works fine in SQL Server 2000. However, attempting to publish the entire database receives the message SQL Server Enterprise Manager could not create artic...more >>

Good moorning ... I need to retrieve all the database owners in my server by database, and after that change the owner of all this databases to sa user. Thanks in advance for you help. Richard ...more >>

I am creating a transformation package from the Enterprise Manager for a Push Subscription. The publication has both vertical and horizontal filtering. The transformation includes a subset of columns and outputs to a different table name. When the transformation wizard ends, I receive t...more >>

Good afternoon ... Please I need help with merge replication trought code. I use the example code for VB and modified with my information. The problem is that I need to make this replication work in both ways, however looks like it is working only in one direction because all the data cha...more >>

All, SQL 2000 sp3, Server 2000 sp3 Transactional Replication. Push subscription I am replicating from one server to another using a third server as a distributor. I keep getting the error 'Could not find stored procedure 'sp_MSupd_Fact_wfsdNPClicks'. (Source: WILEY (Data source); Error...more >>

Hi All, I have following problem : I m to alter a column of a replicated database & the main thing that column is a primary key column (for e.g. varchar(12) to varchar(16) ). Generally v use sp_repladdcolumn & sp_repldropcolumn to add & drop columns in database. v don't have any option to ...more >>

we are using program which sometimes must be updated. some tables about this program are replicated to another server. these updates sometimes includes replicated tables and because of replicated tables update can not continue. I have to stop the replication for a while but there is no "stop" opt...more >>

Hi, We have two SQL 7 servers with replication running, index tuning has never been done on either servers. If index tuning is to be performed on our main server, will it have any impact on the data replication? Many Thanks Ken ...more >>

Hi, Who knows if there is a good book to setup a replication environment on a sql server 2000?...more >>

Is there anyone out there that understands this scenario? 1) Transactional Replication from Publisher/Distributor Server 'A' to Subscription Server 'B' (both runing SQL Svr 2K; Svc Pack 3) 2) The transactions run according to the Existing Stored Procedures that are executed by client...more >>

1) I have made a publication from SQL Server 7, Subscriber is in SQL Server 2000. Push a subscription does not work, error reported upgrade SQLDMO to SQLDMO2000 Shall Pull a subscription work from the SQL Server2000 if so how?...more >>

Hi, I have transactional replication set up between two servers (A=primary, B=secondary) for disaster recovery purposes. Server A goes down in flames so I need to "activate" server B. The database uses identity columns and timestamps which will have to be changed on B. What do I need...more >>

I have SQL 2000 SP3a. I can connect to the subscriber both through Enterprise Manager and the Query Manager using the sa Account. Within the past few days, I am getting a "can not connect because of a SQL Trusted Connection". I have been updating the Server whenever there are new NT 2000 Upda...more >>

Hi, I have a publication that uses transactional replication. If the subscriber becomes unreachable (for the 10 attempts used by the distribution agent), the distribution agent stops trying. It goes to the default of step 3 "Detect nonlogged agent shutdown". When the subscriber does eve...more >>

Hi Please can somebody give me a straight answer on whether or not it is possible to have an anonymous transactional pull subscription never expire? I have been refered to the MSDN article on this many times and it doesn't categorically state that its impossible to make them not expire. Howe...more >>

Hi! There are collecting snapshot agent's (SQL7.0) generated files in the separate directories (named like 20030923020007, 20030716020008, and so on) in my ReplData directory. Why does count of such directories increase without interruption? Can I delete directories with old date of modify...more >>

Hi, I have setup a merge replication using VPN over the internet. I was able to synchronize over the pass week during testing (on the production system itself).. but when the product when live, the merge replication started to fail. Events... 1) connect to internet, then VPN to s...more >>

Notes: Server --> W2K + SQL2K (Publisher and Distributor) Client --> W2K + MSDE 2KSP3a (Subscriptor) The connection is over Internet All of this is Windows Authentication with same user and password both SQLServer and SQLAgent. The suscription has created throught a backup of the server D...more >>

I have a transactional replication set up on SQL Server 7.0 The publisher and distributor are defined on the same server. When I try to run the Snapshot agent, it fails with the message "The process could not connect to distributor." Any help would be appreciated. -Nadia...more >>

I have a client that is looking to use log shipping to keep a mirror copy of the OLTP web database for reporting. However, they don't want to use Log Shipping if the database will be taken offline or become inaccessible while the OLTP Tran Log is being updated on the reporting server. ...more >>

I have added an article to an existing publication, and I now want to in query analyzer use sp_refreshsubscriptions. This is what I have been trying: exec sp_refreshsubscriptions @publication = N'Rep1' -I have also tried: exec sp_refreshsubscriptions @publication = 'Rep1' I keep g...more >>

Hello all, I am trying to update a merge publication which I have added a table to. I want to run the system stored procedure sp_refreshsubcriptions in query analyzer. exec sp_refreshsubscriptions @publication = 'Rep1' GO I get the following error: Server: Msg 20026, Level 11, Stat...more >>

Hi All I am trying for a multilevel Replication using merge replication . Can you please tell me the way of make a "global subscription" and "Republish" the same databse Thanks PrasanthB...more >>