|
|
|
April 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Merge Replication and Dynamic Filters Posted by smp9737 NO[at]SPAM gmail.com at 7/31/2007 5:06:02 PM Hi.
I am developing an Windows Mobile 5.0 Application for the MotoQ. It
uses merge replication and everything works fine. The DB has a
dynamic filter on it so that it only sends the data that matches the
SUSER_SNAME(). The problem arises when a user, other than the inital
user for the pro...more >>
Agents failed to load Posted by Ron at 7/31/2007 11:50:00 AM Using SQL2005 EE SP1
I'm trying to set up a simple transactional replication with initial
snapshot (1st time on this server). I create the publisher and it says it's
successful, however the error log shows:
Job cannot run because LogReader subsystem failed to load. Job has been
suspend...more >>
Database Mirroring Question Posted by acmcdba68 at 7/31/2007 11:08:03 AM I've read several instances that when implementing Database Mirroring, all
client connections are lost. A retry from client/s, applications, etc... will
reconnect to the Failover.
In order to compensate for the disconnect you should make use of TRY CATCH
logic within your code.
When goi...more >>
using Storage shered disk in replication Posted by Roy Goldhammer at 7/31/2007 1:55:47 AM Hello there
As part of sql failover clustering I add storage disk to hold sql server
database
1. Does the storage area can be in Raid 5 for better perfomance and
availability?
2. If I set two storange areas at the same network can i use replication to
transfare data from main Storage ar...more >>
Using transaction log for recovery Posted by Roy Goldhammer at 7/31/2007 12:00:00 AM Hello there
I have two servers: Publisher, Subscriber
Between them there is transactional replication
On both servers the recovery model is simple.
If the publisher goes down and the database has been corrupted. and I need
to recovery the last 3 hours of working. Can I use replication log ...more >>
transaction log performance Posted by Roy Goldhammer at 7/31/2007 12:00:00 AM Hello there
From some investigations i've made it seems that transaction log for
replication slowing performance.
But on simple recovery model the transaction log used for transactional
replication slowing performance less then recovery model full.
I'm wondering whay.
Does it because...more >>
Finding the transactions????? Posted by Jacx at 7/30/2007 10:42:09 PM Hi,
is there any procedure or query to find out the transactions which are not
yet replicated?
RegarDs,
Jacx...more >>
Is complete control over subscriber-to-publisher inserts/updates possible? Posted by Chris at 7/30/2007 8:18:26 PM Hi, we are using merge replication from our server (SQL Server 2005) to what
will soon be hundreds of subscribers. The subscribers are actually from a
Windows app that uses a SQLCE database. The client app is able to insert and
update records that are then merged up to the server. Everything I ha...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Publication does not exist. Posted by LPR-3rd at 7/30/2007 4:33:56 PM I have an error that states.....
DESCRIPTION: Replication-Replication Merge Subsystem: agent R99S-SQLA-
EDI-EDI Merge to 00-r00s-sqla-2 failed. Publication 'EDI Merge to 00'
does not exist.
Due to the fact that there are other consultants setting up/deleteing
replication & do not know how t...more >>
The inital snapshot for publication is not yet available Posted by sqlboy2000 at 7/30/2007 3:04:00 PM Hi,
We have a one way transactional replication setup between 2 servers and use
a remote distributor (push). All 3 boxes are SQL 2005, SP1. It runs fine for
months at a time then every so often replication will get blocked for one
reason or another. (typically a killed connection). If I then ...more >>
cannot delete publication Posted by Sandeep Shankar at 7/30/2007 2:26:44 PM We are using SQL Server 2005 Service Pack 2 on WIn2003.
We lost our distributor and I reinstall SQL Server in Distributor machine.
Now I am not able to delete publication and subscription from publisher and
subscriber.
Any help highly appreciated.
tried
sp_removedbreplication
Msg 37...more >>
Copying Permissions on SPs and Views in Merge Rep Posted by Ryan S at 7/30/2007 1:44:00 PM Hi,
I've come across another issue with my merge replication on SQL 2005 SP2.
Every time it recreates the SPs or views (due to snapshot, or changes) it
drops all of the custom persmissions to roles, or users.
I found a "Copy permission" on the tables, but can't find it for views or
pr...more >>
Replication Throughput Posted by Ryan Hanisco at 7/30/2007 9:28:03 AM Hi everyone,
We have a SQL replication that moves a large amount of data between our
administration site and a production eCommerce platform at our hosting
provider. The hardware at either end isn't especially taxed on either the
source cluster or the destination cluster and bandwidth shou...more >>
Configure Web syncronization using RMO or T-Sql Posted by prakash at 7/30/2007 7:01:58 AM Hi
I have created merge publication using RMO programming on Sql Server
2005 and it will subscribe by Sql Server Mobile Edition.
Publication created successfully and wok fine but I have to Configure
Web synchronization manually instead of RMO programming. (In short
Configuring IIS for web s...more >>
can not remove rowguid currently replicated Posted by mj at 7/30/2007 5:02:03 AM
After losing my publishing server, I re-built on a new server.
The databases had replication remnants so I ran cleanup scripts
(Replication system Objects, indexes and rowguids)
I then re-built replication
I find that I have a column (rowguid) left over that I can not remove.
The error ...more >>
insert/update/delete without replication Posted by Udit Ghai at 7/30/2007 1:15:22 AM Hi,
i have a peer to peer replication set up between 2 databases. There
was a parallel insert the databases are out of sync. i know the table
where the difference is. Is there any stored procedure with which i
can insert/update/delete without it being replicated?
...more >>
Replication 28039 / 28040 Errors Posted by SQLReplication at 7/29/2007 9:38:29 AM Hi all,
I've noticed lately that I'm getting a few 28039 & 28040 Errors. The
replication still seems to work though i.e. changes are synchronised.
Any idea what the cause of these errors may be?
Cheers.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |