"Invalid Object Name" When Executing Script

[cklaw]

I have a database that has been scripted using SQL Packager 6. When I execute the script against an empty database I get what appear to be erroneous errors reported. In particular, it reports Invalid Object Name citing an object which has been created earlier in the script. I have searched for the object name in the script and can see the CREATE prior to where it is reported as invalid.

So, it appears to have worked out the correct creation order, but for some reason it doesn't recognise that the object has been created.

Has anyone seen this, and/or can suggest the cause and a solution?

I'm using SQL Server 2005 SP3.

TIA

Charles

[Brian Donahue]

Hi Charles,

I have seen this error before. It's pretty rare, but sometimes SQL Server seems to "forget" about uncommited transactions and I don't know why. In all cases, it works to disable transactions using the "Do not use transactions in synchronization scripts" option. This is not ideal if you want to roll back, but in the case of a new database package it's probably not that important anyway.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[cklaw]

Thanks Brian. I will give that a try.

Charles