Untitled

if exists (select * from sysobjects where name = 'usp_list_emailTemplates') drop procedure usp_list_emailTemplates
go

create procedure usp_list_emailTemplates
as

set nocount on

begin

/*
SP to get list of current email templates
*/

select
 et.EmailTemplateId,
 et.TemplateName ,
 et.MessageTo,
 et.MessageCc ,
 et.MessageBcc ,
 et.MessageSubject ,
 et.MessageBody ,
 et.BodyFormat
 /*
  -- used for internal purposes ?
 et.EmailTemplateId
 */
from
 emailTemplate et
order by
 et.EmailTemplateId;

end
go

grant execute on usp_list_emailTemplates to public
go