Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.sp_MSenumthirdpartypublicationvendornames

  No additional text.


Syntax

create procedure sys.sp_MSenumthirdpartypublicationvendornames(
@within_db bit = 0
)

as
    set nocount on
    if @within_db = 0
    begin
        declare @dbname         sysname
        declare @retcode        int
        declare @distbit        int
        declare @proc            nvarchar(300)

        --init
        SELECT @distbit = 16

        -- Get publication list
        create table #pubdbs (publisher_db sysname collate database_default not null)

        insert into #pubdbs select name from master.dbo.sysdatabases where
            category & @distbit <> 0 and
            has_dbaccess(name) = 1

        create table #MSenumpublications
                (vendor_name sysname collate database_default not null)

        declare hCForEachDb CURSOR LOCAL FAST_FORWARD FOR select publisher_db from  #pubdbs
        FOR READ ONLY
        open hCForEachDb
        fetch hCForEachDb into @dbname
        /* Loop for each database */
        while (@@fetch_status >= 0)
        begin
            select @proc = quotename(@dbname) +
                '.sys.sp_MSenumthirdpartypublicationvendornames'
            insert into #MSenumpublications exec @retcode = @proc 1
            if @@ERROR <> 0 or @retcode <> 0
                return (1)
            fetch hCForEachDb into @dbname
        end /* while FETCH_SUCCESS */
    end
    else
    begin
        select distinct vendor_name from MSpublications where thirdparty_flag = 1 and
            vendor_name is not null and vendor_name <> ''
    end

    select distinct vendor_name from #MSenumpublications  order by vendor_name

    return (0)

 
Last revision 2008RTM
News

  Query a named instance
Sybase+ASE+silent+install
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
VMware
Zoekmachine optimalisatie
SQL Servers hidden objects
FckEditor
Flash in Ajax
De hype die AJAX heet
Barcode scannen
MySQL; Gratis, makkelijk en snel!
PHP
sIFR; de combinatie tussen HTML en Flash