|
Home > Archive > MS SQL Server > November 2005 > columns in different filegroups
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
columns in different filegroups
|
|
| hongo32 2005-11-29, 1:23 pm |
| hi, is posible in sql server 2000 or 2005 asign a column to a filegroup
or file and other column of the same table to another filegroup or
file?... or i need to create two tables? thanks
| |
| Tom Moreau 2005-11-29, 1:23 pm |
| The short answer is to use two tab les. The long answer is that you can
have text/image columns in a separate filegroup.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@cips.ca
www.pinpub.com
"hongo32" <hongo32es@yahoo.com> wrote in message
news:1133290695.567297.250330@g47g2000cwa.googlegroups.com...
> hi, is posible in sql server 2000 or 2005 asign a column to a filegroup
> or file and other column of the same table to another filegroup or
> file?... or i need to create two tables? thanks
>
| |
| hongo32 2005-11-29, 1:23 pm |
| ok, thanks
|
|
|
|
|