Sorry for previous message
directly open Query analyser, open database master/views. Rigth click on the views and select run the query. Like picture on attachment. 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) -----Original Message----- From: Preston A. Larimer [mailto:[EMAIL PROTECTED] Sent: Saturday, December 04, 2004 8:56 PM To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Syncronization error - Invalid object name 'INFORMATION_SCHEMA.VIEWS' Did you look at the master database as I suggested in my last message? If so what did you see?. Are you sure the other 6 views are Synching, or is it just erroring out before it gets to them, how about trying to Synchronizing each view individually in the AOT so you can for sure isolate that some views cause a problem, and some do not. Once you do that let us know your results, the more info you can feed people here, the more likely we will be able to help you come up with a solution. -Preston _____ From: El Caramba [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 1:33 PM To: Development-Axapta; Axapta-Knowledge-Village Subject: [development-axapta] Syncronization error - Invalid object name 'INFORMATION_SCHEMA.VIEWS' 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 [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
