Comments
6 comments
-
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? -
Only when opened through SQL Test. In Object Explorer, the header comments appear.
-
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 -
Just to let you know that we've identified the issue and we hope to release a fix later today.
-
That's great, thank you!
-
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
Add comment
Please sign in to leave a comment.
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