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
[mailto:mssqldba-ezmlmshield-x28134655.[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.
MS Sql Server LazyDBA home page