package database to install on SQL 2005

markfronmarkfron Posts: 2
edited December 8, 2008 2:07PM in SQL Packager Previous Versions
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?

Comments

  • Eddie DEddie D Posts: 1,805 Rose Gold 5
    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
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.