On 2/20/06, Snake <[EMAIL PROTECTED]> wrote: > Login with enterprise manager, look at the tables. > Who doe sit say is the owner of the tables, DBO or a specific user. > If it is a specific user, then that means the tables were created as that > user, and thus why you have to prefix all queries with that user name.
Hi Russ, When I'm logged in as the local Windows users, both servers (working and non-working) say the same thing - that the specific user owns all the tables, and that user is in the dbo role. Yet on one machine I have to prefix the query names, and on the other I don't. I will get the client's sysadmin to reown the tables when he gets in (I don't have SA access) as I suspect the database was restored at some point and the users are somehow messed up. -- Kay Smoljak http://kay.zombiecoder.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232867 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54