There is a way to change owner of a given object in SQL Server 2005 and higher version. Object can be a stored procedure or table or view or user-defined function. In the following code snippet you see an example. ALTER SCHEMA dbo TRANSFER [MyOwner]....