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 >>