RE : [Axapta-Knowledge-Village] Re: dbo to bmssa

2006-05-29 Thread Steeve Gilbert
@yahoogroups.com Objet : [Axapta-Knowledge-Village] Re: dbo to bmssa You can use the SQL procedure below to change the object owner of tables and views. However, I would recommend changing the owner FROM bmmssa TO dbo. Use this stored procedure to change the owner of the database: sp_changedbowner 'bmssa

[Axapta-Knowledge-Village] Re: dbo to bmssa

2006-05-25 Thread Mikael Sorensen
You can use the SQL procedure below to change the object owner of tables and views. However, I would recommend changing the owner FROM bmmssa TO dbo. Use this stored procedure to change the owner of the database: sp_changedbowner 'bmssa'. Now, all new objects are created with dbo as object

[Axapta-Knowledge-Village] Re: dbo to bmssa

2006-05-24 Thread Mike Urban
Check the database roles of the bmssa user in SQL. --- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert [EMAIL PROTECTED] wrote: Hi group, I just want to know if there's something to cure us from the modified objects that keep on changing owner from dbo to bmssa. It's