Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2011-07-08 : 14:08:49
|
| Guys,Is there anyway to locate what tables belong database files (assuming that there are multiple database files mdf and ndf). I used this query below, but it only tells me database files and does not correspond to the database objects.SELECT *FROM master.sys.master_filesWHERE database_id = 35Any suggestions/inputs would helpThanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-08 : 14:30:39
|
| http://www.sqlservercentral.com/blogs/jeffrey_yao/archive/2009/01/16/list-objects-in-a-filegroup-in-sql-server-2005.aspx |
 |
|
|
|
|
|
Tables in database files - mdf, ndf