I would like to move a lot of indexes (non-clustered) to a different
filegroup. Is there any way of doing this in a script?
thanks
GavDrop and recreate is your only option for nonclustered indexes.
--
Andrew J. Kelly SQL MVP
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cpk7ea$4il$1@.titan.btinternet.com...
>I would like to move a lot of indexes (non-clustered) to a different
> filegroup. Is there any way of doing this in a script?
> thanks
> Gav
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment