SQL Packager gets the name of objects by parsing the SQL code used to create the object in the case of UDFs, stored procedures, and defaults. When SQL Server is used to rename objects, typically it updates the sysobjects table and not the syscomments table, where the actual ddl is stored.
For instance, running
- Code: Select all
SELECT [text] FROM syscomments WHERE [id] IN (SELECT id FROM sysobjects WHERE [NAME]='NegOne')
More than likely, the result will show CREATE DEFAULT NeagtiveOne as... and that's the problem.
The only way around I know of is to drop and recreate the default.