Tag Archives: SQL Change Owner Script

SQL Owner Change Script

Posted on August 4, 2009 by mike

sp_changeobjectowner [ @objname = ] ‘object’ , [ @newowner = ] ‘owner’ SELECT ‘EXEC sp_changeobjectowner ”’+ SCHEMA_NAME(schema_id) + ‘.’ + OBJECT_NAME(object_Id) + ”’, ”dbo”’FROM sys.tables In order to change the owner of an object in the current database, use the … Continue reading →

Posted in Microsoft, SQL/Database | Tagged | Leave a comment