Cómo crear un instalador de SQL Server 2012 con CU1 integrado (Product Updates – Slipstream)
2012/05/14 2 Comments
How to create an SQL Server 2012 installer with integrated CU1 (Product Updates – Slipstream)
2012/05/14 3 Comments
Error al actualizar tabla con columna rowguid
2011/10/29 Leave a comment
Error updating table with rowguidcol
2011/10/29 Leave a comment
Quick way to create a SQL Server 2008 R2 installer with integrated SP1 (Slipstream)
2011/10/25 1 Comment
¿Cómo saber que tablas están replicadas?
2011/10/21 Leave a comment
--Que tablas están publicadas en Réplica de Mezcla y sus subscriptores SELECT b.name AS [Table], DB_NAME() AS PublisherDB, a.subscriber_server AS Subscriber, a.db_name AS SubscriberDB from sysmergesubscriptions a, sysmergearticles b where a.pubid=b.pubid order by a.subscriber_server --Que tablas están publicadas en Réplica Transaccional y sus subscriptores SELECT a.name AS [Table], is_published AS is_tran_published, DB_NAME() AS PublisherDB, c.srvname AS Subscriber, c.dest_db AS SubscriberDB FROM sys.tables a INNER JOIN dbo.sysarticles b ON a.object_id = b.objid INNER JOIN dbo.syssubscriptions c ON b.artid = c.artid WHERE is_published = 1
How to know which tables are replicated?
2011/10/21 Leave a comment
--Which tables are published for Merge Replication and his subscribers SELECT b.name AS [Table], DB_NAME() AS PublisherDB, a.subscriber_server AS Subscriber, a.db_name AS SubscriberDB from sysmergesubscriptions a, sysmergearticles b where a.pubid=b.pubid order by a.subscriber_server --Which tables are published for Transactional Replication and his subscribers SELECT a.name AS [Table], is_published AS is_tran_published, DB_NAME() AS PublisherDB, c.srvname AS Subscriber, c.dest_db AS SubscriberDB FROM sys.tables a INNER JOIN dbo.sysarticles b ON a.object_id = b.objid INNER JOIN dbo.syssubscriptions c ON b.artid = c.artid WHERE is_published = 1
Alesón Consultores
desarrolleMOSS
