how to find which object belongs to which File group

Hi
We have a DB in which we have created two file groups. Both are currently
Primary file group. what is the best way to find out which objects are in
which file group?
Thanks,
This doesn't make sense. "Both are currently Primary file group." Only one
filegroup can be the primary filegroup.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Moh" <mabbas@.Pier1.com> wrote in message
news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
> Hi
> We have a DB in which we have created two file groups. Both are currently
> Primary file group. what is the best way to find out which objects are in
> which file group?
> Thanks,
>
|||I can mail you screen shot of EM where two files are listed as primary file
groups.
Moh
"Tom Moreau" wrote:

> This doesn't make sense. "Both are currently Primary file group." Only one
> filegroup can be the primary filegroup.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "Moh" <mabbas@.Pier1.com> wrote in message
> news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
>
>
|||That's not what you said. You said "we have created two file groups". Now,
you're saying you created two files. Which is it?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Moh" <mabbas@.Pier1.com> wrote in message
news:A0603CAB-EDF1-46BF-B449-D989432DF7DF@.microsoft.com...[vbcol=seagreen]
>I can mail you screen shot of EM where two files are listed as primary file
> groups.
> Moh
> "Tom Moreau" wrote:
|||By the way for your knowledge, you can have more than one files belongs to a
File group(Primary FG or any other). you can not have one file belongs to
more than one FG.
Does that mamke sense?
thx,
Moh
Sr DBA
Pier 1 Imports
mabbas@.Pier1.com
"Tom Moreau" wrote:

> This doesn't make sense. "Both are currently Primary file group." Only one
> filegroup can be the primary filegroup.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "Moh" <mabbas@.Pier1.com> wrote in message
> news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
>
>
|||I'm already aware of that. So, what exactly is the problem?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Moh" <mabbas@.Pier1.com> wrote in message
news:D6BCED88-53DB-4DA8-BC41-00E355065EF0@.microsoft.com...[vbcol=seagreen]
> By the way for your knowledge, you can have more than one files belongs to
> a
> File group(Primary FG or any other). you can not have one file belongs to
> more than one FG.
> Does that mamke sense?
> thx,
> Moh
> --
> Sr DBA
> Pier 1 Imports
> mabbas@.Pier1.com
>
> "Tom Moreau" wrote:
|||a filegroup is composed of one or more files
Objects are placed on filegroups and not files
If you wanted to know on which filegroup an object is placed, use sp_help
@.objectname
or the undocumented sp_objectfilegroup @.objid
If you wanted to know the list of all objects that belong to a filegroup
you can query sysindexes and group by the result by groupid
Med Bouchenafa
"Moh" <mabbas@.Pier1.com> a crit dans le message de news:
B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
> Hi
> We have a DB in which we have created two file groups. Both are currently
> Primary file group. what is the best way to find out which objects are in
> which file group?
> Thanks,
>
|||Dear M Abbas,
From your 3 posts in this Response, it is clear that you need to improve in
following areas:
1. English Language Skills: There are both grammatical as well as spelling
mistakes in your posts. Example of Grammatical Mistake: ‘Both are currently
Primary file group’. Example of Spelling Mistake: ‘….mamke sense’.
2. Behavioural Skills: Tom Moreau didn’t make any wrong statements. It is
you who made wrong statement in the 1st post by saying ‘…we have created two
file groups. Both are currently Primary file group’. Still, you have
expressed anger in your 3rd post.
3. SQL Server Skills.
Remember, that the first person to benefit from these improvements will be
you. So choice is yours.
"Moh" wrote:
[vbcol=seagreen]
> By the way for your knowledge, you can have more than one files belongs to a
> File group(Primary FG or any other). you can not have one file belongs to
> more than one FG.
> Does that mamke sense?
> thx,
> Moh
> --
> Sr DBA
> Pier 1 Imports
> mabbas@.Pier1.com
>
> "Tom Moreau" wrote:
sql

how to find which object belongs to which File group

Hi
We have a DB in which we have created two file groups. Both are currently
Primary file group. what is the best way to find out which objects are in
which file group?
Thanks,This doesn't make sense. "Both are currently Primary file group." Only one
filegroup can be the primary filegroup.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Moh" <mabbas@.Pier1.com> wrote in message
news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
> Hi
> We have a DB in which we have created two file groups. Both are currently
> Primary file group. what is the best way to find out which objects are in
> which file group?
> Thanks,
>|||I can mail you screen shot of EM where two files are listed as primary file
groups.
Moh
"Tom Moreau" wrote:

