It doesn't work on my website. Did I miss something?
I copy
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}Help_ListCategoryByParent]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}Help_ListCategoryByParent]
GO
CREATE PROCEDURE {databaseOwner}[{objectQualifier}Help_ListCategoryByParent]
@ModuleID int,
@ParentID int
AS
SELECT [CategoryID],
[CategoryGUID],
[Name],
[Description],
[Image],
[KeyWords],
[ModuleID],
[Order],
[Level],
[Parent],
[Visible],
[Deleted]
FROM {databaseOwner}{objectQualifier}Help_Category
WHERE [Parent] = @ParentID AND [ModuleID] = @ModuleID
AND [Deleted] <> 1
ORDER BY [Level] ASC,
[Parent] ASC,
[Order] ASC
GO
to the SQL and choose "run as script" then click "Exeute". The answer is "The Query completed successfully! " But it doesn't work.