I have a customer database I am trying to update to latest version and I am getting an error running the update. I never had a problem in the past using Packager 5, but Packager 6 seems to have an issue with it. It works when I attach their database to my SQL2005 server, but does not work on their SQL2000 server. The following is the error they get back:

Thanks for your forum post. It seems you have run into a compatibility issue that is going to require you to make two different packages, one for SQL 2000 and one for 2005.

SQL Packager will produce SQL syntax compatible with the database being packaged -- it does not conditionally modify the SQL syntax at runtime. In your case, the problem is that the level0type of the extended property being executed is 'SCHEMA' and SQL 2000 only understands this as 'USER'. So if you were to change the failing query text from SCHEMA to USER, the query would succeed.

However, it may be better to produce a SQL 2000-compatible package anyway because other syntax problems could arise. To see how to produce a SQL 2000-compatible package from a SQL 2005 database, please reference the following knowledge base article:
http://www.red-gate.com/supportcenter/C ... 000150.htm

The database I have attached is a sql2000 database. I copied there database from their server and attached it to mine. I can't do that other method since the customer already has data and is using it daily. Is this something I can find and modify in the script before the packager compiles the executable?