> I created a procedure sp_test_file using exactly the same code as
> sp_helpfile, but strangely, when I run the following:

>     exec pubs..sp_test_file

> it shows me the master files information, whereas

>     exec pubs..sp_helpfile

> behaves as expected.

> Any hint as to what's going on?

> Thanks
> Jining Han
> Sallie Mae

> I assume you created your procedure in the master database?  If this is the
> case, you need to execute sp_MS_marksystemobject to indicate it is a system
> procedure.  This apparently changes the behavior of the object name
> resolution.

> This is an undocumented feature and may change in subsequent SQL versions or
> service packs  Use at your own risk.

> Hope this helps.

> -----------------------
> SQL FAQ links (courtesy  Neil Pike):

>  http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
>  (faqxxx.zip in lib 7)
>  or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
>  or www.sqlserverfaq.com
>  or www.mssqlserver.com/faq
> -----------------------

> > I created a procedure sp_test_file using exactly the same code as
> > sp_helpfile, but strangely, when I run the following:

> >     exec pubs..sp_test_file

> > it shows me the master files information, whereas

> >     exec pubs..sp_helpfile

> > behaves as expected.

> > Any hint as to what's going on?

> > Thanks
> > Jining Han
> > Sallie Mae