> This doesn't make sense. "Both are currently Primary file group." Only on
e
> filegroup can be the primary filegroup.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "Moh" <mabbas@.Pier1.com> wrote in message
> news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
>
>|||That's not what you said. You said "we have created two file groups". Now,
you're saying you created two files. Which is it?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Moh" <mabbas@.Pier1.com> wrote in message
news:A0603CAB-EDF1-46BF-B449-D989432DF7DF@.microsoft.com...[vbcol=seagreen]
>I can mail you screen shot of EM where two files are listed as primary file
> groups.
> Moh
> "Tom Moreau" wrote:
>|||By the way for your knowledge, you can have more than one files belongs to a
File group(Primary FG or any other). you can not have one file belongs to
more than one FG.
Does that mamke sense?
thx,
Moh
--
Sr DBA
Pier 1 Imports
mabbas@.Pier1.com
"Tom Moreau" wrote:

> This doesn't make sense. "Both are currently Primary file group." Only on
e
> filegroup can be the primary filegroup.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "Moh" <mabbas@.Pier1.com> wrote in message
> news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
>
>|||I'm already aware of that. So, what exactly is the problem?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Moh" <mabbas@.Pier1.com> wrote in message
news:D6BCED88-53DB-4DA8-BC41-00E355065EF0@.microsoft.com...[vbcol=seagreen]
> By the way for your knowledge, you can have more than one files belongs to
> a
> File group(Primary FG or any other). you can not have one file belongs to
> more than one FG.
> Does that mamke sense?
> thx,
> Moh
> --
> Sr DBA
> Pier 1 Imports
> mabbas@.Pier1.com
>
> "Tom Moreau" wrote:
>|||a filegroup is composed of one or more files
Objects are placed on filegroups and not files
If you wanted to know on which filegroup an object is placed, use sp_help
@.objectname
or the undocumented sp_objectfilegroup @.objid
If you wanted to know the list of all objects that belong to a filegroup
you can query sysindexes and group by the result by groupid
Med Bouchenafa
"Moh" <mabbas@.Pier1.com> a crit dans le message de news:
B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
> Hi
> We have a DB in which we have created two file groups. Both are currently
> Primary file group. what is the best way to find out which objects are in
> which file group?
> Thanks,
>|||Dear M Abbas,
From your 3 posts in this Response, it is clear that you need to improve in
following areas:
1. English Language Skills: There are both grammatical as well as spelling
mistakes in your posts. Example of Grammatical Mistake: ‘Both are currentl
y
Primary file group’. Example of Spelling Mistake: ‘….mamke sense’.
2. Behavioural Skills: Tom Moreau didn’t make any wrong statements. It is
you who made wrong statement in the 1st post by saying ‘…we have created
two
file groups. Both are currently Primary file group’. Still, you have
expressed anger in your 3rd post.
3. SQL Server Skills.
Remember, that the first person to benefit from these improvements will be
you. So choice is yours.
"Moh" wrote:
[vbcol=seagreen]
> By the way for your knowledge, you can have more than one files belongs to
a
> File group(Primary FG or any other). you can not have one file belongs to
> more than one FG.
> Does that mamke sense?
> thx,
> Moh
> --
> Sr DBA
> Pier 1 Imports
> mabbas@.Pier1.com
>
> "Tom Moreau" wrote:
>

how to find which object belongs to which File group

