How can I change the owner of an object?

You can change the owner of an object using...

the stored procedure sp_changeobjectowner.

Example:


USE test
GO
EXEC sp_changeobjectowner 'Products', 'Pippo'
GO

'Pippo' becomes l'owner dell'object "Products", in this case a table.

The use of the information shown here is at your risk.
Cyber Methexis disclaims any liability for malfunction and/or loss of data.


Tag cloud

linux internet open source windows scripts hardware apple informatica sicurezza sistemi operativi tips and tricks software downloads networking microsoft scripting