February 22, 2003 at 8:15 am
hi,
I've changed the ownership of all tables in a db to belong to a sql user. when login in as this user and selecting from a table without the user name I'm getting the correct results; however, when trying to update\insert\delete from a table, I'm getting an error message " cannot find object dbo.table_name" ? ? ? as I said the owner of the obect is user_id.table_name and when I select user_id.table_name it works fine...trying to do anyother DML the DBMS says cannot find DBO.table_name...
any ideas???
February 22, 2003 at 10:09 am
Perhaps a trigger on the table that still has dbo embedded?
Andy
February 24, 2003 at 4:48 am
Thanks Andy,
it was triggers with dbo embedded in them...there were created by sql replication 🙂
[/quote]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply