Red Gate forums :: View topic - Header comments missing
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Test
SQL Test forum

Header comments missing

Search in SQL Test forum
Post new topic   Reply to topic
Jump to:  
Author Message
jrjones1956



Joined: 16 Apr 2014
Posts: 7
Location: Phoenix, Arizona

PostPosted: Wed Apr 16, 2014 4:00 pm    Post subject: Header comments missing Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Wed Apr 16, 2014 4:47 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message Send e-mail
jrjones1956



Joined: 16 Apr 2014
Posts: 7
Location: Phoenix, Arizona

PostPosted: Wed Apr 16, 2014 4:48 pm    Post subject: Reply with quote

Only when opened through SQL Test. In Object Explorer, the header comments appear.
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Wed Apr 16, 2014 4:51 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Thu Apr 17, 2014 11:16 am    Post subject: Reply with quote

Just to let you know that we've identified the issue and we hope to release a fix later today.
Back to top
View user's profile Send private message Send e-mail
jrjones1956



Joined: 16 Apr 2014
Posts: 7
Location: Phoenix, Arizona

PostPosted: Thu Apr 17, 2014 2:32 pm    Post subject: Reply with quote

That's great, thank you!
Back to top
View user's profile Send private message Send e-mail
David Pond
Site Admin


Joined: 06 Mar 2012
Posts: 24
Location: Cambridge, UK

PostPosted: Thu Apr 17, 2014 4:50 pm    Post subject: Reply with quote

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/checkforupdates/SQLTest/SQLTest_1.5.0.85.exe
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group