How to delete orphaned data remained from deleted company?

In AX 2009 it may happen that you delete a company but data related to this company remain in the database. You can use this script to delete this data: /* * Code Sample Disclaimer: * Microsoft provides programming examples for illustration only, * without warranty either expressed or implied, including, but not limited to,…

0

How to move Demand Planner database to another server

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 This is because Demand Planner uses fully qualified object names in some…

0

Error ‘Invalid object name #ax_tmp_’

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: [Microsoft][SQL Native Client][SQL Server]Invalid object name ‘#ax_tmp_dmo3_52_0’. This error is caused by collecting…

0

HOWTO: Change collation of AX database?

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 but this won’t help. It is necessary to take in account that also…

1

Práce s container sloupci v T-SQL

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, protože ten již COM connector nepodporuje. Jak tedy přistoupit ke container datům v…

1