|
|
|
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 Hide publications based on permissions? Posted by R Baker at 9/30/2003 5:15:25 PM 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 >>
Table_name length & replication - question Posted by Cornel Gligan-Ignatescu at 9/30/2003 3:20:06 PM 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 >>
Violation of Primary Key constraint '%.*ls'. Cannot insert duplicate key in obje Posted by Kenneth Delatorre at 9/30/2003 12:40:29 PM 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 >>
Applying initial snapshot using removable media Posted by Sri at 9/30/2003 11:16:56 AM 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 >>
Database not listed when creating new publication Posted by kevinb NO[at]SPAM smartpss.com at 9/30/2003 10:09:10 AM 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 >>
log shipping without primary keys Posted by Paul at 9/30/2003 9:45:09 AM
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 >>
Snapshot replication vs. Backup/Restore Posted by eric at 9/30/2003 9:30:20 AM 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 >>
Sp_adjustpublisheridentityrange Error Posted by Brian at 9/30/2003 6:38:13 AM 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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
replicating big database Posted by Boo at 9/29/2003 9:59:31 PM 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 >>
Adding Subscribers with @sync_type = N'none' Posted by Darin at 9/29/2003 5:37:06 PM 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 >>
Merge Or Transactional Posted by Bob at 9/29/2003 4:21:11 PM 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 >>
Replication MSDE Posted by Brad at 9/29/2003 1:19:27 PM 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 >>
Database changes for merge replication Posted by WB at 9/29/2003 10:45:19 AM 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 >>
Updating the database structure Posted by Zizo at 9/29/2003 9:11:27 AM 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 >>
Merge replication limits on blobs. Posted by Kiril at 9/29/2003 8:16:58 AM 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 >>
Transactional Replication Resilliance Question Posted by markalroberts NO[at]SPAM hotmail.com at 9/29/2003 2:35:59 AM 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 >>
|
| home · blog · groups | Questions? Comments? Contact the dn |