Home Forums SQL Server 2005 Administering Tried to remove filegroup RE: Tried to remove filegroup
DBA in Unit 7
SSCarpal Tunnel
Points: 4059
More actions
January 26, 2009 at 11:41 am
#932751
Run the following and see what are there:
USE YOURDATABASE
SELECT object_name([object_id]) AS Objects_IN_Filegroup
FROM sys.indexes
WHERE data_space_id=104