I think you have to recreate those views.
Open Ent. Manager, in masterdb find views with name dbo.[viewname] 
Open them and copy, then in query analyser run them one by one.

This will recreate those views with owner INFORMATION_SCHEMA.


Good luck


Cenk İNCE
ERP Teknik Danışmanı (Microsoft Axapta)
ERP Technical Consultant (Microsoft Axapta)
Data Sistem Genel Otomasyon Sanayi ve Ticaret A.S
www.datasistem.com.tr
Tel : 0232 463 16 63 (Dah: 128)


Hi all,

when I try to syncronize Axapta, I get some error messages like this:

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'INFORMATION_SCHEMA.VIEWS'.

(IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE
TABLE_NAME = 'PROJCOMMITTEDCOSTPROJECTVIEW') DROP VIEW
PROJCOMMITTEDCOSTPROJECTVIEW)

All in all I get 14 error messages, all like the one above.
But when i take a look into the AOT there are more than 20 Views.

For some Views i get no error message.

Where is the problem?

Can sombody help me??

Thanks in advance.









Yahoo! Groups Sponsor



ADVERTISEMENT
 
<http://us.ard.yahoo.com/SIG=1293l6m17/M=298184.5639630.6699735.3001176/D=gr
oups/S=1705006764:HM/EXP=1102270231/A=2434971/R=0/SIG=11eeoolb0/*http:/www.n
etflix.com/Default?mqso=60185400> click here


 
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=
:HM/A=2434971/rand=575715537> 

 

  _____  

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]
<mailto:[EMAIL PROTECTED]> 
  
*       Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/>  Terms of Service. 



[Non-text portions of this message have been removed]







 
Yahoo! Groups Links



 








------------------------ Yahoo! Groups Sponsor --------------------~--> 
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~-> 

 
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:
    http://docs.yahoo.com/info/terms/
 




Reply via email to