The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_enumdsn()MetaData:
create procedure sys.sp_enumdsn AS if 1 <> is_srvrolemember('sysadmin') begin raiserror(15247,-1,-1) return 1 end SET NOCOUNT ON DECLARE @distributor sysname DECLARE @distproc nvarchar (300) DECLARE @retcode int DECLARE @dsotype_odbc int DECLARE @dsotype_oledb int select @dsotype_odbc = 1 select @dsotype_oledb = 3 -- -- Get distribution server information for remote RPC -- subscription calls. -- EXEC @retcode = sys.sp_MSrepl_getdistributorinfo @rpcsrvname = @distributor OUTPUT IF @@error <> 0 OR @retcode <> 0 or @distributor is null BEGIN RAISERROR (14071, 16, -1) RETURN (1) END create table #datasourcestemptable (DataSourceName sysname collate database_default not null, Description nvarchar(255) collate database_default null, DataSourceType int null, ProviderName nvarchar(255) collate database_default null) -- -- Call xp_enumdsn -- SELECT @distproc = QUOTENAME(RTRIM(@distributor)) + '.master.sys.xp_enumdsn' insert into #datasourcestemptable(DataSourceName, Description) EXEC @retcode = @distproc IF @@error <> 0 BEGIN RAISERROR (14071, 16, -1) RETURN (1) END update #datasourcestemptable set DataSourceType = @dsotype_odbc where DataSourceType is null IF @@error <> 0 BEGIN RETURN (1) END -- -- Call sp_enumoledbdatasources -- SELECT @distproc = QUOTENAME(RTRIM(@distributor)) + '.master.sys.sp_enumoledbdatasources' insert into #datasourcestemptable(DataSourceName, Description, ProviderName) EXEC @retcode = @distproc IF @@error <> 0 BEGIN RAISERROR (14071, 16, -1) RETURN (1) END update #datasourcestemptable set DataSourceType = @dsotype_oledb where DataSourceType is null IF @@error <> 0 BEGIN RETURN (1) END select 'Data Source Name' = DataSourceName, Description, 'Type' = DataSourceType, 'Provider Name' = ProviderName from #datasourcestemptable order by 3, 1 drop table #datasourcestemptable return (0)
No comments:
Post a Comment