1
vote
1answer
67 views

Avoiding SQL Server 2005 tables with same names, but with different owners

What is the most likely cause of this behavor with SQL Server 2005? TEST #1: I run Management Studio Express, connect to my local database with "windows authentication" and see that I have 1 ...
6
votes
2answers
32k views

Changing database owner in SQL Server 2008; CLR issues depending on method used?

I attached a database and tried changing the owner to a valid login. I used the statement: ALTER AUTHORIZATION ON database::my_db_name TO "sa". The database properties showed that the new owner was ...