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

posted on 2010-11-12 14:29  中道学友  阅读(303)  评论(0编辑  收藏  举报

导航

技术追求准确,态度积极向上