Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 SQL Server 6.5 \ SQL Server 7.0
 view is not running correctly

Author  Topic 

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2009-06-18 : 07:19:32
I created a view and if I click run the view runs fine and if I run the query of the view then it runs fine but when i try to select from teh view I get an error

Invalid object name 'Placements'.

nr
SQLTeam MVY

12543 Posts

Posted - 2009-06-18 : 08:27:46
Probably because Placements is an invalid object.
Maybe wrong owner, spelling, case, not an exposed name?

Can you post the view and how you are using it.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -