Who is in SQL?

Who is in SQL? 

SQL Server Management Studio >> New Query >> exec sp_who2

 

This will list the users logged into specific databases, especially useful if you need to force kill the sessions. 

New Query >> Kill 'spid' 

eg. Kill 11
 Andy

Turn On Trace Flag 4616 Dynamics NAV

Turn On Trace Flag 4616 Dynamics NAV

SQL Server Mangement Studio >> New Query >> master

DBCC TRACEON(4616,-1) 

Andy

Inventory Valuation - Slow Report FIX (NAV 2009/R2)

Inventory Valuation - Slow Report FIX


Microsoft released a hotfix for the Inventory Valuation report 1001 for NAV 2009 / R2 to decrease the length of time the report takes to run. This is especially important for big databases. 

Hope this helps! 

Download


Andy 

Departments Menu Glitch - NAV 2009 / R2

Departments Menu Glitch - Assign Users 

In Navision 2009 / R2 (Classic) you are able to hide departments from your users, however somtimes this can glitch. I've witnessed this issue a few times whereby the you disable / enable a department for a user but nothing happens.

The quick fix is to delete the user completely from NAV.

Tools >> Security >> Windows/Database Logins >> Copy all the permissions >> Delete the User >> Synchronize >> Re-Add the user >> Paste the logins back in >> Synchronize.

As to why this happens, I have no idea. I think the 'User Menu Level' gets corrupted.

 

 

Delete All Users from NAV 2015

Delete All Users from NAV 2015 - SQL

Note: This same script can be used on NAV 2013/NAV 2013 R2

Sometimes we will need to delete all of our users from a NAV 2015 database as we may inadvertantly lock ourselves out or experiences glitches with user accounts. A quick way to delete all users from NAV 2015 is to do the following: 

1. Open SQL Server Management Studio. 

2. New Query (select the database we want to remove all the users from). 

3. Use the query below >> Hit Execute

delete
from
[dbo].[User]
delete
from
[dbo].[Access Control]
delete
from
[dbo].[User Property]

delete
from
[dbo].[Page Data Personalization]
delete from
[dbo].[User Default Style Sheet]
delete from
[dbo].[User Metadata]
delete from
[dbo].[User Personalization]

NAS Manual Install

NAS Service Install

(NAV Application Server)

"C:\Program Files (x86)\Microsoft Dynamics NAV\60\Application Server\nassql.exe" appservername="Application Server", NETTYPE=TCP, servername="SQL-SERVER", database="Cronus 2009 R2", company="CRONUS Ltd.", nettype=tcp, startupparameter="JOBQUEUE", objectcache=40000, installasservice

The configuration for this can be ammended in the registry if you dont have the MMC snap in installed. 

HKEY_LOCAL_MACHINE/SYSTEM/CurrentConotrolSet/Services

Invalid Page Number: NAV 2009

Error Message: Invalid Page Number

When attempting to click on the Posted Invoices option, in the Sales & Marketing navigation pane, I am meet with the below error.

“Invalid Page Number (8) for the tab control names “Control1”. (InPage was set to 8 on the CheckBox “Control1000000091”).

This is a relatively common error that occurs when there are certain sections (in this case the Posted Invoices) where the Multi-language settings are not set-up correctly.

To fix this issue and stop the error message from appearing simply click on Tools >> Language.

This will open the window below. From here, select your preferred language (in this case English United Kingdom).

No I am able to select and open the Posted Purchase Invoices.

NAV 2013 R2: The requested record cannot be located (Save View As...)

When using Navision 2013 R2 it is possible that certain Role Centres will display the error below when clicking the Notifications displayed on the homepage.

The reason for this issue is that the notifications refer to posted information. Therefore, this information is not available to view via the notifications box.

In this example we are trying to view a posted invoice and we are logged into a Procurement Role Tailored Client; although we aren't able to view the posted invoice by clicking on the notification, we are still able to go to Departments > Finance > History > Posted Invoices. From here we can view the invoice for which our notification appeared.

As it is not possible to navigate to this view from the notifications pane; we can instead click on Posted Invoices header and select Save View As...

This will display the options below:

This allows us to personalise the Role Centre so that, from the home page, I am able to navigate to Posted Invoices.

The Save View function allows users to personalise their homepage to ensure that information that they will need to regularly access is readily available to them. In addition it is also possible to save various views with filters applied.

How to: Delete Companies NAV 2013 R2

Firstly; we recommend that you make a backup before you delete the company. This can be stored as a read only file and even zipped in order to save space.

In addition to this, before deleting the Company, it is very important that you ensure you are the only user who has access to the company.

To make sure that you are the only user who has access to the company

1.       In the Microsoft Dynamics NAV Development Environment, on the File menu, choose Database, and then choose Alter.

2.       Choose the Options tab, select the Single User check box, and then choose the OK button.

To delete a company in Microsoft Dynamics NAV Windows client

1.       In the Microsoft Dynamics NAV Windows client, open a different company.

2.       In the Search box, enter Companies, and then choose the related link.

3.       In the Companies window, choose the company that you want to delete, and then, on the Home tab, in the Manage group, choose Delete.

4.       Confirm that you want to delete the company (CRONUS UK 2).

NB: This deletes the company, this action cannot be undone.

How to: Create a New Company NAV 2013 R2

How to: Create a Company NAV 2013 R2

To create a company in Microsoft Dynamics NAV Windows client or Microsoft Dynamics NAV Web client

1.       In Microsoft Dynamics NAV, in the Search box, enter Companies, and then choose the related link.

2.       On the Home tab, in the Manage group, choose Edit List.

You can create a new company, or you can create a copy of an existing company. When you create a new company, data is not included.

When you create a copy, the business data is copied to the new company.

a.      To create a new company, choose an empty row, and then, in the Company Name field, enter the name of the new company.

The company name can have a maximum of 30 characters. If the database collation is case-sensitive, you can have one company called COMPANY and another called Company. However, is the database is case-insensitive, you cannot create companies with names that differ only by case.

b.      To create a copy of an existing company, choose a company, and then, on the Home tab, in the New group, choose Copy.

Then, in the Copy Company window, in the Company Name field, enter the name of the new company.

Choose the OK button to create the company.

When you create the company name, remember that it will be written at the top of various reports. Therefore, write it exactly as you want it to appear.

You can create as many companies as your license allows for.