SQL Server :- msdb.dbo.sp_enum_dtspackages

Background

SQL Server has many functions for reviewing metadata.

msdb.dbo.sp_enum_dtspackages

Introduction

The msdb.dbo.sp_enum_dtspackages is one of those functions.

Breaking down the name sp_enum_packages, this is what we get:

  1. sp ( Stored Procedure )
  2. enum ( Enumerate )
  3. dtspackages ( DTS Packages )

It is easy to tell that we can likely use this function to enumerate packages.

SQL

Syntax


msdb.dbo.sp_enum_dtspackages

Output

 

Undocumented

The msdb.dbo.sp_enum_dtspackages only works on these versions of SQL Server:

  1. v2005
  2. v2008
  3. v2008-R2

Summary

The whole point of doing this post is to draw attention to the risks of using undocumented functions.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s