Browse By Tags

  • Graphical Query Tool executed query

    I have query in the Graphical Query Tool that I'd like to see the actual query executed. How do I see the query in SQL syntax? I want to see the tables and how / what they are joined. Is there a way of doing that?
  • Selecting the collation when installing SQL Server

    Selecting the collation when installing SQL Server

    Welcome to my blog post with some useful information on SQL Server collations The Sage X3 Version 12 Prerequisites for Microsoft® Windows - Microsoft® SQL Server 2016/2017/2019 have recently been updated to include the requirement to use the Latin1_General_BIN2…

  • Sage X3 on Multicore VM

    Dear Experts, we have a strange problem. Sage X3 is allocating only one core for tasks launched from each of the terminals. The system is running in a VM with a 4x4 (4 Physical each with 4 logical cores) configuration. But while creating a big report…

  • How To Replicate Same Folder, Same SQL Database from a Production Server to a Data Recovery Server Automatically

    Hi guys, I need help! My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis Please how can this be achieved? Hoping to get a positive response Thanks

  • Sage X3 V12 on Oracle RDS

    Hi All, I installed the Oracle RDS database instead of MS SQL Server. The database is on diff. server and location and the challenge are – how to config. this in the below screenshots in Sage X3 Console? What are the inputs required to provide here…

*Community Hub is the new name for Sage City