Header comments missing

jrjones1956

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

David Atkinson

Do the test procedures appear altered only if opened from SQL Test (via double click) or also when doing a Modify from the Object Explorer?

jrjones1956

Only when opened through SQL Test. In Object Explorer, the header comments appear.

David Atkinson

Ah. Sounds like a bug in the way we script out the objects. I'll notify the appropriate developer on your behalf.

At least this means that nothing in your database has changed.

In the meantime please modify the tests using "Modify" rather than via the SQL Test tree.

Thanks for bringing this to our attention.

Kind regards

David Atkinson
Red Gate

David Atkinson

Just to let you know that we've identified the issue and we hope to release a fix later today.

jrjones1956

That's great, thank you!

David Pond

There should now be an update available through Check For Updates within SQL Test that fixes this issue. Thanks for bringing it to our attention.

You can also download the update from here:
http://download.red-gate.com/checkforup ... 5.0.85.exe