Red Gate forums :: View topic - "Invalid Object Name" When Executing Script
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

"Invalid Object Name" When Executing Script

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
cklaw



Joined: 22 Sep 2009
Posts: 12

PostPosted: Tue Nov 03, 2009 1:57 pm    Post subject: "Invalid Object Name" When Executing Script Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Wed Nov 04, 2009 3:18 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
cklaw



Joined: 22 Sep 2009
Posts: 12

PostPosted: Wed Nov 04, 2009 5:53 pm    Post subject: "Invalid Object Name" When Executing Script Reply with quote

Thanks Brian. I will give that a try.

Charles
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group