FYI It seems this error is because the view called 'VIEWS' in the master DB of my SQL has the owner as 'dbo' and not 'Information_SCHEMA'.
I think maybe at some point I accidental ran the change owner script on the master db rather than the Ax DB.... Now I just need to find a way to set back the right views etc to the right user...or otherwise reinstall SQL (since I don't have a backup of master before the change owner happened....) Thanks James -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: 19 July 2005 11:48 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] SQL sync problem Can anyone tell me anything about INFORMATION_SCHEMA.VIEWS in SQL ...I get teh following error messages when I try to sync Axapta. I guess I am missing this view or table and so the system gets stuck but where shoul dthis view be? In the Ax DB or the master DB or where? I hope someone can help as I am not able to do any sync to my databases because of this... Thanks James Error given during sync: Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCES') DROP VIEW LEDGERBALANCES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCESDIM') DROP VIEW LEDGERBALANCESDIM Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNUSERSPERLINES') DROP VIEW BMRUNUSERSPERLINES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMUSERSCRIPTTIMINGAGG') DROP VIEW BMUSERSCRIPTTIMINGAGG Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNSTEPSPREADING') DROP VIEW BMRUNSTEPSPREADING Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMSCRIPTSTEP') DROP VIEW BMSCRIPTSTEP Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERVENDPAYMPROPOSAL') DROP VIEW LEDGERVENDPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERCUSTPAYMPROPOSAL') DROP VIEW LEDGERCUSTPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'CUSTVIEW') DROP VIEW CUSTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERACCOUNTVIEW') DROP VIEW LEDGERACCOUNTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERTRANSVIEW') DROP VIEW LEDGERTRANSVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'PROJDATAVIEW') DROP VIEW PROJDATAVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'PROJEMPLSUM') DROP VIEW PROJEMPLSUM Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'PROJEMPLTRANSVIEW') DROP VIEW PROJEMPLTRANSVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'EMPLVIEW') DROP VIEW EMPLVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'COMPANYVIEW') DROP VIEW COMPANYVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'SYSUTILMANAGEMENTVIEW') DROP VIEW SYSUTILMANAGEMENTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'COMPANYDOMAINLISTVIEW') DROP VIEW COMPANYDOMAINLISTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'PROJCOMMITTEDCOSTPROJECTVIEW') DROP VIEW PROJCOMMITTEDCOSTPROJECTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'PROJCOMMITTEDCOSTCATEGORYVIEW') DROP VIEW PROJCOMMITTEDCOSTCATEGORYVIEW Problems during SQL data dictionary synchronization.,The operation failed. Synchronize failed on 20 table(s) Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> 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/