SQL Select problem

  •  

    I've got a Database which has a user assigned to it as owner, which is stuser.  All tables and stored procedures are owned by this same user, stuser.  WHen i log into query analyzer as stuser, i am not able to select information from any of the tables w/o specifying stuser.tablename.  What can I change so that I can run SQL queries against my tables logged in as stuser w/o having to specify ownername.tablename?  Otherwiser I get

    Invalid Object: <Tablename>

  • Please do not cross-post. We monitor all boards.

    Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=236102

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply