As I want to view dependencies of just a couple of tables in my clients database I want to set myself as the owner of the database.
If the database is called MyDatabase and my userName is MyDomainMyUserName
How do I use the ALTER AUTHORIZATION statement to set myself as Owner ?
Check this links and references:
EXEC sp_changedbowner 'Albert'
ALTER AUTHORIZATION ON OBJECT::Parts.Sprockets TO MichikoOsada; GO
ALTER AUTHORIZATION ON DATABASE::MyDatabase TO MyUserName;