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.

All Forums  General SQL Server Forums  New to SQL Server Administration  table ownership

Author  Topic  ymlam Starting Member 1 Post Posted - 2011-08-30 : 01:45:58 I think I have resolved this problem but I'm still curious for an explanation. I am using SQL2000 server with WinXP. Last month I updated an application software. During upgrade I made the main user the dbo, and upgrade without problem. The main reason is because the upgrade tools pick up the upgrade information from the application ini file. So, several upgraded tables were owned by the user. After the upgrade I change the user back as 'normal' user. Everything works fine as expected. I also had a second and third user that we seldom use, but they have always worked. It comes back with an error message "cannot open tablexxx". The supplier were not of much help. Eventually, I resolve it (I only tried it on a backup server) by changing the tables ownership to dbo. The questions I have are, why does it matter if the owner is not the dbo, can I change tables ownership on the production system when users are still using the system, and for future reference should I use the SA user when I upgrade and install new db? Is SA equivalent to dbo?