Hi
We have a DB in which we have created two file groups. Both are currently
Primary file group. what is the best way to find out which objects are in
which file group?
Thanks,This doesn't make sense. "Both are currently Primary file group." Only one
filegroup can be the primary filegroup.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Moh" <mabbas@.Pier1.com> wrote in message
news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
> Hi
> We have a DB in which we have created two file groups. Both are currently
> Primary file group. what is the best way to find out which objects are in
> which file group?
> Thanks,
>|||I can mail you screen shot of EM where two files are listed as primary file
groups.
Moh
"Tom Moreau" wrote:
> This doesn't make sense. "Both are currently Primary file group." Only one
> filegroup can be the primary filegroup.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "Moh" <mabbas@.Pier1.com> wrote in message
> news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
> > Hi
> > We have a DB in which we have created two file groups. Both are currently
> > Primary file group. what is the best way to find out which objects are in
> > which file group?
> >
> > Thanks,
> >
> >
>
>|||That's not what you said. You said "we have created two file groups". Now,
you're saying you created two files. Which is it?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Moh" <mabbas@.Pier1.com> wrote in message
news:A0603CAB-EDF1-46BF-B449-D989432DF7DF@.microsoft.com...
>I can mail you screen shot of EM where two files are listed as primary file
> groups.
> Moh
> "Tom Moreau" wrote:
>> This doesn't make sense. "Both are currently Primary file group." Only
>> one
>> filegroup can be the primary filegroup.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada tom@.cips.ca
>> www.pinpub.com
>> "Moh" <mabbas@.Pier1.com> wrote in message
>> news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
>> > Hi
>> > We have a DB in which we have created two file groups. Both are
>> > currently
>> > Primary file group. what is the best way to find out which objects are
>> > in
>> > which file group?
>> >
>> > Thanks,
>> >
>> >
>>|||By the way for your knowledge, you can have more than one files belongs to a
File group(Primary FG or any other). you can not have one file belongs to
more than one FG.
Does that mamke sense?
thx,
Moh
--
Sr DBA
Pier 1 Imports
mabbas@.Pier1.com
"Tom Moreau" wrote:
> This doesn't make sense. "Both are currently Primary file group." Only one
> filegroup can be the primary filegroup.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "Moh" <mabbas@.Pier1.com> wrote in message
> news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
> > Hi
> > We have a DB in which we have created two file groups. Both are currently
> > Primary file group. what is the best way to find out which objects are in
> > which file group?
> >
> > Thanks,
> >
> >
>
>|||I'm already aware of that. So, what exactly is the problem?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Moh" <mabbas@.Pier1.com> wrote in message
news:D6BCED88-53DB-4DA8-BC41-00E355065EF0@.microsoft.com...
> By the way for your knowledge, you can have more than one files belongs to
> a
> File group(Primary FG or any other). you can not have one file belongs to
> more than one FG.
> Does that mamke sense?
> thx,
> Moh
> --
> Sr DBA
> Pier 1 Imports
> mabbas@.Pier1.com
>
> "Tom Moreau" wrote:
>> This doesn't make sense. "Both are currently Primary file group." Only
>> one
>> filegroup can be the primary filegroup.
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada tom@.cips.ca
>> www.pinpub.com
>> "Moh" <mabbas@.Pier1.com> wrote in message
>> news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
>> > Hi
>> > We have a DB in which we have created two file groups. Both are
>> > currently
>> > Primary file group. what is the best way to find out which objects are
>> > in
>> > which file group?
>> >
>> > Thanks,
>> >
>> >
>>|||a filegroup is composed of one or more files
Objects are placed on filegroups and not files
If you wanted to know on which filegroup an object is placed, use sp_help
@.objectname
or the undocumented sp_objectfilegroup @.objid
If you wanted to know the list of all objects that belong to a filegroup
you can query sysindexes and group by the result by groupid
Med Bouchenafa
"Moh" <mabbas@.Pier1.com> a écrit dans le message de news:
B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
> Hi
> We have a DB in which we have created two file groups. Both are currently
> Primary file group. what is the best way to find out which objects are in
> which file group?
> Thanks,
>|||Dear M Abbas,
From your 3 posts in this Response, it is clear that you need to improve in
following areas:
1. English Language Skills: There are both grammatical as well as spelling
mistakes in your posts. Example of Grammatical Mistake: â'Both are currently
Primary file groupâ'. Example of Spelling Mistake: â'â?¦.mamke senseâ'.
2. Behavioural Skills: Tom Moreau didnâ't make any wrong statements. It is
you who made wrong statement in the 1st post by saying â'â?¦we have created two
file groups. Both are currently Primary file groupâ'. Still, you have
expressed anger in your 3rd post.
3. SQL Server Skills.
Remember, that the first person to benefit from these improvements will be
you. So choice is yours.
"Moh" wrote:
> By the way for your knowledge, you can have more than one files belongs to a
> File group(Primary FG or any other). you can not have one file belongs to
> more than one FG.
> Does that mamke sense?
> thx,
> Moh
> --
> Sr DBA
> Pier 1 Imports
> mabbas@.Pier1.com
>
> "Tom Moreau" wrote:
> > This doesn't make sense. "Both are currently Primary file group." Only one
> > filegroup can be the primary filegroup.
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada tom@.cips.ca
> > www.pinpub.com
> >
> > "Moh" <mabbas@.Pier1.com> wrote in message
> > news:B93809BB-695B-4EED-9CE0-B3154B7D8301@.microsoft.com...
> > > Hi
> > > We have a DB in which we have created two file groups. Both are currently
> > > Primary file group. what is the best way to find out which objects are in
> > > which file group?
> > >
> > > Thanks,

