Invalid object name...

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Invalid object name...

Postby jdahlgren » Wed Jul 04, 2007 8:13 am

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.
jdahlgren
 
Posts: 2
Joined: Wed Jul 04, 2007 7:58 am

Postby Brian Donahue » Sun Jul 08, 2007 10:53 pm

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!
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby jdahlgren » Mon Jul 30, 2007 6:54 am

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
jdahlgren
 
Posts: 2
Joined: Wed Jul 04, 2007 7:58 am

Postby Brian Donahue » Mon Jul 30, 2007 1:36 pm

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 all
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.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron