I just upgraded SQL Test to version 22.214.171.124. When I open tests that preexisted the upgrade, the comments at the beginning of the script are gone!
A new test has the following at the beginning, and nothing more:
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
ALTER PROCEDURE [testCourt].[test junk_test]
WITH EXECUTE AS CALLER
After creating this test, then trying to execute the test, which should run successfully without any alteration, the following error message is displayed:
Msg 111, Level 15, State 1, Procedure test junk_test, Line 23
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.
My headers are comments that describe the purpose for the test, any revisions made, and pseudocode for the test. I really don't want to lose them.
Did SQL Test do this? If so, how can it be fixed. I have a backup of the effected database.