| Author |
Message |
jdahlgren
Joined: 04 Jul 2007
Posts: 2
|
 Posted: Wed Jul 04, 2007 8:13 am Post subject: Invalid object name... |
 |
|
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 |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Sun Jul 08, 2007 10:53 pm Post subject: |
|
|
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
jdahlgren
Joined: 04 Jul 2007
Posts: 2
|
| Posted: Mon Jul 30, 2007 6:54 am Post subject: |
|
|
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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Mon Jul 30, 2007 1:36 pm Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
|
|
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
