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 2005 Forums
 SQL Server Administration (2005)
 Move Images to new File

Author  Topic 

scottpt
Posting Yak Master

186 Posts

Posted - 2010-04-27 : 09:31:17
I have a table
CREATE TABLE [dbo].[CheckItemImage](
[CheckItem_ID] [dbo].[TID] NOT NULL,
[RowGUID] [dbo].[TReplicationID] ROWGUIDCOL NOT NULL,
[Image_Check] [image] NULL,
[Image_Back] [image] NULL,
[ImageFrontRaw] [image] NULL,
[ImageBackRaw] [image] NULL,
[ImageFrontRawFormat] [dbo].[TShortName] NULL,
[ImageBackRawFormat] [dbo].[TShortName] NULL,
[Date] [datetime] NULL,
CONSTRAINT [PK_CheckItemImage] PRIMARY KEY CLUSTERED
(
[CheckItem_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


I want to alter it to .. TEXTIMAGE_ON [IMAGES].

Is this possible with out dropping and recreating the table.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-04-27 : 10:59:28
Read this:
http://decipherinfosys.wordpress.com/2007/08/14/moving-tables-to-a-different-filegroup-in-sql-2005/


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

scottpt
Posting Yak Master

186 Posts

Posted - 2010-04-29 : 08:47:09
I tried this it only moves the non image columns
Go to Top of Page
   

- Advertisement -