Change MSSQL table owner
I've just had an issue with permission access to stored procedures on my local machine VS my dev machine. The reason being was that when I created the SPs the server made the owner dbo. luckily you can use a MSSQL stored procedure to change this./ Jump into query analyser and type in:
sp_changeobjectowner '[DATABASE_NAME].[TABLE_NAME]' , 'NEW_OWNER_NAME'
i.e.
sp_changeobjectowner '[SMS].[tblContactType]' , 'ntong'
Comments
[Add Comment]
works on 1and1 MS Hosting
# Posted By SiMo
| 22/04/08 06:39
| Report abusive comment
[Add Comment]
