[跨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的查询.