Find all DNN Portals on All databases on a single SQL server Instance
Have you ever wanted to get a total list of all the DotNetNuke portals in all your database installations on a single server?
Well, look no further:
IF OBJECT_ID (‘tempdb..##TempTemp’,'U’) IS NOT NULL
DROP TABLE ##TempTemp
CREATE TABLE ##TempTemp (ID INT, Name NVARCHAR(MAX ), DbName NVARCHAR(MAX))
exec sp_MSforeachdb ‘IF OBJECT_ID (”?.dbo.Portals”,”U”) IS NOT NULL INSERT ##TempTemp SELECT PortalId, PortalName , ”?” FROM ?.dbo.Portals’
select * from ##TempTemp;
Categories: Uncategorized