Virus string in Subscriber data -help
Fri, 29 Aug 2008 11:34:01 -0700
serverI got hit with an Injection attack. Cleanup is almost over except that
in a local publication I get this is the connection string:
Servername\Replication\Local Publications\[servername]:tempdb\[< script
src=http://www.bywd.ru/js.js> Everything from < script.. onward is part of
the Injected string.
...
|
Schema Only Snapshot
Fri, 29 Aug 2008 09:19:00 -0700
Is it possible to create a snapshot for merge replication that would apply
the changes necessary for replication without deleting the data in the
subscriber database?
The scenario is this - a client application has a database that will become
the subscriber. That database has existing data that needs to be ...
|
Failed to enumerate changes in the filtered articles
Thu, 28 Aug 2008 19:20:00 -0700
I have SQL Server 2000 build 8.00.908 and one of my Merge publications has
developed the error "failed to enumerate changes in the filtered articles".
Further details give the following msgs: "Incorrect syntax near the keyword
'where' and "incorrect syntax near the keyword 'and' ". The last command
field dis ...
|
2 databases merge at night
Wed, 27 Aug 2008 12:51:02 -0700
Is it possible with any version of SQL server to have 1 database in
headquarters and 1 db in a remote site and have them do a scheduled merge
everynight over the vpn connection. Both sites will access (read/write) thier
local db during the day?
Thanks for any help ...
|
Making single table snapshot using sql server 2005 enterprise
Wed, 27 Aug 2008 08:33:01 -0700
I have created a publisher and snapshot some of the tables, which are
published to a subscriber.
Now I would like to snapshot a single table for this publisher. I checked
the table and start the snapshot agent, but it starts to snapshot all the
tables taht were snapshot before. Is ther some way to do this w ...
|
Field size too large error
Wed, 27 Aug 2008 04:54:01 -0700
While applying the snapshot to the subscriber, I get an error saying
The process could not bulk copy into table '"dbo"."MSmerge_contents"'
and then
"Field size too large"
Can some one give an explanation about this error?
The publisher is SQL Server 2005 Std (SP2), the publication is partitioned
...
|
Error in replication
Tue, 26 Aug 2008 12:58:10 -0700
Hi,
We have a merge replication system in place. Remote users synchronize their
database. Suddenly one of the user is getting the following error:
Synchronizing your database to the Master database -- 8/26/2008 3:50:35 PM
Setting up to Sync non-PWO tables from Master to Laptop.
Copying selected data fro ...
|
|
|
Timing problem running sp_addsubscription programatically
Tue, 26 Aug 2008 08:30:04 -0700
We use a DBUpgrade program to maintain our database schemas. Part of this
process is to configure replication. On our test servers we often configure
the publisher, subscriber and distributor on the same physical server. When
doing so we are bumping into a timing issue with sp_addsubscription.
We call OD ...
|
Manage Subscription Files
Tue, 26 Aug 2008 06:13:01 -0700
Greetings,
I am new to replication and have not been able to find a topic on managing
the size of a publication. I have a snapshot setup of SQL 2005 and a
subscription which are working fine. The files in REPLDATA though will
continue to accumulate over time, filling available space. Other than
manuall ...
|
Maximum Retention period of the distributor DB (transactional replication)
does not work
Tue, 26 Aug 2008 14:54:27 +0200
Hi,
I tested the Maximum Retention period of the distributor DB but my test
failed and I would like to know why?
Here after the scenario that I performed:
I set up a transactional replication with a pull subscription.
I set Maximum Retention period of the distributor DB to 1hr (the default
is 96hrs).
I ru ...
|
