Dynamics User Group
Site
Search
User
Site
Search
User
Dynamics 365 Business Central/NAV User Group
think about IT
Forums
Blogs
Resources
Wikis
Events
Leaderboards
Members
Mentions
Tags
More
Cancel
New
Dynamics 365 Business Central/NAV User Group requires membership for participation - click to join (it's free)
think about IT
Blog by NAV MVP Steven Renders
Home
Subscribe by email
More
Cancel
Posts RSS
Atom
More
Cancel
Monthly archive list
January 2021
(1)
September 2020
(1)
June 2020
(2)
May 2020
(12)
April 2020
(4)
March 2020
(2)
February 2020
(6)
December 2019
(3)
November 2019
(7)
October 2019
(3)
September 2019
(1)
August 2019
(1)
July 2019
(8)
June 2019
(2)
May 2019
(4)
April 2019
(4)
March 2019
(4)
February 2019
(8)
January 2019
(14)
December 2018
(11)
November 2018
(16)
October 2018
(8)
September 2018
(10)
August 2018
(2)
July 2018
(10)
June 2018
(6)
May 2018
(4)
March 2018
(14)
February 2018
(6)
January 2018
(2)
December 2017
(12)
November 2017
(6)
October 2017
(8)
September 2017
(10)
August 2017
(4)
July 2017
(8)
June 2017
(2)
March 2017
(4)
February 2017
(10)
January 2017
(10)
December 2016
(8)
November 2016
(7)
October 2016
(4)
August 2016
(2)
July 2016
(3)
May 2016
(2)
April 2016
(1)
March 2016
(3)
February 2016
(1)
January 2016
(4)
December 2015
(4)
November 2015
(2)
October 2015
(4)
September 2015
(2)
August 2015
(2)
July 2015
(2)
June 2015
(4)
May 2015
(3)
April 2015
(1)
March 2015
(2)
February 2015
(1)
October 2014
(1)
April 2014
(2)
December 2013
(2)
April 2013
(4)
December 2012
(5)
November 2012
(2)
October 2012
(2)
September 2012
(2)
July 2012
(4)
June 2012
(6)
May 2012
(4)
April 2012
(2)
March 2012
(10)
February 2012
(4)
January 2012
(4)
December 2011
(2)
November 2011
(2)
October 2011
(2)
Related
Related Tags
blog
dynamics 365 business central
Dynamics NAV
Dynamics NAV 2009
Dynamics NAV 2013
Dynamics NAV 2016
Dynamics NAV 2017
Dynamics NAV 2018
Dynamics365
Event
Hans Rosling
Homepage
How To
NAV 2009
NAV 2013
NAV 2015
NAV 2016
Power BI
Quick Tip
RDLC
SQL Server
Blog post list
Tags
Subscribe by email
More
Cancel
By date
By view count
By comment count
Descending
Ascending
Earth hour 2012 participate now !
Steven Renders
2012-3-30
Mirror post
Event
blog
494 views
0 comments
over 8 years ago
More
Cancel
Earth hour 2012 participate now !
think about IT
2012-3-30
Mirror post
Event
blog
731 views
0 comments
over 8 years ago
More
Cancel
Standard or Enhanced security in Dynamics NAV?
Steven Renders
The latest weeks I have received a couple of questions from various Dynamics NAV consultants regarding strange SQL errors Dynamics NAV was throwing. A couple of examples: Table XXXXX coes not exist. Cannot find the user ‘$ndo$…….’, because it does not exist or you dont have permission. You do not have permission to execute table XXXXX. You do not have permission to read table XXXXX. … But actually the problem here was not SQL server, it was due to something else. Usually when I get a call with this kind of error I ask some questions to see if it’s not a ‘real’ security issue…
2012-3-19
Mirror post
SQL Server
Dynamics NAV 2009
611 views
0 comments
over 8 years ago
More
Cancel
Standard or Enhanced security in Dynamics NAV?
think about IT
The latest weeks I have received a couple of questions from various Dynamics NAV consultants regarding strange SQL errors Dynamics NAV was throwing. A couple of examples: Table XXXXX coes not exist. Cannot find the user ’$ndo$…….’, because it does not exist or you dont have permission. You do not have permission to execute table XXXXX. You [...]
2012-3-19
Mirror post
NAV 2009
SQL Server
866 views
0 comments
over 8 years ago
More
Cancel
Using a SQL view in a NAV 2009 RDLC Report
Steven Renders
What if a user asks: Could you create a report showing the inventory by Item, but in all of our companies? Sometimes I see the strangest and most exotic constructions or C/AL coding to answer these kinds of questions, when a more simple solution could do the same and better. In the ‘old’ days there was only the native database (.fdb) and when you wanted to display information in a form or report coming from multiple companies using standard C/AL then there was the CHANGECOMPANY function and that was about it. Via OCX and Automation you could also use ADO (or something similar) to query…
2012-3-13
Mirror post
RDLC
blog
How To
Dynamics NAV 2009
577 views
0 comments
over 8 years ago
More
Cancel
Using a SQL view in a NAV 2009 RDLC Report
think about IT
What if a user asks: Could you create a report showing the inventory by Item, but in all of our companies? Sometimes I see the strangest and most exotic constructions or C/AL coding to answer these kinds of questions, when a more simple solution could do the same and better. In the ‘old’ days there [...]
2012-3-13
Mirror post
RDLC
NAV 2009
blog
How To
631 views
0 comments
over 8 years ago
More
Cancel
Sql Server 2012 Launched !
Steven Renders
I’m learning about #SQL2012 by watching video sessions at the #SQLServer 2012 Virtual Launch Event: http://www.sqlserverlaunch.com ! This whitepaper provides an overview of the new features, benefits, and functionality in Microsoft SQL Server 2012: SQL Server 2012 What’s New Whitepaper
2012-3-10
Mirror post
blog
SQL Server
391 views
0 comments
over 8 years ago
More
Cancel
Sql Server 2012 Launched !
think about IT
I’m learning about #SQL2012 by watching video sessions at the #SQLServer 2012 Virtual Launch Event: http://www.sqlserverlaunch.com ! This whitepaper provides an overview of the new features, benefits, and functionality in Microsoft SQL Server 2012: SQL Server 2012 What’s New Whitepaper
2012-3-10
Mirror post
blog
SQL Server
661 views
0 comments
over 8 years ago
More
Cancel
NAV 2009 Field Groups (DropDown) and the usage of Keys
Steven Renders
Recently I had to change the list of available fields in a DropDown box on a page. As you might already know, a DropDown is a result of a field having a TableRelation . For example, on a Sales Order page there’s a field “ Sell to Customer No. “. This field has a table-relation towards the Customer table and as a result of that on the page there’s a DropDown button displayed in it’s textbox. This is the case for every TableRelation , but by default only 2 columns are displayed in the DropDown . (the Pk and Description or Name ). To add extra the columns you have to design the table to which…
2012-3-6
Mirror post
blog
Dynamics NAV 2009
453 views
0 comments
over 8 years ago
More
Cancel
NAV 2009 Field Groups (DropDown) and the usage of Keys
think about IT
Recently I had to change the list of available fields in a DropDown box on a page. As you might already know, a DropDown is a result of a field having a TableRelation. For example, on a Sales Order page there’s a field “Sell to Customer No.“. This field has a table-relation towards the Customer table and as a [...]
2012-3-6
Mirror post
NAV 2009
blog
785 views
0 comments
over 8 years ago
More
Cancel