Friday, 4 February 2011

Finding Filegroup - Objects

select distinct(object_name(id)) from sysindexes
where groupid=filegroup_id('PRIMARY')