how to find an object ?!

hi
i forget completely
how to find an object in sql 2005 ?
don't remember where is that function !!?
where is it ?!!
thanks
atte,
Hernn
Hi
USE AdventureWorks
GO
SELECT * FROM sys.objects
"bajopalabra" <bajopalabra@.hotmail.com> wrote in message
news:%23yZNlqn$GHA.1556@.TK2MSFTNGP03.phx.gbl...
> hi
> i forget completely
> how to find an object in sql 2005 ?
> don't remember where is that function !!?
> where is it ?!!
> thanks
> --
> atte,
> Hernn
>
|||You can query catalog view sys.all_objects
Linchi
"bajopalabra" wrote:

> hi
> i forget completely
> how to find an object in sql 2005 ?
> don't remember where is that function !!?
> where is it ?!!
> thanks
> --
> atte,
> Hernán
>
>
|||is not there an "object finder" ?
mhhh... where i seen it, then ... sql 2000 has one ?
atte,
Hernn
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> escribi en el mensaje
news:FE167E6A-B5C3-4C9C-AAEE-DD8A6AF1C39B@.microsoft.com...
| You can query catalog view sys.all_objects
|
| Linchi
|
| "bajopalabra" wrote:
|
| > hi
| > i forget completely
| > how to find an object in sql 2005 ?
| > don't remember where is that function !!?
| > where is it ?!!
| > thanks
| > --
| > atte,
| > Hernn
| >
| >
| >
|||In Management Studio, you can find an object using the "Filter"
feature. This option is available when you right click an object type
(one of Tables / Views / Stored Procedures).
In Query Analyzer there was another feature, called "Object Search"
(F4). This feature is not present in Management Studio. See:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124498
Razvan
bajopalabra wrote:
> is not there an "object finder" ?
> mhhh... where i seen it, then ... sql 2000 has one ?
> --
> atte,
> Hernn
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> escribi en el mensaje
> news:FE167E6A-B5C3-4C9C-AAEE-DD8A6AF1C39B@.microsoft.com...
> | You can query catalog view sys.all_objects
> |
> | Linchi
> |
> | "bajopalabra" wrote:
> |
> | > hi
> | > i forget completely
> | > how to find an object in sql 2005 ?
> | > don't remember where is that function !!?
> | > where is it ?!!
> | > thanks
> | > --
> | > atte,
> | > Hernn
> | >
> | >
> | >
|||yes, that is !
atte,
Hernn
"Razvan Socol" <rsocol@.gmail.com> escribi en el mensaje
news:1162480405.660966.290330@.e3g2000cwe.googlegro ups.com...
In Management Studio, you can find an object using the "Filter"
feature. This option is available when you right click an object type
(one of Tables / Views / Stored Procedures).
In Query Analyzer there was another feature, called "Object Search"
(F4). This feature is not present in Management Studio. See:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124498
Razvan
bajopalabra wrote:
> is not there an "object finder" ?
> mhhh... where i seen it, then ... sql 2000 has one ?
> --
> atte,
> Hernn
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> escribi en el
mensaje
> news:FE167E6A-B5C3-4C9C-AAEE-DD8A6AF1C39B@.microsoft.com...
> | You can query catalog view sys.all_objects
> |
> | Linchi
> |
> | "bajopalabra" wrote:
> |
> | > hi
> | > i forget completely
> | > how to find an object in sql 2005 ?
> | > don't remember where is that function !!?
> | > where is it ?!!
> | > thanks
> | > --
> | > atte,
> | > Hernn
> | >
> | >
> | >