Hello,

I am looking for an object in a SQL 2000 db. I tried using
fn_listextendedproperty but having no luck. How do I look up say an object
called 'ABC' in a complete db

thanks in advance

Try:

sp_ 'ABC'

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"stoney" <stoney@discussions.microsoft.com> wrote in message
news:F22A7365-92B7-492F-B8DA-A19335179013@microsoft.com...
Hello,

I am looking for an object in a SQL 2000 db. I tried using
fn_listextendedproperty but having no luck. How do I look up say an object
called 'ABC' in a complete db

thanks in advance