invalid stored procedures with CREATE TABLE inside
the stored procedure
CREATE PROCEDURE test AS CREATE TABLE TMP ( somecolumn INT ) INSERT INTO TMP(somecolumn) VALUES (1)is discovered by sqlprompt as an invalid object though it can be stored and executed by SQL Server. We have a couple of procedures, wich create tables and remove them in the end.
Is there a way to prevend sqlpromt from classifying them as invalid?