|
Bulk copy out of table error
I had to restore my msdb and distribution databases at my DRP site because
they went SUSPECT on me. I had scripts to create and delete the subscriptions
to three of my database. I ran the scripts and all but one is working. The
snapshot error message I receive is "The process could not bulk copy out of
tabl ...
Wed, 12 Jan 2005 15:29:01 -0800
|
push subscription: production environment
may I push a subscription to a server while that 'machine' is running the
application which is accessing the database?
...
Wed, 12 Jan 2005 14:30:23 -0800
|
Change merge filter
I like to change a filter of a article. I'm using sp_changemergefilter but I
need the name of the filter.
I have the names of the filters with sp_helpmergefilter but only give me the
join filters.
I like to know if sp_changemergefilter only works with join filters?
And how can I change a filter that is not j ...
Wed, 12 Jan 2005 16:09:48 -0600
|
Selectively drop the replicated database?
Hello,
I have two databases set up for transactional replication on a central
server. Two databases are replicated to the subscriber databases. I need to
rebuild one of these two databases. How to drop one database and leave
another alone?
I droped the publication for the database I am going to rebuild. Ho ...
Wed, 12 Jan 2005 16:09:14 -0500
|
Database Replication
I follow the considerations definied by document, but I have an error
when I insert data into a table, because it has an identity field, and
the replication return the following error:
An explicit value for the identity column in table 'SAR_Callejero' can
only be specified when a column list is used and IDENTIT ...
12 Jan 2005 11:02:27 -0800
|
Merge Filtering
I'm trying to get this filtering configuration stuff worked out so that I
can really understand it and it's been a little difficult finding a
complete example to go by. Let me illustrate my situation this way:
Tier1 <--> Tier2 <--> Tier3
So, we have data being created at Tier1 that is being replicated to ...
Wed, 12 Jan 2005 10:31:15 -0800
|
Snapshot Agent Error
I have defined an alternate snapshot location on a machine which is on a
different domain from my sql server. I have created a user on the remote
machine with administrative privileges and created the same user/pass for my
sql server machine.
I have created a shared folder on the remote machine and provided ...
Wed, 12 Jan 2005 08:27:06 -0800
|
Again: Merge error???
Sorry but it really urgen, any help is greatly appreciated
And 1 more question.
I met 28549 error. Can I find some way to find the conflict rows at
supscriptions or conflict rows at publications? Is there anyway to do it at
SQL server, where managing the replication database.
<-------------------------------- ...
Wed, 12 Jan 2005 07:11:02 -0800
|
Is a Domain Controller required for Merge Replication?
Hi,
I am writing an application that must run on two or more non-networked
computers. The MSDE 2000 database is merge replicated between the two
on a semi regular basis.
I have setup Win2k Pro in Vmware for testing and installed SQL Server
2000 SP3a. I cloned the Vmware virtual machine to create two copi ...
12 Jan 2005 04:56:06 -0800
|
Alter table impossible due to replication
Hi !
I can't alter a table because of an old problematical replication.
I've already tried to clean the replication informations with
sp_removedbreplication and sp_msunmarkreplinfo. I've already update
sysobjects to set replinfo to 0 for the table that I try to update. I've
also the database from the re ...
Tue, 11 Jan 2005 18:53:52 +0100
|
Transaction Replication From DB2 to SQL Server
Hi All
I want to do a transactional replication from DB2 to SQL Server.(snapshot
replication can also do)
I have looked and executed the heterogenous replications samples provided
my Microsoft. I am more of a VB/VB.net/C# programmer. and knowledge is
restricted on VC++. In the example mentioned it copi ...
Tue, 11 Jan 2005 12:25:59 -0500
|
Add a article to a Merge Replication
I have a Merge Replication with 48 subscriptions and I like add a new
article, but I don't like reinitialize all my subscriptions.
I try to use the sp_addarticle,
sp_addarticle [ @publication = ] 'NamePublication'
, [ @article = ] 'NameArticle'
, [ @source_table = ] 'source_table'
but when I ' ...
Tue, 11 Jan 2005 10:15:30 -0600
|
Log Shipping failover test
We currently have a working log shipping plan. As part of our annual DR
testing management wants to test the failover process. In reading the log
shipping white papers it appears that if we do this then basically the log
shipping plan will be lost and we will have to set up the plan again. How
does everyone ...
Tue, 11 Jan 2005 07:23:05 -0800
|
Schema update in case of replication.
Hello Paul,
I'd like to confirm the problem to be: you encountered problems of changing
schemas. You'd like to know if any utility is available to update the
schema in the case of merge replication.
Based on my research, SQL Server 2000 supports common schema changes to
an existing publication data ...
Tue, 11 Jan 2005 13:26:00 GMT
|
Schema update in case of replication.
Hi everybody.
I am using sql2000, and considering shifting to SQL2005.
I am facing lot of problem each time we need to change the schema of a
database.
Do you have any idea if any utility is available to update the schema of
databases in case of a merge replication
...
Mon, 10 Jan 2005 18:34:56 +0200
|