Moving the index to different filegroup

There is already a database installed in my site and spilted on different filegroups. I want to know which object is located on which filegroup. preferably the indexes and if I want to move them to another filegroup how can I do
Thanks in advanc
Regards
sunilHi,
Best approach is to drop and create the index in the new file group using
Create index command.
Please have a look into the below link for more information,
http://www.sqljunkies.com/HowTo/B9F7F302-964A-4825-9246-6143A8681900.scuk
Thanks
Hari
MCDBA
"Sunil" <anonymous@.discussions.microsoft.com> wrote in message
news:7BA0A331-3990-4330-8837-9C871B24A9F4@.microsoft.com...
> There is already a database installed in my site and spilted on different
filegroups. I want to know which object is located on which filegroup.
preferably the indexes and if I want to move them to another filegroup how
can I do.
>
> Thanks in advance
> Regards,
> sunil|||select
object_name(i.id) as table_name,
i.name as index_name,
groupname as [filegroup]
from sysfilegroups s, sysindexes i
where i.groupid = s.groupid
and i.name not like '_WA_Sys_%'
order by filegroup, table_name, index_name
Sunil wrote:
> There is already a database installed in my site and spilted on different filegroups. I want to know which object is located on which filegroup. preferably the indexes and if I want to move them to another filegroup how can I do.
> Thanks in advance
> Regards,
> sunil