How to find the dependency object of a particular table

Hi all,

I m using SQL Server 2000. I want to know the Dependencies of a particular table in my database. I want to know the details inorder to delete the records which are not referenced from other related tables.

(e.g) Customer, CustomerTax, Invoice tables are there. CustomerID is primary key in Customer table. CustomerID is Foreign keys in CustomerTax and Invoice tables.

When i create new customer i enter customer tax also. So both Customer and Customertax details are stored in the tables. Once i created the customer details it not yet reference in invoice table i can deactivate(later i can again activate the customer) the customer, because it is not refered in Invoice table(eventhough it is refered in CustomerTax table). In my view Customer and CustomerTax are very close association with them.(Without client the client tax not exists).

So whenever i want to deactivate a particular customer i have to check which tables that customer ID is refereneced. If it is referenced any other tables except CustomerTax table then i will intimate the user that customer ID is already referenced by other tables(other than CustomerTax).

For this purpose i want to check the dependencies of the table and decide to deactivate the customer record or not. How can i achieve this in SQL Server 2000?

I am in urgent need for this problem. Can anyone please suggest for this problem? If so i am very greatfull for you.

Thanks in advance
cssjm

use the sysforeignkeys table itll give u the fkid, ok table and fk table...

have a look at this..will help u...

http://blogs.msdn.com/sqltips/archive/2005/07/05/435882.aspx

How to find out which field in a table is updated

When someone modifies a field in a table, I like to find out which
field he/she changed.
Currently, only the LAST person to modify an object is saved. For
example, if I modify an Application record, I will see "MyName" in the
"tblApplications.UpdatedBy" field and the date and time I updated it.
But it doesn't keep an historical record. We would like these changes
to be stored in a file or a table or something.
Please helpThen implement triggers to log to an audit table the changes to a data table

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"lphuong" <lphuong@.neh.gov> wrote in message
news:b6a732a8.0404300532.30de1e3c@.posting.google.c om...
> When someone modifies a field in a table, I like to find out which
> field he/she changed.
> Currently, only the LAST person to modify an object is saved. For
> example, if I modify an Application record, I will see "MyName" in the
> "tblApplications.UpdatedBy" field and the date and time I updated it.
> But it doesn't keep an historical record. We would like these changes
> to be stored in a file or a table or something.
> Please help|||Allan, would you please show me how to do it in SQL Enterprise or in
VB6. I'm a novice in this subject.
Thank you.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||OK

--So say you have a table

CREATE TABLE MyRealTable(ColPK int identity(1,1) Primary Key, col1 int)

--You now emulate that table with an audit version

CREATE TABLE Audit_MyRealTable(ColPK int, col1 int)

--You now need an auditing trigger for INSERT, UPDATE, DELETE. I prefer 1
trigger per action.

--Here is the update trigger

CREATE TRIGGER tr_u_MyRealTable ON MyRealTable FOR UPDATE
AS
INSERT Audit_MyRealTable(ColPK, col1)
SELECT ColPK, col1 FROM UPDATED
GO

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"L Phuong" <lphuong@.neh.gov> wrote in message
news:4092936d$0$202$75868355@.news.frii.net...
> Allan, would you please show me how to do it in SQL Enterprise or in
> VB6. I'm a novice in this subject.
> Thank you.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

how to find invalid objects --After DDL changes

Hi

I have a SQL Server 2005 database running. When I run some ddl changes, I want to find all the procs/objects that get invalidated because of object not found error.....

Is there any way that I can look up in sysdepends or other tables to find information about this.

Regards

Imtiaz

You can query the system view sys.syscomments for any procedures or functions that reference the objects. The text of each is stored in sys.syscomments.text.

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,
HernnHi
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/SQLSe...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
> | > --=20
> | > atte,
> | > Hern=E1n
> | >
> | >
> | >|||yes, that is !
atte,
Hernn
"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/SQLSe...=1244
98
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
> | >
> | >
> | >

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
> | >
> | >
> | >

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
> | >
> | >
> | >