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 |
|
SQLboom
Yak Posting Veteran
63 Posts |
 Posted - 2004-03-09 : 04:25:55
|
| How can we create different table on different file belonging to the same filegroup?Thanks |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-09 : 04:47:51
|
| You cant. You can create a table in a different filegroup, or you can move an existing table to a different filegroup by creating a clustered index. However within a filegroup files are filled proportionally, meaning that they are written to according to how much free space they have with the aim of having them fill up at the same time. You can't explicitly reference any file in a filegroup for object-level DDL commands, only for operations such as backup and restore.Raymond |
 |
|
|
|
|
|
table on different file