Compiling Objects.

You cannot I'm afraid. Not directly.

But there is a command line option available in finsql.exe. You can leverage it, by building in NAV a command firing prepared finsql.exe with command line parameters forcing compilation iof all (or selected) objects

May be this can be helpful

https://blogs.msdn.microsoft.com/nav/2014/11/27/how-to-compile-a-database-twice-as-fast-or-faster/

Seemab07 wrote: »

Actually i want on action button from RTC as i click on button the table should be compiled.

It is a very strange request in my opinion. What sort of problems are you trying to solve? What is the root cause for the request to letting someone to compile a table from the client UI? Bear in mind that a table compilation may have quite dramatic effect on other users, thet may be forced to restart their sessions.

Seemab07 wrote: »

I am facing the same problem as earlier, My navision get closed when i select the variant code in production order line

and certain table compilation helps? For how long then?

What is changing in the database, object-wise, within the 1-2 day time?

Somethinng must have changed in your system if it used to work and then after some time it stopped, and recompilation helps wit the issue. Question is what and how.

Do you restart the NST in the meantime? Is the failure related in any way to the SQL or NST service restarts?