Viewing 15 posts - 31 through 45 (of 1,097 total)
After you restart, SQL will start rolling back the transaction again.
January 31, 2005 at 1:01 pm
In the first subscriber the stored procedures for replication must me changed manually, because they will still have the original datatype.
In the second subscriber, the stored procedures already reflect...
January 19, 2005 at 6:39 am
You can use RedGate SQL Compare and SQL Compare Data tools.
Check in http://www.red-gate.com/sql/summary.htm
Also, for a quick data compare, you can use
SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*)) FROM production.db.dbo.CT_TAbleX
SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*)) FROM Development.db.dbo.CT_TAbleX
If the numbers...
January 18, 2005 at 6:33 am
Are you generating a snapshot to sincronize data? You can open the snapshot.cab file (with expand.exe) and open the .bcp file of the table, and check how many records are...
January 17, 2005 at 2:13 pm
You can change the replication stored procedures used to delete at the subscriber (ie: sp_MSdel_TableName) to ingore the delete. The transactions will be replicated to the subscribers but won't be...
January 17, 2005 at 2:06 pm
Replication is started with jobs.
If you have pull subscriptions, then you should start the jobs at the subscribers, if it is push, then the jobs are at the publisher (or...
January 17, 2005 at 6:28 am
Now try this:
CREATE PROCEDURE Test2
@ThisMachine varchar(10)
AS
DECLARE @qry AS nvarchar(200)
SELECT @qry = 'select * from ' + @ThisMachine+ '.master.dbo.sysdatabases'
EXEC sp_executeSQL @qry
GO
January 14, 2005 at 1:43 pm
Are the linked servers SQL Servers?
January 14, 2005 at 1:18 pm
Try:
@ThisMachine varchar(10)
AS
EXEC ('select * from ' + @ThisMachine+ '.Northwind.dbo.employees')
GO
January 14, 2005 at 5:37 am
Replication can replicate structural changes, but it is not the best. In transactional replication, addin new columns is easy, you just execute the sp_repladdcolumn sp, and replication will take care...
December 21, 2004 at 7:04 am
Run sp_helpArticle at the publisher and check what stored procedures are used at the subscriber to replicate data (ins_cmd, upd_cmd, del_cmd).
Then at the subscriber, run sp_helptext [sp_name] and search for...
December 21, 2004 at 6:57 am
Are you including the inserts to be replicated?
Run sp_HelpArticle and check the insert_command columns.
Check in bol for help with the sp.
December 2, 2004 at 8:30 am
You can replicate view and data (as if a table), if the view is indexed with a primary key.
Check Publishing Data and Database Objects in BOL for more info.
December 2, 2004 at 8:28 am
Run
SELECT QUOTENAME('This Example Company$The Problem Table')
and replace the value in the stored procedures use to replicate the data.
December 2, 2004 at 8:24 am
December 2, 2004 at 8:22 am
Viewing 15 posts - 31 through 45 (of 1,097 total)