where is the actual physical location of views, sp's and dts packages?

Views and stored procedures are stored in the database in which they
are created. The text definitions are stored in syscomments.
If you save DTS packages to SQL Server location, they are stored in
the msdb database in the sysdtspackages table.

-Sue

On Fri, 22 Oct 2004 07:01:09 -0700, mat
<mat (AT) discussions (DOT) microsoft.com> wrote: