Header comments missing

jrjones1956jrjones1956 Posts: 13 Bronze 1
edited April 17, 2014 11:50AM in SQL Test
I just upgraded SQL Test to version 1.5.0.82. 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
AS
BEGIN
--Assemble
...

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.

Jeff

Comments

Sign In or Register to comment.