Good luck :-)
James Flavell <[EMAIL PROTECTED]> wrote:
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
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
