• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

sql server

  1. J

    SQL Server Timeout Settings

    Hello All, We are experiencing a lot of locking on our 9.2 system. In looking for answers, I found a post on the List discussing locking. One reply referenced time out settings. It isn't clear if they are referring to the settings on the HTML server or the enterprise server. I don't seem...
  2. X

    How to connect tables from SQL server to Oracle database

    Hi All, We have this issue. We have JDE E920 on Oracle database running on AIX and need to make select to some tables on SQL server. My idea is to make a DB view and fake E1 table. But I don´t know, how to make connection to SQL server from Oracle database... Thanks for help. Petr
  3. M

    JDE Database Column Definitions Change in 9.2

    We are migration JDE 8 (AS400) to JDE 9.2 (SQL Server). We noticed a lot of database column definitions are now float instead of integer/numeric. For example, AN8 used to be numeric(8,0) in AS400 but become float in SQL server. We would like to make those numeric/integer columns as it is...
  4. C

    E1 archiving using MS SQL Table partitioning

    Hello All, Wanted to get feedback, if anyone using Microsoft SQL server 2008R2 successfully implemented its table partitioning feature for E1 tables ? We are considering it versus Arctools. The concern we have with Arctools that it involves business analysts to clean up the data and address...