Sunday, March 25, 2012

Changing BLOB filegroup

Hi,
I change the filegroup of my table's BLOB using EM. How can I do that
without EM (using TSQL).
Many thanks,
Leila
Leila,
EM creates a new table with TEXTIMAGE_ON <new filegroup>, then copies in the
data, drops the old table, and uses sp_rename to change the name of the new
table to the old table's name. Unfortunately, I don't believe there's a
more direct way of accomplishing that kind of change.
"Leila" <leilas@.hotpop.com> wrote in message
news:u6Ue46gpEHA.2696@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I change the filegroup of my table's BLOB using EM. How can I do that
> without EM (using TSQL).
> Many thanks,
> Leila
>

No comments:

Post a Comment