开发者

SQL Server 2000 Script to list all Meta Data Services DTS packages

开发者 https://www.devze.com 2023-01-20 17:16 出处:网络
I am doing an SSIS package that would go out to all our DB servers to gather information about them, and what is on them. And in this one case there is a SQL 2000 box with a bunch of DTS packages on t

I am doing an SSIS package that would go out to all our DB servers to gather information about them, and what is on them. And in this one case there is a SQL 2000 box with a bunch of DTS packages on there.

Now I can easily list the Local Packages using "exec sp_enu开发者_Python百科m_dtspackages", but this doesn't list the Meta Data Services Packages.

I cannot find anything obvious online or in the database to help me with this, not really even then attaching a profiler to it.

So I was hoping someone might be able to help me with a script. I am looking for the name, description, owner and the create_date.

Thanks in advance.


use msdb
go

select no.Name, si.Comments as Description, vai.CreateByUser as Owner, vai.VersionCreateTime as CreateDate
    from RTblNamedObj no
        inner join RtblSumInfo si
            on no.IntID = si.IntID
        inner join rtblVersionAdminInfo vai
            on no.IntID = vai.IntID
0

精彩评论

暂无评论...
验证码 换一张
取 消