Options
Header comments missing
jrjones1956
Posts: 13 Bronze 1
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
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
Product Manager
Redgate Software
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
Product Manager
Redgate Software
Product Manager
Redgate Software
You can also download the update from here:
http://download.red-gate.com/checkforup ... 5.0.85.exe