Thanks in advance.

Robert

Check out sp_helptext in the BOL.

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional

www.pinnaclepublishing.com/sql

Are there any stored procedures similar to sp_help that
will give you information about views, like relationships,
source tables for each field, etc?  In addition are their
any stored procedures that will show you the contents of a
stored procedure.

Thanks in advance.

Robert

Thanks!!!  That was exactly what I was looking for.  I
glanced through the list of sp's in BOL yesterday, but
when I saw sp_helptext, I assumed it was about text
searches.  

BTW- Great article "Who's In Charge".  I never thought
about using an EXISTS as a JOIN condition.  I'm looking
forward to getting your book.

Thanks again,

Robert

Uh, thank you.  Thank you very much.  ;-)

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional

www.pinnaclepublishing.com/sql

Tom,

Thanks!!!  That was exactly what I was looking for.  I
glanced through the list of sp's in BOL yesterday, but
when I saw sp_helptext, I assumed it was about text
searches.  

BTW- Great article "Who's In Charge".  I never thought
about using an EXISTS as a JOIN condition.  I'm looking
forward to getting your book.

Thanks again,

Robert