For a quick workaround you can rename the sproc to Smith_AddEmailTemplateSC. Then you will be able to add templates to the database and the emails will work.
You can also run thiis script in Host|SQL (paste code, check Run As Script, then execute)
-- remove bad sproc
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'{databaseOwner}{objectQualifier}Smith_Smith_AddEmailTemplateSC'))
drop procedure {databaseOwner}{objectQualifier}Smith_Smith_AddEmailTemplateSC
GO
-- remove renamed sproc
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'{databaseOwner}{objectQualifier}Smith_AddEmailTemplateSC'))
drop procedure {databaseOwner}{objectQualifier}Smith_AddEmailTemplateSC
GO
-- add proper sproc
CREATE PROCEDURE {databaseOwner}{objectQualifier}Smith_AddEmailTemplateSC
@TabModuleID int,
@Name nvarchar(50),
@Subject nvarchar(255),
@Template ntext,
@PortalID int
AS
INSERT INTO {objectQualifier}Smith_EmailTemplateSC (
[TabModuleID],
[Name],
[Subject],
[Template],
PortalID
) VALUES (
@TabModuleID,
@Name,
@Subject,
@Template,
@PortalID
)
select SCOPE_IDENTITY()
GO
Now you should be able to add email templates and the emails will not be blank.
I hope this is of some help to you.