[跨DB查询]查找SharePoint 2007中的Orphan Feature的SQL语句
如下:
SELECT [SiteId] ,[WebId] ,[FeatureId] ,[TimeActivated] ,[Flags] ,[Properties] ,[PropertiesModified] FROM [WSS_Content_MOSS_80_Oct_01].[dbo].[Features] f WHERE f.FeatureId not in (SELECT Id FROM [SharePoint_Config].[dbo].[Objects])
注意, 这里使用了跨DB的查询.