Header comments missing

Easy unit testing for databases in SQL Server Management Studio

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, David Priddle

Header comments missing

Postby jrjones1956 » Wed Apr 16, 2014 4:00 pm

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
jrjones1956
 
Posts: 7
Joined: Wed Apr 16, 2014 3:48 pm
Location: Phoenix, Arizona

Postby David Atkinson » Wed Apr 16, 2014 4:47 pm

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?
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby jrjones1956 » Wed Apr 16, 2014 4:48 pm

Only when opened through SQL Test. In Object Explorer, the header comments appear.
jrjones1956
 
Posts: 7
Joined: Wed Apr 16, 2014 3:48 pm
Location: Phoenix, Arizona

Postby David Atkinson » Wed Apr 16, 2014 4:51 pm

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby David Atkinson » Thu Apr 17, 2014 11:16 am

Just to let you know that we've identified the issue and we hope to release a fix later today.
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby jrjones1956 » Thu Apr 17, 2014 2:32 pm

That's great, thank you!
jrjones1956
 
Posts: 7
Joined: Wed Apr 16, 2014 3:48 pm
Location: Phoenix, Arizona

Postby David Pond » Thu Apr 17, 2014 4:50 pm

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
David Pond
Site Admin
 
Posts: 24
Joined: Tue Mar 06, 2012 7:13 pm
Location: Cambridge, UK


Return to SQL Test

Who is online

Users browsing this forum: No registered users and 0 guests