SQL Server 2008 R2 - Table Views and how they work?
Posted on 2014-04-15
Hi and thanks,
How do you create a view???
I have this view called "Claims" it works in one Database, but not in another.
When I "Select the first 1000 rows" it works fine in one database.
when I "Select the first 1000 rows" in another database I get:
Msg 208, Level 16, State 1, Procedure CLAIM, Line 1
Invalid object name 'CLAIM_2013_07'.
Msg 4413, Level 16, State 1, Line 57
Could not use view or function 'OPID_POSTPAY_WELLPOINT_CENTRAL_EDWARD.dbo.CLAIM' because of binding errors.
I am guessing that the object is located in one database but not the other...
What is the problem and how do I check to see what the problem is???