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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Table in Filegroup

Author  Topic 

chetancool
Starting Member

34 Posts

Posted - 2005-07-27 : 01:50:04
Hi Group,

I have two filegroup for my database (S1, S2). I want to create a table which should be distrubuted on both the filegroups.

Any idea how to do that.

cjain

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-07-27 : 12:35:18
quote:
Originally posted by chetancool

Hi Group,

I have two filegroup for my database (S1, S2). I want to create a table which should be distrubuted on both the filegroups.

Any idea how to do that.

cjain



You can't. A table can only be contained within a single filegroup.

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
Go to Top of Page
   

- Advertisement -