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 |
|
noamg
Posting Yak Master
215 Posts |
 Posted - 2008-07-24 : 05:25:20
|
| how to know where a partition is located ? means on which file ?Noam Graizer |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-24 : 06:28:02
|
select * from sys.database_files
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
noamg
Posting Yak Master
215 Posts |
Posted - 2008-07-24 : 07:03:04
|
| no.where a specific partition is located ?the DB can be composed from many many files ....Noam Graizer |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-24 : 07:09:46
|
Check out all catalog and system views in Books Online.You will find the view you want soon enough.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
partitions on difference files