Script que envia um relatorio para o seu email com o status de sincronismo de sua replicação.
USE [master]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
----------------------------------------------------------------------------------------------------------------------
-- Stored Procedure Detalhe: Envia Status da replicação
----------------------------------------------------------------------------------------------------------------------
-- Data da criação: 02/08/2001
-- Criado: Wellington A. Vitoriano (DocTom\WellingtonSQL)
-- wellington_sql@hotmail.com
----------------------------------------------------------------------------------------------------------------------
-- Create Procedure
----------------------------------------------------------------------------------------------------------------------
CREATE PROCEDURE [dbo].[sp_EnviaStatusReplicação]
AS
DECLARE @xml NVARCHAR(MAX)
DECLARE @body NVARCHAR(MAX)
SET @xml = CAST((SELECT
[spid] AS 'td','',
[publisher] AS 'td','',
[publisher_db] AS 'td','',
[publication] AS 'td','',
[last_sync_summary] AS 'td'
FROM
[AcoWeb].[AcoCe].[dbo].[MSsubscription_agents]
FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX))
SET @body ='<html><body><H3>Replicação Status</H3>
<table border = 1>
<tr>
<th> Sessão </th><th> Publicador </th><th> BasePublicada </th><th> Publicação </th><th> Sincronismo </th></tr>'
SET @body = @body + @xml +'</table></body></html>'
----------------------------------------------------------------------------------------------------------------------
-- Envia E-Mail
----------------------------------------------------------------------------------------------------------------------
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'MAIL', -- replace with your SQL Database Mail Profile
@body = @body,
@body_format ='HTML',
@recipients = '<ContadeEmail>', -- replace with your email address
@subject = 'Replicação Status' ; 
Changing a replicated table in SQL 7 was a lot of work. SQL 2000 offers some help, but in many cases it's not enough. This article by Andy Warren shows you which changes SQL 2000 will help you with and which ones it won't.
2003-08-08
14,369 reads
In this product review Andy takes a look at Data Compare, the second of three products in the SQL Bundle available from Red-Gate software. It's a very handy program that lets you compare data between two tables and optionally generate sql statements to syncronize the data. An interesting alternative to replication!
2001-10-31
8,791 reads
This paper examines performance in transactional replication and demonstrates ways in which you can improve the performance of your applications. (30 printed pages)
2001-10-08
1,868 reads
Microsoft® SQL Server™ 2000 allows you to restore transactional replication databases without reinitializing subscriptions or disabling and reconfiguring publishing and distribution. You can set up replication to work with log shipping, enabling you to use a warm standby server without reconfiguring replication.
2001-08-21
2,176 reads
If you have Microsoft Windows 2000 or Microsoft Internet Explorer 5.0, Pull subscribers can use the Windows Synchronization Manager (WSM) to synchronize with the publisher.
2001-06-11
1,664 reads