Red Gate forums :: View topic - package database to install on SQL 2005
Return to www.red-gate.com RSS Feed Available

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

package database to install on SQL 2005

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
markfron



Joined: 04 Dec 2008
Posts: 1

PostPosted: Thu Dec 04, 2008 5:09 pm    Post subject: package database to install on SQL 2005 Reply with quote

I am packaging a database from SQL2000 to SQL2005. It creates the package, and upon installation for a SQL 2005 database, it returns message "ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator. ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator"

However, when I copy the stored procedure and execute it manually it creates it in SQL 2005.

Is there an option on the packager to remove this requirement.

It seems that SQL2005 will accept the stored procedure as is from SQL 2000, so why is the packager returning the error?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Mon Dec 08, 2008 8:07 pm    Post subject: Reply with quote

Thank you for your post into the forum.

A support call has been created for you, the call reference is F0017616.

Can you please send to us (support@red-gate.com), a screen shot of the error message you get when you attempt to run the package?

Also the syntax that creates the Stored Procedure you are having problems with?

Please place in the Subject heading of the e-mail your call reference F0017616.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
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