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)





SPONSORED LINKS
Computer part Programming languages Microsoft axapta
Support exchange


YAHOO! GROUPS LINKS




Reply via email to