Have databasename and company name visible in the development environment

nlenting
nlenting Member Posts: 2
in NAV Tips & Tricks
Is it possible to have both the company and database name visible in the Development environment when a company is selected?
Now the default is the database name is shown, until a company is selected than this is changed into the company name.

I would prefer to always see databasename, to prevent development in the wrong environment.

Thanks in advance,

Regards,

Nick

Answers

  • Jan_Veenendaal
    Jan_Veenendaal Member Posts: 206
    In Company information, you set the System Indicator to 'Company+Database' (and you cann add nice colors too, by selecting an Accent
    Jan Veenendaal
  • nlenting
    nlenting Member Posts: 2
    Hello Jan,

    I need the information in the Development Environment itself, because I'm developing in different databases. So not in the RTC environment.

    Regards,

    Nick
  • Jan_Veenendaal
    Jan_Veenendaal Member Posts: 206
    Sorry, missed that part.

    I'm afraid I do not have a solution for you.
    Jan Veenendaal
  • rmv_RU
    rmv_RU Member Posts: 119
    edited 2016-01-28
    1. Create view using MSSMS
    create view
    [dbo].[sys_ConnectionProperties]
    as
    select
    cast(serverproperty('servername') as varchar(100)) as server_name
    , DB_NAME() as db_name
    @SPID as spid
    , system_USER as [system_user]


    2. Create linked table in Nav.
    Looking for part-time work.
    Nav, T-SQL.

Categories