Do you have Axapta tables in the database? If so the Axapta tables should be user tables. If all your tables are system tables you need to change the properties of the table.
If the ownership on the tables is wrong you can eigther use the allready mailed solution to fix it. (sp_change_users_login AUTO_FIX,'bmssa')
If the you want to move the tables to a new user you need to change the table ownership like this:
(declare @name varchar(250)
declare @olduser varchar(250)
declare @newuser varchar(250)
declare @sp_str varchar(250)
set @olduser = 'bmssa.'
set @newuser = 'xxx'
declare cursor1 cursor for
select name from sysobjects where xtype = 'u' and uid == 1 -- (1 = dbo)
open cursor1
fetch cursor1 into @name
while begin transaction
begin
set @sp_str = @olduser + @name
exec sp_changeObjectOwner @sp_str,@newuser
fetch cursor1 into @name
end
commit transaction
close cursor1
deallocate cursor1)
/Jesper
-------- Original Message --------
Subject: RE: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABL (23-Mai-2004 18:40)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
>
> I've tried your method but it still can't work. The table owner is `dbo'
> and the tables are all system tables. Hence there is no way I can change
> the owner of the system tables.
>
>
>
> Any solution I can resolve it?
>
>
>
> Thanks in advance.
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Domains - Claim yours for only $14.70/year
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
