What am I missing? I have a trigger for an insert and that
fires a stored procedure. The stored procedure fails in an
attempt to create a temporary table. The following error
The CREATE TABLE statement is not allowed within a
In looking at books online, I do not see this as a illegal
command for a trigger. Is it illegal or is my syntax
A section of the stored procedure is provided below.
Thanks in advance for any suggestions.
CREATE PROCEDURE [SP_SEND_SCM_MAIL] AS
CREATE TABLE #texttab (