I have a stored procedure which schedules a job in SQL Server 7.0. This
stored procedure is called from an insert trigger which works most of the
time. Occasionally I get the error 'Can not CREATE TABLE in a trigger'
which then occurs every time I attempt an insert. The only way to clear the
error is to run the stored procedure in Query Analyser which stops the
problem for a period of time.
Anyone any idea how to stop this problem. It's proving rather embarrassing.