This is a somewhat academic question. In sql-2000, I have a database, and two tables with same name but different owners.
Lets say it's user A and user B. There is a stored procedure owned by user A, and lets say it says "Update table1 set field = 'x';"
Will it update the A.table1 or B.table1?
I'm assuming A, but am not 100 sure...
Thanks,
--Jim
Lets say it's user A and user B. There is a stored procedure owned by user A, and lets say it says "Update table1 set field = 'x';"
Will it update the A.table1 or B.table1?
I'm assuming A, but am not 100 sure...
Thanks,
--Jim