SQL Server 2012 Requirements for FASTFIRSTROW
Previous to Microsoft SQL Server 2012, the database supported an internal function called
FASTFIRSTROW, which by default is used by JD Edwards EnterpriseOne. However, that
functionality is no longer supported in SQL Server 2012. Therefore, users running SQL
Server 2012 must manually change the jde.ini
file settings on their
database server to disable this functionality. Otherwise, you cannot delete any object
or perform certain database specific operations.
It is recommended that you use Server Manager to verify the following setting in the
jde.ini
file on your Enterprise Server:
[DB SYSTEM SETTINGS] FASTFIRSTROW = N