Browse by Tags

• Administration
• Demand Planner
• How To

How to move Demand Planner database to another server
15 October 09 01:36 PM | czdaxsup | 0 Comments   

Sometimes you need to move your existing Demand Planner database to another server. If you do this just using backup/restore, you will run into the issue while synchronizing the Demand Planner. The error you get is: Could not find ‘server name’ in sys.sysservers Read More...

Filed under: SQL, Demand Planner

Error ‘Invalid object name #ax_tmp_’
07 September 09 04:43 PM | czdaxsup | 0 Comments   

You may see similar error while posting ledger journal: Posting - Journal Journal: 000004_061 Voucher: 8004_062 Cannot select a record in (). The SQL database has issued an error. The journal is not posted and the update is canceled. SQL error description: Read More...

Filed under: SQL

HOWTO: Change collation of AX database?
06 January 09 10:29 AM | czdaxsup | 1 Comments   

AX databases are by default created with the same collation as your SQL Server has. But time to time you might need the database to have different collation. Maybe you think you can just execute ALTER DATABASE statement to change database's collation Read More...

Filed under: SQL, How To

Is it possible to change schema for tables in database for AX 4.0 and 2009 in SQL Server 2005?
09 December 08 04:41 PM | czdaxsup | 1 Comments   

By default all tables in AX 4.0 and 2009 databases are stored in dbo schema in SQL Server 2005. But what if we need to change this schema. Is it possible to change it? The answer is No as the method xSession::getDbSchema() always returns DBO .  As Read More...

Filed under: SQL, Administration

Práce s container sloupci v T-SQL
30 July 08 01:15 PM | czdaxsup | 1 Comments   

Někdy je nutné přistupovat ke container datům v AX z uložené procedury přimo v T-SQL. Bohužel, není možné pro tento přístup využít Business Connector, proto se musíme spokojit pouze s COM connectorem. Z tohoto důvodu nelze tento přistup využít v AX 2009, Read More...

Filed under: SQL