I goofed and accidently deleted a (child/parent?) portal http://66.35.109.171/dmi/Home/tabid/55/Default.aspx
my ISP restored a backup to prior weedend. Now I have do not have an images folder. They recommend I just delete and rebuild this unless you know another way to fix it. The portal at 66.35.109.171 is fine. But this little lamb has lost its way to the images folder. Should I try this script from host.sql?
if exists (select * from dbo.sysobjects where id = object_id(N'GetFiles') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure GetFiles
GO
CREATE procedure dbo.GetFiles
@PortalId int,
@Folder nvarchar(200)
as
select FileId,
PortalId,
FileName,
Extension,
Size,
WIdth,
Height,
ContentType,
Folder
from Files
where ((PortalId = @PortalId AND Folder=@Folder) or (@PortalId is null and PortalId is null AND Folder=@Folder))
order by FileName
GO