Home Microsoft SQL Server DigiMailing iRN Contact


  No additional text.

-- retrieve recgen information about all alternate publications known at this replica
create procedure sys.sp_MSgetalternaterecgens
        @repid uniqueidentifier

        declare @retcode                        int
        declare @publisher              sysname
        declare @publisher_db   sysname
        declare @publication    sysname

        ** do permission checking
        exec @retcode = sys.sp_MSrepl_PAL_rolecheck @repid = @repid
        if @retcode<>0 or @@ERROR<>0
            return (1)

        select @publisher= publisher, @publisher_db= publisher_db, @publication= name
                from dbo.sysmergepublications
                where pubid = @repid

    select distinct p.pubid as altpubid, s.recguid as recguid, s.recgen as recgen
    from dbo.sysmergesubscriptions s, dbo.sysmergepublications p, dbo.MSmerge_altsyncpartners alt
    where (p.pubid = alt.subid or p.pubid = alt.alternate_subid) and
          p.pubid <> @repid and
          upper(s.subscriber_server collate SQL_Latin1_General_CP1_CS_AS) = upper(p.publisher collate SQL_Latin1_General_CP1_CS_AS) and
          s.db_name = p.publisher_db and
                  s.pubid = @repid
         and s.recguid is not null and s.recgen is not null
        return @retcode

Last revision 2008RTM
See also

  sp_MSdrop_rlrecon (Procedure)


  Query a named instance
SQL 2008 R2
Deprecated procedures in SQL2008
Reporting Services item-level role definitions
Create all your missing indexes
Converting datetime field
Start MSSQL Server Profiler at time
Replicating MSSQL Server views
Exploring Microsoft Sharepoint
The OLE DB provider "SQLNCLI10" for linked server indicates.
Mobile solar charger
Oracle to SQL Server replication
Cannot insert the value NULL into column
Undocumented Microsoft SQL Server 2008
Zoekmachine optimalisatie
SQL Servers hidden objects
Flash in Ajax
De hype die AJAX heet
Barcode scannen
MySQL; Gratis, makkelijk en snel!
sIFR; de combinatie tussen HTML en Flash