Red Gate forums :: View topic - Invalid object name...
Return to www.red-gate.com RSS Feed Available

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

Invalid object name...

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
jdahlgren



Joined: 04 Jul 2007
Posts: 2

PostPosted: Wed Jul 04, 2007 8:13 am    Post subject: Invalid object name... Reply with quote

When trying to run my package exe i get this error "Invalid object name...".
It seems lite SQL Packager does not handles dependencies correctly.

In this case it is a table function that is used in a view.
The script is trying to create the view before the function.

The "Include dependecies" option is checked.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6646

PostPosted: Sun Jul 08, 2007 10:53 pm    Post subject: Reply with quote

Hi,

Can you please post the full version number from SQL Packager's help_about menu item? I've seen a fix for a similar problem done between SQL Bundle 5.2 and 5.3. I noticed, however, that another user had reported it again but we were unable to get enough information to reproduce the problem.

Thanks!
Back to top
View user's profile Send private message
jdahlgren



Joined: 04 Jul 2007
Posts: 2

PostPosted: Mon Jul 30, 2007 6:54 am    Post subject: Reply with quote

Hi!

I have been on summervaccation so i have not been able to answer this until now...

My version on SQL Packager is 5.4.0.82
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6646

PostPosted: Mon Jul 30, 2007 1:36 pm    Post subject: Reply with quote

Hi,

In SQL 2000, it's possible that the function can get renamed, and mess up the dependency chain because the names of the object in two different system tables do not match. To detect these functions, you could use the following query:
Code:

SELECT  s.NAME, s.xtype, c.TEXT
FROM    sysobjects s
INNER JOIN syscomments c ON s.id = c.id
WHERE   s.NAME <> SUBSTRING(c.TEXT, CHARINDEX(s.name, c.TEXT), len(s.name)) AND (s.xtype = 'FN' OR s.xtype = 'TF')

If any results are found, you may want to script this function, then drop and recreate it. This will result in SQL that is consistent between syscomments and sysobjects.
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