You may what to know a lot of "stuff" about your database! In that
case, try the statement below! Hehe.
use pubs
exec sp_helpdb
Have a great Day!
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Vanessa van Gelder
[mailto:mssqldba-ezmlmshield-x56622542.[Email address protected]
Sent: Tuesday, July 31, 2007 5:43 AM
To: LazyDBA Discussion
Subject: RE: List of tables
select distinct(object_name(id)) from sysindexes
where groupid=filegroup_id('filegroupname')
remember tho, there might be indexes too
select name from sysindexes
where groupid=filegroup_id('filegroupname')
and indid > 0
Vanessa Fredanus- van Gelder| SQL DBA | DXS Systems | Tel. +27 21 853
3317|
Fax. +27 21 854 7953
You must be the change you want to see in the world. Mahatma Gandhi
-----Original Message-----
From: Fourie Jaco [mailto:[Email address protected]
Sent: 31 July 2007 11:35
To: Vanessa van Gelder
Subject: RE: List of tables
I have a database XXX. This database consists of 2 database files and 1
log
file named xxx.mdf, xxx.ndf, xxx.ldf.
the mdf file is 28 GB in size and the ndf file is 69 GB in size. I would
like to see all the tables which are located on the ndf file to see what
tables are taking up all that space on the ndf file.
-----Original Message-----
From: Vanessa van Gelder [mailto:[Email address protected]
Sent: 31 July 2007 11:30
To: Fourie Jaco
Subject: RE: List of tables
Ok what is your objective here exactly? You want to find where 2
particular
tables are?
Vanessa Fredanus- van Gelder| SQL DBA | DXS Systems | Tel. +27 21 853
3317|
Fax. +27 21 854 7953
You must be the change you want to see in the world. Mahatma Gandhi
-----Original Message-----
From: Fourie Jaco [mailto:[Email address protected]
Sent: 31 July 2007 11:26
To: Vanessa van Gelder
Subject: RE: List of tables
And how would i do that... :-)
-----Original Message-----
From: Vanessa van Gelder [mailto:[Email address protected]
Sent: 31 July 2007 11:18
To: Fourie Jaco
Subject: RE: List of tables
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
Oh right... well you need to find out then which filegroup they a part
of
Vanessa Fredanus- van Gelder| SQL DBA | DXS Systems | Tel. +27 21 853
3317|
Fax. +27 21 854 7953
You must be the change you want to see in the world. Mahatma Gandhi
-----Original Message-----
From: Fourie Jaco
[Email address protected]
Sent: 31 July 2007 11:15
To: LazyDBA Discussion
Subject: RE: List of tables
Thanks but this only gives me the details for the files, size, growth
ect.
I need to see what tables are on what datafile....
-----Original Message-----
From: Vanessa van Gelder
[mailto:mssqldba-ezmlmshield-x1850313.[Email address protected]
Sent: 31 July 2007 11:05
To: LazyDBA Discussion
Subject: RE: List of tables
sp_helpfile
eddie Edwards? :)
Vanessa Fredanus- van Gelder| SQL DBA | DXS Systems | Tel. +27 21 853
3317|
Fax. +27 21 854 7953
You must be the change you want to see in the world. Mahatma Gandhi
-----Original Message-----
From: Fourie Jaco
[mailto:mssqldba-ezmlmshield-x87564733.[Email address protected]
Sent: 31 July 2007 11:02
To: LazyDBA Discussion
Subject: List of tables
Hi,
I have an database which exist of 2 database files and 1 log file. Is it
possible to see exactly
what tables are on what database file? Running SQL 2000 SP4.
Thanks
Jaco
-----------------------------------------
Please click on the following link to read the
Old Mutual legal notice:
<http://www.oldmutual.co.za/e-mail_legal_notice>
Alternatively, send a "blank" e-mail to
<mailto:[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---
DXS - The Essential Healthcare Information Solution
http://www.dxs-systems.com/
DISCLAIMER:
This communication (including any attachments) may contain confidential
or
proprietary information. If you are not the intended recipient and you
have
received this communication in error, you should destroy it without
copying,
disclosing or otherwise using its contents and notify the sender
immediately
of the error.
Internet communications are not necessarily secure, and may be
monitored,
intercepted or changed after they are sent. DXS and its subsidiaries do
not
accept liability for any loss you may suffer as a result of
interception, or
any liability for such changes.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
Please click on the following link to read the
Old Mutual legal notice:
<http://www.oldmutual.co.za/e-mail_legal_notice>
Alternatively, send a "blank" e-mail to
<mailto:[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---
DXS - The Essential Healthcare Information Solution
http://www.dxs-systems.com/
DISCLAIMER:
This communication (including any attachments) may contain confidential
or
proprietary information. If you are not the intended recipient and you
have
received this communication in error, you should destroy it without
copying,
disclosing or otherwise using its contents and notify the sender
immediately
of the error.
Internet communications are not necessarily secure, and may be
monitored,
intercepted or changed after they are sent. DXS and its subsidiaries do
not
accept liability for any loss you may suffer as a result of
interception, or
any liability for such changes.
-----------------------------------------
Please click on the following link to read the
Old Mutual legal notice:
<http://www.oldmutual.co.za/e-mail_legal_notice>
Alternatively, send a "blank" e-mail to
<mailto:[Email address protected]
---
DXS - The Essential Healthcare Information Solution
http://www.dxs-systems.com/
DISCLAIMER:
This communication (including any attachments) may contain confidential
or
proprietary information. If you are not the intended recipient and you
have
received this communication in error, you should destroy it without
copying,
disclosing or otherwise using its contents and notify the sender
immediately
of the error.
Internet communications are not necessarily secure, and may be
monitored,
intercepted or changed after they are sent. DXS and its subsidiaries do
not
accept liability for any loss you may suffer as a result of
interception, or
any liability for such changes.
---
DXS - The Essential Healthcare Information Solution
http://www.dxs-systems.com/
DISCLAIMER:
This communication (including any attachments) may contain confidential
or proprietary information. If you are not the intended recipient and
you have received this communication in error, you should destroy it
without copying, disclosing or otherwise using its contents and notify
the sender immediately of the error.
Internet communications are not necessarily secure, and may be
monitored, intercepted or changed after they are sent. DXS and its
subsidiaries do not accept liability for any loss you may suffer as a
result of interception, or any liability for such changes.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page