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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | estheraMaster 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'. |  |  
                                    | nrSQLTeam 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. |  
                                          |  |  |  
                                |  |  |  |