Monday, December 28, 2015

All Virtual Tables in Microsoft Dynamics NAV 2016

Hi all,
Today I posted All Virtual Tables in Microsoft Dynamics NAV 2016,

Table No.
Table Name
2000000001
Object
2000000007
Date
2000000009
Session
2000000020
Drive
2000000022
File
2000000024
Monitor
2000000026
Integer
2000000028
Table Information
2000000029
System Object
2000000038
AllObj
2000000039
Printer
2000000040
License Information
2000000041
Field
2000000042
OLE Control
2000000043
License Permission
2000000044
Permission Range
2000000045
Windows Language
2000000046
Automation Server
2000000047
Server
2000000048
Database
2000000049
Code Coverage
2000000055
SID - Account ID
2000000058
AllObjWithCaption
2000000063
Key
2000000070
Error List
2000000101
Debugger Call Stack
2000000102
Debugger Variable
2000000103
Debugger Watch Value
2000000135
Table Synch. Setup
2000000136
Table Metadata
2000000137
CodeUnit Metadata
2000000138
Page Metadata
2000000139
Report Metadata
2000000140
Event Subscription
2000000141
Table Relations Metadata
2000000164
Time Zone
2000000167
Aggregate Permission Set


Thursday, December 24, 2015

Change SA Password in SQL Server Using TSQL Query

-- Change SA Password in SQL Server Using TSQL Query

USE master
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewSAPassword'
GO
-- F5
-- Run this query in SQL Server.
-- NewSAPassword is your new password, you can give another password also instead of
-- NewSAPassword.

-- You might be receive the below mentioned error message as the password specified does
-- not meet windows policy requirements because it is not complex enough.

-- Error Message
-- Msg 15118, Level 16, State 1, Line 1
-- Password validation failed. The password does not meet Windows policy requirements
-- because it is not complex enough.

-- It is always a best practice to set a complex password for an SA (System
-- Administrative Account) in SQL Server to avoid unauthorized access.
-- If you still want to set a simple password for an SA account in SQL Server which is
-- not recommended; then you add CHECK_POLICY = OFF clause to the above query.

USE master
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewSAPassword', CHECK_POLICY = OFF
GO
--F5
-- There may be a scenario that once you try logging in to SQL Server using SA Password
-- you get the below mentioned error.

-- Error Message
-- Login failed for user 'sa'. Reason: The account is disabled. (Microsoft SQL Server,
-- Error: 18470)

-- Enable SA Account in SQL Server
-- In such a scenario you need to go ahead and run the below TSQL code to enable SA
-- account in SQL Server.

USE master
GO
ALTER LOGIN [sa] ENABLE

Tuesday, December 1, 2015

Making a Customize Reports Available From Search in the Windows Client MS Dynamics NAV 2015 (or) 2016

Hi all,
Today I posted an article that have some different type of requirement, where some users want to search his customize Reports in Search Field on Windows Client.

About This Article:
The Microsoft Dynamics NAV Windows client includes a Search box that lets users find pages and reports based on the objects name. The search feature finds only pages and reports that can be accessed from the navigation pane, which includes the Home button, Activity buttons, and Departments. If you want to make a Customize reports available from the Search box, then you have to follow the bellow procedures.
Step-1:           Open the Development Environment 2015 (or) 2016 with your Database and then open Object Designer. And Then Select MenuSuite and Click New After that select
Dept – partner (or) Dept – Company and then click on OK Button.
Now Right Click on any Menus from Navigation pane Designer and then click Create Menu...
See the bellow screenshot






Step-2:           After clicked on Create Menu… A “Create Menu” Form will display. Now Fill the Form and click on OK button.
                        See the bellow Screenshot.


Once you created a menu then your created menu is available on Navigation Pane Designer.
Step-3: Now select your menu and then go to [Empty Menu] and then Right Click on [Empty Menu] and select             Create Item…
            [See the bellow screenshot for better understanding].

After Clicked on Create Item… A Create Item… Form will display. Now fill the form and then click on OK Button.
[See the bellow screenshot for better understanding].


After Clicked on Ok Button your Reports will appear on your Menus.
Now Close the Navigation Pane Designer. And Save the Menu Suite.
[See the bellow screenshot for better understanding].






References: MSDN






Popular Posts