AW: [Axapta-Knowledge-Village] Syncronization error - Invalid object name 'INFORMATION_SCHEMA.VIEWS'

[El Caramba]

Hi Preston,   you are right. The views in the master database has not the owner INFORMATION_SCHEMA. I used your sql script to fix the owner.   Now everything works great (the syncronization).   Thank you.    ----Ursprüngliche Nachricht----- Von: Preston A. Larimer [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 3. Dezember 2004 20:06 An: [EMAIL PROTECTED] Betreff: RE: [Axapta-Knowledge-Village] Syncronization error - Invalid object name 'INFORMATION_SCHEMA.VIEWS' Using Enterprise Manager look at the Master database, and the views in it, you should see the following views…                         'SCHEMATA',                         'TABLES',                         'TABLE_CONSTRAINTS',                         'TABLE_PRIVILEGES',                         'COLUMNS',                         'COLUMN_DOMAIN_USAGE',                         'COLUMN_PRIVILEGES',                         'DOMAINS',                         'DOMAIN_CONSTRAINTS',                         'KEY_COLUMN_USAGE',                         'REFERENTIAL_CONSTRAINTS',                         'CHECK_CONSTRAINTS',                         'CONSTRAINT_TABLE_USAGE',                         'CONSTRAINT_COLUMN_USAGE',                         'VIEWS',                         'VIEW_TABLE_USAGE',                         'VIEW_COLUMN_USAGE',                         'ROUTINES',                         'PARAMETERS',                         'ROUTINE_COLUMNS'   All of these views should be owned by INFORMATION_SCHEMA, if they exist and are owned by another account you can get this error, another cause could be the sql server is set up with case sensitivity, but if that was your problem you would most likely have other issues as well..  If the views exist and the owner is just wrong run this script via query analyzer to fix the owner.   --Script Start    use Master             go             exec sp_configure 'allow updates', 1              reconfigure WITH OVERRIDE              go                          Begin Transaction              update sysObjects              set uid = user_id('INFORMATION_SCHEMA')              where name in(                         'SCHEMATA',                         'TABLES',                         'TABLE_CONSTRAINTS',                         'TABLE_PRIVILEGES',                         'COLUMNS',                         'COLUMN_DOMAIN_USAGE',                         'COLUMN_PRIVILEGES',                         'DOMAINS',                         'DOMAIN_CONSTRAINTS',                         'KEY_COLUMN_USAGE',                         'REFERENTIAL_CONSTRAINTS',                         'CHECK_CONSTRAINTS',                         'CONSTRAINT_TABLE_USAGE',                         'CONSTRAINT_COLUMN_USAGE',                         'VIEWS',                         'VIEW_TABLE_USAGE',                         'VIEW_COLUMN_USAGE',                         'ROUTINES',                         'PARAMETERS',                         'ROUTINE_COLUMNS'                         )                             Commit Transaction              go              exec sp_configure 'allow updates', 0              reconfigure WITH OVERRIDE --Script End     -Preston From: El Caramba [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 1:33 PM To: Development-Axapta; Axapta-Knowledge-Village Subject: [Axapta-Knowledge-Village] 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. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.