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,
HernánHi
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,
> Hernán
>|||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,
Hernán
"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,
| > Hernán
| >
| >
| >|||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?Feedback=ID=3D124498
Razvan
bajopalabra wrote:
> is not there an "object finder" ?
> mhhh... where i seen it, then ... sql 2000 has one ?
> --
> atte,
> Hern=E1n
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> escribi=F3 en el men=saje
> 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,
> | > Hern=E1n
> | >
> | >
> | >|||yes, that is !
--
atte,
Hernán
"Razvan Socol" <rsocol@.gmail.com> escribió en el mensaje
news:1162480405.660966.290330@.e3g2000cwe.googlegroups.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,
> Hernán
> "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,
> | > Hernán
> | >
> | >
> | >