packaging for SQL 2000 and 2005

[melly]

I have a SQL 2005 DB that I want to package for a SQL 2000 server. Is there a setting that I need to set so that it packages it correctly. I tried creating a package already but it gave me a syntax error when it tried to create a user.

[Brian Donahue]

Hi,

SQL Packager creates packages in the syntax of the SQL Server platform being packaged. That means you would need a SQL Server 2000 handy to create a package that will run on SQL 2000.

I hope this helps.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521