Options

Have databasename and company name visible in the development environment

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

  • Options
    Jan_VeenendaalJan_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
  • Options
    nlentingnlenting 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
  • Options
    Jan_VeenendaalJan_Veenendaal Member Posts: 206
    Sorry, missed that part.

    I'm afraid I do not have a solution for you.
    Jan Veenendaal
  • Options
    rmv_RUrmv_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.
Sign In or Register to comment.