Invalid object name 'dbo.[VIEW]'
Spongebob76
Posts: 6
Hi,
I still have trouble with SQL Packager. This time I have scripted the entire database and tried to run it as an exe as well as jus the script. Please see error message below.
...
Creating [dbo].[vLoanCustomDataStructure]
Creating [dbo].[vRatings]
Creating [dbo].[QuestionnairesNodeStatuses]
...
Creating [dbo].[vAuditSelectedLoans]
Msg 208, Level 16, State 1, Procedure vAuditSelectedLoans, Line 3
Invalid object name 'dbo.vRatings'.
(1 row(s) affected)
The weird thing is that vRatings has been previously successfully created. I have also checked the view in my source database, and that one is running just fine.
Regards,
Andre
I still have trouble with SQL Packager. This time I have scripted the entire database and tried to run it as an exe as well as jus the script. Please see error message below.
...
Creating [dbo].[vLoanCustomDataStructure]
Creating [dbo].[vRatings]
Creating [dbo].[QuestionnairesNodeStatuses]
...
Creating [dbo].[vAuditSelectedLoans]
Msg 208, Level 16, State 1, Procedure vAuditSelectedLoans, Line 3
Invalid object name 'dbo.vRatings'.
(1 row(s) affected)
The weird thing is that vRatings has been previously successfully created. I have also checked the view in my source database, and that one is running just fine.
Regards,
Andre
Comments
Something inside of SQL Server must have been screwed up.
I deleted the view vRatings and recreated it.
Now it is working fine.
I'm glad that you managed to fix the problem.
If you still have any problems please let us know either via the forum, email or call.
Regards
Dan
Red Gate Software Ltd