Thursday, June 5, 2014

How to get site collection in content db using sql statement

Hello EveryBody,

I found to the way get Web's information  (Title, ... ) from content database.
Here is SQL Statement:

SELECT
    SiteId AS SiteGuid,
    Id AS WebGuid,
    FullUrl AS Url,
    Title,
    TimeCreated
FROM dbo.Webs


0 comments:

Post a Comment