Object names are being changed.

Dave Pendleton

I am generating a package from a SQL2K5 database that contains two views:

dbo.TEMP_TESTING_JOSHH_1
dbo.TEMP_TESTING_JOSHH_2

The resulting script has removed the _1, _2 from the names, thus a duplicate object error eventually results. The body of the views are correct, though.

Any ideas?

Ben Pinchen

Could you send me the package that you've created and a schema snapshot of the original database and I'll have a look into this for you?

You can send them to support@red-gate.com