Hi Eric,

It's good to have you here. I'm looking forward to a lot of interesting blog entries from you....

Hey Eric, great to see you have started blogging. If you need any help about how to administer the CS blogs, just let us know.

Hey great post. This Araxis looks great.

I use the developers toolkit for the same task. I compare the objects of a client database with the standard one that comes with the clients version.

I've been using Araxis for 5 years now and it's a great tool.  But I can see I'm not such a heavy user as you. In general I always use Per Mogensen's MergeTool for a full merge and compare in connection with upgrades. It's using a three tier model, where you have the old base, the new base and the modified version of the customer. It's basically the same model as the NAV Developers Toolkit, but that's not so strange, as they simply copied his mergetool (he developed it when he used to work for Navision) and used it as the base for the Developers Toolkit. They even copied the errors that used to be in the Mergetool! But what I like with the Mergetool is that it's giving you the semi-automatic merge, where it's basically merging most of your objects automatically, and you only have to deal about the ones with bigger conflicts.

Araxis I usually use if I only have a few objects I need to compare, and with the three column view you can actually still do some nice manual merges.

Hey Waldo, are you a NAV MVP or an Axarix MVP?

Great post!

I like the drilldown, I might just give Araxis a try. Can I buy shares somewhere first though?

I don't think you can by shares now:

"Araxis Ltd is based in the Isle of Man, British Isles, and is a privately held company. Araxis is entirely self-funding and self-sustaining"...

But if one could, I think I would have bought some a few years ago!

Since I don't normally do the actual work of merging, but just need to see what has been done before and after, I think for me this Araxis look ideal.

Good! Even for long term NAV consultants, this spreadsheet is a must for trouble shooting permission problems.

Very good...  Especially the part about getting older versions to run!

Now all I have to do is install Vista. :-)

Excellent, this should help a lot of people.

Very valuable...

Good work. This information it’s easy to find it out than partnersource.

Good work! MS should do the same!

The 4616 traceflag needs to be set for version 5.0 running on SQL2005 database even on XP.

I tried setting it as described in this article and it did not work.

I did a Google on this and found that a - sign is needed before the T. So Startup Parameter should look something like this:

-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T4616

i.e. add ;-T4616 to the end of the existing startup parameter.

Just a shame you can't lookup the mbs.microsoft links without a special login!

I use a simple economics argument to convince customers.

1.  They're most likely buying a server that will support 64 bit

2.  The cost of 32 or 64 bit software (Windows & SQL) is the same.

3.  A 32 bit standard Windows/SQL install will support 2-3 GB of memory

4.  A 64 bit standard Windows/SQL install will support 32 GB of memory.

5.  Adding memory to the 32 bit system will require an upgrade to enterprise editions of both Windows & SQL.  Even with discounts this can be in the $10,000 + range plus memory

6.  Adding memory to the 64 bit system means just buying the memory.

Hey Eric, great blog. I had thought about going to the WPC, but by the time I decided to go, it was sold out, so its great to get all this information from you.

I totally agree about Upgrades, and although the concept has a way to go, they are going in the right direction this time.

By the way, I know that people don't often reply to Blogs, but a lot of people read them. For example your blog on NAV  on Vista has about 1,200 link backs, coming from google searches, blogger.com, answers.com,

Oh and here is a cool one, someone searched on google.jp and then read your blog in Japanese.

http://translate.google.com/translate?hl=ja&sl=en&u=http://dynamicsuser.net/blogs/waldo/archive/2007/05/28/dynamics-nav-on-vista.aspx&sa=x&oi=translate&resnum=2&ct=result&prev=/search?q=nssdk&start=20&num=20&hl=ja&newwindow=1&rlz=1t4gglj_enjp218jp218&sa=n

Anyway keep up the great work, a real lot of people are reading your Blogs.

Hi Eric,

fantastic report. I don't get chance to go to a lot of conferences (being stuck in NZ) and it's great to find out what's going on. I really appreciate your efforts in blogging.

Nice one - keep 'em coming!

Hey Waldo, did they say when the new screen saver was going to be launched?

Does the sharepoint portal webpart work with all NAV objects "as is" or do you need to build objects like with the current Employee Portal?

Interesting stuff. Thanks!

To confirm what Gaspode wrote: the actual parameter needed is ;-T4616

(; is the separator from the previous parameter)

Thanks waldo for the great posts here.

That would be very good, but it would also be needed to define globals/locals as that datatype. Or for the moment to define a global/local AS Item.Description.

So when the description of the item changes, all globals/locals based on it change. This is something I had with Progress and I do miss it a lot in Navision.

Good trick :)

Hmm good idea, much easier than putting an icon on every date field in a form, AND its Very Navision like using the ? mark.

Hi Waldo. Yes it would be great. I worked on XAL and then Axapta for a few years before starting on NAV and there are quite a few things that Axapta did much better (for the programmers at least.) I am hoping that the NAV 5.1 and later versions will start to address this. Some things that I miss:

Layers that allow me to easily identify changes and roll them back. Where used in the IDE as opposed to a Developer's toolkit. Fields that do not thow an error if you try to assign a string that is too big. Error messages that get stored up and displayed in an info log. The ability to execute SQL code directly in the database. The list goes on and on...

Hey Eric, nicely written, I am sure its not just you two that didn't know about Index Hinting, so i think this blog will help a lot of people.

Thanks for sharing this.

By the way, if you have problems with SQL using the wrong key in a specific case (e.g., say a form with lots of records), have you tried creating a NEW key specifically for that situation and sorting the form on that, then apply the Hint just to that new key, so that the hinting will not affect other areas of code?

You can't create double keys of course, so what I normally do is add a new boolean field to the table, then create a new key including that field, and then filter SETRANGE(MyNewField,FALSE,TRUE);

Please let me know the results.

The setrange is not nesesairy because index hint only uses the setcurrentkey.

Yes of course you are right.

Its an old trick I used to use in flow fields to force Navision to pick the key I wanted it to use instead of letting it pick the first one it finds.

Since not everyone have access to partnersource, then I'll recommend you to just download it from the download section:

dynamicsuser.net/.../entry90461.aspx

and

dynamicsuser.net/.../entry90460.aspx

I guess its not NDA anymore I see than Sean has posted some other videos also on You Tube.

That is funny! I FEEL GRRRRRRRREAT!!!!!

Cool!

I cannot install the fix. I get error "the rollup fix cannont be installed by Windows Installer service because the programm that should be updated cannot be found or the fix is not for this version of the programm.... blabla!

While I was there I saw some Summit Vids - Perhaps I need to find my way to one of these events

For sure Harry,

if you only get a chance to make one event, then Summit is the one to be at.

That summit video there was made at the party we had at the Museum of Flight, which was a great night out.

This is very good. But the question I remember always hearing is: What's in it for me?

See my comment to Waldo's previous blog. Remember you're dealing with financial systems people.  They understand things in terms of "what will it cost me"

dynamicsuser.net/.../sql-server-x64-vs-x86.aspx

IMHO indexhinting will not do the trick for one simple reason: SetCurrentKey is only significant for sorting and not for selection. The index to use therefor does not depend on the active key but on the fields on which is filtered.

The indexhint option actually gets "in the way" when there are 2 routes to the same screen, i.e. Customer Ledger Entry screen can be reached through the Navigate functionality (where the filter will be on "Document No.") and from the Customer form (where the filter will be on "Customer No."). The resulting screen has the SetCurrentKey set to "Customer No.", "Posting Date" so for the "Document No." route with index hinting to the Customer No. index will still result in a freeze.....

And still, users are allowed and will use the function to change the Sorting Order in this screen (effectively changing SetCurrentKey) with similar performance impact.

Thanks, I look forward to see the "what's changed" list...

Well Mark actually also posted it to his own blog here:

dynamicsuser.net/.../update-6-for-navision-4-0-sp3-be-careful.aspx

One thing is for sure, if it was not for Arhontis's posting I would have had a really bad weekend.

The ;-T4616 solved my problem.

You'll be up a creek whenever an urgent medical bill or emergency spring up, and your payday is still far out. If an overnight $500 personal loan can help, ...<a href=abaco.ya.com/.../index.html>no fax payday cash advance</a>

I changed the screenshot to the ";-T 4616" ... .

You should update this blog with the new updates!

Review: One of the discussed new features in update 6 is the fact that the new client (build 24143),

Thanks for the elaborate article Eric, very useful and informative

Thanks for information, this probably will save me from a lot of work in future

Check this info: blogs.msdn.com/.../index-hinting-in-platform-update-for-microsoft-dynamics-nav-4-0-sp3-kb940718.aspx

you said that it accumulates previous hotfixes. does that include KB931841, KB933727, KB936602 and KB938138?

So correct me if i'm wrong: if we update to this version, to preserve exact same behaviour as previous versions, we have to

INSERT INTO [$ndo$dbconfig] VALUES

('IndexHint=No’)

on each installation. Correct?

It would be great if those sessions could be recorded and made available for download.

Ok, I will do my best.

Basically Microsoft at EVERY office have the technology setup to create and record live meetings. This wont be an issue of technology, but one of IP. Basically do they want to share the information.

If the event is sponsored by Dynamics, then I would guess they would want the information shared. If its MSDN paying the bill, then its a different issue. They would most likely only want it shared through MSDN or TechNET. Which sounds pretty fair to me. In that case they can publish it through the MSDN secure downloads section, and make it subject to MSDN NDA which should cover all bases.

Of course ideal would for this information to be made public.

Hehe! Somehow with my almost 20 years in the industry (17 with Navision) I sort of have heard this story before! Incompetense! But you not only find this with Microsoft, but in general with most companies in the industry! It's sad...

But to you entry about the runtime license. What should actually be the advantage of the runtime license over the normal licenses?

Ok, good reason, but by how much? And aren't there any other downsides than the fact you can only run one database? And what about the default databases (master, mdbs etc)?

Ok! I'm basically asking not so much for the reason of Dynamics - more because I'm currently running this website on a SQL Server workgroup edition, and was interesting if it was better to change this with a runtime version!

Ok :(

Hey get them to see if they can contact the MSDN or TechNET people, since they are the experts in that area.

HeHe

The runtime license is a fully functonal copy of SQL.  The only difference is the legally allowed use.  You are restricted to running only the application with which it was supplied.

With publicly accessible SQL servers (i.e. Websites) the only valid license is a processor license.  Microsoft requires this because you cannot control the number of people connecting to the system.  Also with processor licensing all Microsoft software, on the server, must use processor licensing.  That mean both Windows Server and SQL.

This can be an issue for Navision sites that expose access to customers via websites.

Thank you. Very helpful. It would have been nice also to have the release dates in the list.

Very useful list! Many thanks to you.

I have a suggestion too:

Could you make the Major Release Version be a hyperlink to the download page in PartnerSource?

My understanding with the runtime license is you can't use external programs to access the database either, if you want to run some web services or something to connect to your database you need the full version

Note:  Microsoft SQL Server 2005 Standard Runtime Edition is sold on a per “NAMED” user basis.  This requires a customer to license a SQL User for each person accessing the system.  The number of SQL users must be equal to or greater than the number of Professional users on the license. Microsoft SQL Server 2005 Standard Runtime Edition is licensed only as a platform to the Navision product. A full SQL license is required to support any third party products including, but not limited to, other Microsoft products not sold on the Navision price list.

I've got build number 22979 but I don't found here (4.0 SP2).

Thanks.

Asier

could it be a private hotfix?

----

I added the links to the major releases.  The older versions didn't have one page with all country versions, so I just picked the NA or W1 version... .

Enjoy!

Pingback from  microsoft &raquo; New Release Date for Microsoft Dynamics NAV 5.1

Pingback from  Xbox &raquo; New Release Date for Microsoft Dynamics NAV 5.1

Pingback from  New Release Date for Microsoft Dynamics NAV 5.1

Not really a surprise. But it's "nice" to see it on writting. Changing the version to 6.0 really does make sense.

But who want to bet that we don't see it until 2009?

Version 6.0 it’s almost a completed redesign of Navision. So it’s natural that MS is trying to achieve a solid product and it takes time.

Erik I also bet in 2009...

I am not betting on anything, but I am not expecting anything in 2008.

Well we need W1, then we need Localizations, then we need six months before we see the Upgrade Took kits, so...

Lets get back to selling 5.00

I think using sp_create_plan_guide with OPTION (RECOMPILE) may be the best solution.

SQL don't select the right index because of plan cache and/or OPTION (FAST xx).

In sql2005 the recompile is more selective than in sql200 and that may be one of the reasons for this problem.

Using Index Hints will forse SQL to use ineffective index.

In my NAV 4.03 running sql2005 I have found 18 selects with bad performance because of wrong index. After insert of selects in sp_create_plan_guide performance is fine.

I this way you keep recompile on a very low level.

Did you see the post at dynamicsuser.net

Pingback from  Microsoft?? SQL Server??? Reporting Services and Style Sheets &#8230;

Hey Eric, thanks for this, pity we cant have this in all countries, but at lest with your Blogs we get some of it.

Keep up the great work.

Hi Waldo, thanks for the update. Really nice for the ones that couldn't make it to the conference. Some people work, you know ...

Regarding the sure step methodology:

Sure Step does not oblige to implement full blown methodology as it provides guidance for all types of projects in all types of companies. That means that it provides guidance for a large complex project in a large company as well as a simple project in a small company.

The tools and the approach of the project manager in both scenarios will be necessarily different.

Except for that sure step is providing a lot guidance and tools that are accepted by all standard project management methodologies (prince2, PMI, ...). These tools are at disposal of the project manager when he thinks he needs them.

It is my personal opnion that if you want to implement Sure Step you need to be familiar with standard project management techniques (check my blog regarding a number of these basic techniques. If you master these techniques, sure step will not only be a nice tool. Only then it will be the key for your project success! If people don't master these techniques, sure step will only document their failure.

Good news is: Plataan offers not only sure step training (in 2 formulas: overview and in detail) but also standard project management training.

Cheers, Vincent - Dynamics MCT

PS: keep on updating us through your blog about Convergence. Super!

Thanks for the update, Vincent.  I know there is a lot of Sure Step knowledge with you ... .

Thanks for that info... :-)

A man is trying a very unusual way to propose to his girlfriend. He wants people to forward an email to as many people as possible and he hopes that it will eventually get to his girlfriend. Details here: www.proposal-to-mary.com

Here is what he wants people to send by email:

You could help me a lot to spread my proposal to Mary – it is important that it is distributed as widely as possible so that it eventually reaches Mary. If you would like to support my proposal to Mary, please send the following text by email to a lot of people :-)

------------- SNIP (email text end) ---------------

WHEN YOU RECEIVE THIS, PLEASE HELP TO DISTRIBUTE IT TO OTHER PEOPLE!

For a long time I have tried to find a special way to propose marriage to my girlfriend Mary, whom I know for five years now. I wanted it very special, romantic and memorable, something our grandchildren would still remember.

And here is my idea: I will send out the proposal to Mary to 50 complete strangers, people I don't know - hoping, that they will forward my proposal to as many people as possible, which in turn forward it etc. And some day, I hope, it will reach Mary, after it has travelled a very long way. I know, it will take a long time and I am quite nervous…

From the poem MY Mary will know immediately that the proposal is for her.

I have created a homepage ( www.proposal-to-mary.com ) where you can find the current status of my quest. You can use the homepage to check if the proposal has already reached Mary (in that case it is not necessary anymore to forward the mail).

Once the proposal has reached Mary, I will put a note on these pages. Also I will publish there how many people have read the proposal so that everybody can see how far it has spread and that it is getting closer to Mary.

And of course you will find there what I am waiting for most: Mary's answer! I can't tell you, how nervous I am… Will she accept my proposal? Will she like the unusual way how she got it, through the hands of thousands of messengers all over the world?

Please cross your fingers for me! And please - help me by sending the mail to as many people as possible, to help it spread, so that it eventually reaches Mary.

And here is my proposal:

Mary, please forgive me, as you know English is not my native language. And I am not a poet. But I mean it from my heart.

My angel,

Five years ago, I will always remember the day When fate made us meet, blissful Alaskan moments in May Earth spun around us and a journey began Love, warmth, happiness, enough the years to span.

The longer it lasts the more grows our bond And with 80 still - of you I will be fond Whatever happens, I will stay at your side Through good and bad, together let us stride

No second with you was ever wasted

You are the sweetest I have ever tasted

We have spent so many years - why not a life?

Mary, will you marry me - and become my wife?

Mary, if you have received that and have recognized me, then give me a sign so that I can continue with the romantic part of my proposal…

------------- SNIP (email text end) ---------------

We were close to rolloing out our fundraising group on V4 when our partner tested and upgraded us to V5.  We are now ready to cancel the rollout because of poor performance.  MS said they are working on the speed issue but could not give me a date.

That's what I call cross-selling. Anyway: Thanks for the interesting blog.

I was really happy with the new format of this presentation. Last year it was very technical, and in one hour you just can't do that. This years presentation was a great overview, and the sort of thing that lets you know all the areas you need to look at, and some starting points of where to go next. Think of it as "Hello World" for people implementing NAV on SQL.

Me too.

Last year it was all new but it seems that the basic knowledge is generaly available know.

It is up to methodolgy and partner community now.

I love being part of the SQL Perform community.

Part?  I think you run that community ...

Only in Holland and Belgium :-)

Well, I as a competitor of SQL Perform ;c) found it somewhat annoying that permanently the SQL Perform Tools were mentioned ;c)) ignoring the fact that other magnificent optimization software is availabe, too ;c)))

But seriously: even from a more objective perspective I think it was too much advertisement and less content. I prefer last year's session.

As expected, Agiles started out with some figures about themselves: Australian NAV partner sincs 1993

Pingback from  Techy News  &raquo; Blog Archive   &raquo; Directions Diary - ISV Session - Handapps: Mobile Solutions

Great post! It sounds like Directions is much better than Convergence!

Hello Waldo and others,

I am Mandy Dore from agiles, who presented agileWorkflow yesterday at Directions 2007.

I thought I should let you know that agiles are a Germany company, based in Hamburg. I am orginally from Australia, hence the confusion. :)

Also, the Markant example was not intentially made complicated, but yes you are right, they did have complicated processes that were made simple by the implementation of agilesWorkflow. But Markant is just one example.

It is quite difficult for you to convey all the information from the session into a short blog, so for those who are interested in understanding more, please contact me directly on mandy.dore@agiles.net.

And Waldo, I would love to make you fully convinced, ;) so let's discuss it further together.

Mandy.

Was it Helen who spoke at the session?

Wasn't this a bit strange session title? I mean at what point are anyone migrating from C/SIDE (short for client/server integrated development environment) to SQL. Based on what you described above it sounded more like a session on migrating from the native database to SQL.

Well but still interesting!

Well I think a lot of people are reading it. In fact more than the view number say, as the view number doesn't include those who read it from RSS...

It is. Based on a short description from Mark, it's basically "how to upgrade your C/SIDE database to SQL without losing your client".

Ok, I just ask because I have know Helen Russel of SCS for many years. She's a very nice lady, the owner of SCS...

Nobody like that anyone is getting something before others. And especially in the Dynamics NAV world there has always been a lot of jealousy between the partners. And now after MS introduced the MVP's, then they just point their eyes toward the MVP's instead! The only real difference is that before MS, all the beta programs where secret!

Btw. what is a PAM?

The sessions at Directions sure sounds much better than Convergence! I know they will have it next spring in Paris, but does anyone know when?

Interesting post, and a subject close to my heart - glad to see it's being discussed.  

I think the maintaining of correct object information in Object Designer should also be included in the discussion on standards.  How many times have you seen an object marked as modified, with no version list change and no comments in the Documentation trigger?  

Thanks for that info. Good to know that...

And guess what other event is on that week

As Eric wrote in the previous Blog posting (dynamicsuser.net/.../platform-updates-overview-3-70-b-5-0.aspx):

"It would have been nice also to have the release dates in the list."

Please try to get and publish these dates. Thanks for your affords in advance.

P. S.: Still a very usefull overview! *Thumbs up!*

FYI: There is a new (updated) posting by waldo availible:

dynamicsuser.net/.../platform-updates-overview-3-70-b-5-0-update-1.aspx

Thanks for the blog Waldo!

I really enjoyed presenting and preparing for the event. Thank you for your input.

I noticed that a lot of people just do not know the risks in migrating until their fist project fails.

Good thing that Micheal Nielsen, Kim Ibfelt & Darren Layborn were there and noticed the issue.

It did put a little extra pressure though to have these guys on the first row.

Funny also to see a blog about my own session thinking I was the one who started blogging at TechEd only 18 months ago.

Now I am presenting myself...

What I will do is migrate the slides to a whitepaper and upload to the downloads of our forums.

I'd like to add this one:

4.00 SP3, Update 7, Build 25307, KB943227

As I am working as a freelancer I do not have the rights to view the microsoft knowledgebase. Is it possible to publish this information here.

For those that are also working as freelancer and not being a MVP how do you get the latest information about the Dynamics products?

Greetings, Remco

mbs.microsoft.com/.../KBDisplay.aspx

Here's the link.

Remco, that is the reason Eric posts it. He is getting it because he pays MS a lot of money and shares it for free afterwards.

There is no way to get access to partnersource as a freelancer. If you want an update, contact the partner of the customer you are working for and request it. You should never implement a hotfix anyway without telling the partner.

Hé Mark,

I know the link, but the that doesn't solve my problem. I will try if the partner will give me the extra information. And off course the partner does know that i'm using this hotfix!

Greetings

When I was on the plane to New York a few weeks ago (After Convergence, but before Directions), I wrote

The "Error" bug in CU 1 is known. It is problem of the CU1. Workaround is to call message instead and right after the message call Error(''); It will work as error, message will be showed correctly (but just with the "i" icon instead exclamation).

Thanks Eric! It workes!

Hi Waldo, nice blog-article. I will refer future students to this when explaining when to use the fob and when to use the txt format for objects.

Cheers

Vincent

Microsoft Dynamics MCT

Yes Eric, very useful blog, I am sure it will help a lot of people.

Just to add to this, you can also do this in the normal C/SIDE editor without every having to export anything. Like this:

Find all the objects that have the Optin used.

Open the object, and start to save it.

At the prompt to save Yes/No de-select the object to compile.

(So save the object un-compiled)

Repeat for all objects.

Now go back to the tables with the Options.

Change the option string.

Repeat for all the required tables.

Now select all the objects that are un-compiled.

Hit F11.

Since the objects were saved in text format, its just like using a text editor, in that the integer value is not used.

Yes that's correct. If you export an uncompiled object, then you only export the text. When you compile it you export both the executable object AND the text.

An extra remark for adding an option to an existing list of options:

Not just add it to the end, but add some , before it.

In general I start to use the 20th value for the next option. This way, you leave some space for future standard options.

E.G.

"FIFO,LIFO,Specific,Average,Standard"

becomes

"FIFO,LIFO,Specific,Average,Standard,,,,,,,,,,,,,,,Waldo"

If tomorrow MS decided to do this:

"FIFO,LIFO,Specific,Average,Standard,Some MS Value", you do not need to change the value of option "Waldo" in the database.

Also use this in the option-captions.

The beautiful thing is that the empty option-values are NOT shown between the possible option to choose from.

I wrote the below blog some time ago (right after the session) but I was waiting for te slides to complete

I wrote the below blog some time ago (right after the session) but I was waiting for te slides to complete

I wrote the below blog some time ago (right after the session) but I was waiting for te slides to complete

@ Find statements: Steven said MS is "beginning to" replace the FIND('-') with FINDFIRST where necessary, in their new development and in the code they "review" (that's what I understood).

He DID say that these 2 statements did two different things... :-)

If you need the ppt, I can send it to you (left you a message via "contact").

It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled

It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

Here is your reporter back with more news about the Belgian MSDN/Technet evenings . This time, the topic

Did you see this post at dynamicsuser.net

Indeed, we have such a recording device and I really hope that we'll be able to record all the next sessions. In the near future we should also get a second device so if there are more sessions at the same time, we'll record them all. See you next time.

There is an interesting post over at dynamicsuser.net

Pingback from  Pages tagged "microsoft"

Great stuff! I was actually working on a private NAV-ADO project at the very moment I noticed your post in Google Reader :-) My project might show up in the Mibuso downloads if I get it to work ;-)

Only comments:

* You should mention the risk for SQL-Injections. An evil person with permission to create companies could execute any SQL statement in your database impersonating the service user with this solution.

* You should mention the possibility of using "Integrated Security=SSPI" to use the credentials of the current AD user instead. (Some times it is a better solution, sometime not)

But a yet another great article - keep'em coming :-)

Just wanted to wish y&#39;all happy holidays!!! To cover everyone, here are the greetings in most languages

Recently, I had to do a small project. A client of us wanted to see the global inventory of all its companies

Here is your reporter back with more news about the Belgian MSDN/Technet evenings . This time, the topic

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled

I have two new build Nos

5.0.25581.0 (KB944919) latest one!

5.0.24632.0 (KB936885)

Pingback from  waldo&#8217;s blog  &raquo; Blog Archive   &raquo; Using ADO &amp; Stored Procedures in C/SIDE

Pingback from  waldo&#8217;s blog  &raquo; Blog Archive   &raquo; Merry Christmas &amp; Happy New Year

Pingback from  waldo&#8217;s blog  &raquo; Blog Archive   &raquo; Platform updates overview ??? 3.70.B ??? 5.0 Update 1

You don't need to know any URL if you know the KB No.

Example for KB944919:

mbs.microsoft.com/.../KBDisplay.aspx

Directions EMEA 2008 : http://www.directionsemea.com/

And what about update KB945349 for 4.0 SP3?

Thanks to Natalie, I added two more updates on 5.0. This is the new overview. Released Version Update

Waldo, I think that you have mixed up some info:

KB 945349 (4.0 Update 8) includes two  Build Nos.: 5.0.25653.0 and 4.0.3.25638.

Hence 4.0 Update 8 has to be Build No. 25638 instead of 25653 in your list.

Build 25653 for 5.0 is missing.

:-)

It is not too late ... but still late. I haven&#39;t said a word about Directions EMEA 2008 yet, while

There is an interesting post over at dynamicsuser.net

I am happy to announce Outlook Integration Update for Microsoft Dynamics NAV 5.0 . This update is now

Does anybody know why they changed Codeunit 418, 448, 449.

I couldn't find anything in the whitepaper or website why they changed the objects.

I'm kind of in doubt here. Especially after reading the different KB articles.

With a fresh new SQL 2005 64bit server and NAV 4.0 SP3, which update should we take?

Where can they be downloaded?

This is a very challenging blogpost in my opinion. I see many stories going around on what would be the

Interesting!

Looking forward for article "monitoring your code"

Great Post - Lots think about !!

Does 2.6 support x64?

Well, we are currently using 2.6/2000 and looking to upgrade the server, trying to take advantage of more RAM, but only can with x64

So, given the info above, it looks like AWE as you describe would be our best alternative, right?

To avoid the "NEXT FROM HELL" (this perfectly describes the proble!), my advice is:

If you have a loop and in it you want to change a field, ALWAYS use a second variable. Why do I say this?

1) this rule is easier than "If you have a loop and in it you want to change a field and that field ........."

2) If you don't have the problem, but later some other programmer (or also you) has to change another field in it it can become a "NEXT FROM HELL" and you have to change your code (and most of the times the other programmer doesn't do this!).

Great post.

Clears the fog somewhat ;)

What I miss in general is the behaviour using the MARK functionality as it also is a way of filter data. Sometimes I use MARK instead of a second record to avoid the "NEXT TO HELL" trap.

Interesting post. But what about using any secondary key in a Findset-Loop?

Your results on counting fetches and/or selects would be heavily different. I recommend using a FINDSET only in loops wehre you know that there are less than "500" records in the resultset. If you are using FINDSET with a key different to primary key you will cause many selects. The "select top 501 *" do not create a trigger, so there ist no way to fetch the next records behind 501.

By the way, it's the same damn thing when you are using a FIND(-) in a loop with modifying records. If you do not use locktabe (or findset(true)) you will get many new selects while looping if you use a key different to primary key.

Thanks once again for the extra effort you put in to help the NAV developers of this world. God knows we need all the help we can get.

When is the book "Advanced Dynamics NAV Programming" going to be published?

A very good post! Keep them coming and soon you have material enough for the book!

Actually I also got a question on this I would like to hear your experiences on.

A long time a go I was told that using the MODIFYALL was always a very good option. But how is SQL Server actually treating this command?

I mean if I need to update two fields?

Example 1:

SETRANGE(MyField,'FILTERVALUE);

MODIFYALL(MyOtherField,'NEW VALUE');

MODIFYALL(MyThirdField,'ANOTHER NEW VALUE');

Example 2:

SETRANGE(MyField,'FILTERVALUE);

FINDSET(TRUE);

REPEAT

 MyOtherField := 'NEW VALUE');

 MyThirdField := 'ANOTHER NEW VALUE';

 MODIFY;

UNTIL NEXT=0;

Which example would be better?

And what if ex. we had to call the VALIDATE trigger?

I think example 3 is best:

RESET;

SETCURRENTKEY(...);

SETRANGE(MyField,'FILTERVALUE');

FINDSET(TRUE[,TRUE]);

REPEAT

 recOtherRecord := rec;

 recOtherRecord.MyOtherField := 'NEW VALUE');

 recOtherRecord.MyThirdField := 'ANOTHER NEW VALUE';

 recOtherRecord.VALIDATE(MyFourthField,'YET ANOTHER NEW VALUE');

 recOtherRecord.MODIFY(FALSE); // or (TRUE);

UNTIL NEXT=0;

And if you have a VALIDATE-trigger, it is impossible to use MODIFYALL.

Nice article, it's indeed a smart idea to use the SQL profiler in combination with Client Monitor to find how record set manipulation CAL get spitted out in SQL statements :-)

Best Regards from France,

Tarek Demiati

Freelance Dynamics NAV (Navision) Developer

That's what I say Eric, soon you'll have enough for a small book!

Few new articles about NAV on SQL released by experts: Lars Lohndorf-Larsen article "Record-level locking

Hi Waldo, have you ever done this for a SQL 2005 database? We have some code that worked on SQL 2000 and now get an error saying that the SQL-DMO cannot be used to connect to the server and you must use SQL Server Management Objects (SMO) instead.

Problem

I cannot install the fix. I get error "the rollup fix cannont be installed by Windows Installer service because the programm that should be updated cannot be found or the fix is not for this version of the programm.... blabla!

Solution

First install the client and then install the roll up patch.

Great you keep this up to date Waldo. I always read your Blogs with great interest. However you have misunderstood microsoft's update system.

Updates are a collection of KB's issued as an update. For 5.00 there is only one and that is KB 943858

The other once are hotfixes or stand alone KB's if you will.

You are btw. missing KB 948512 on SQL performance.

Keep up the good work.

Cheers,

Soren

I had this issue at a customer of ours. The error message &quot; Login failed for user &#39;sa&#39; because

I guess the KB is not publich jet, but it is on the way. I just know it because I have the files and KB here for testing and it finally solves some the the crazy performance issues we have been fighting with since the release of 5.0.

hi just a little question for you....can you tell me what does mean h1 cy2008?...sorry may for the ot...thanks a lot bye

I wouldn't say - I still recommend for just adding the options at the end of the string.

The best way is to set it to the End plus about 10 commas.

So not

FIFO,LIFO,Specific,Average,Standard,Waldo

but

FIFO,LIFO,Specific,Average,Standard,,,,,,,,,,,Waldo

The reason is very simple ... merging.

Hi Waldo,

there are at least two new ones:

4.0.3.25709 in KB946247

5.0.25344.0 (only SQL) in KB943581

Refer to mbs.microsoft.com/.../KB__NAV.htm to find perhaps even more.

When you make tables please tell the contents refers to what and please be clear when writing the stuff as some people are not up to your level

Here is the next I-think-up-to-date version of the Service Packs/Updates/hotfixes/Knowledge Base Articles

Any problems with tending to help you? ;-)

As you did not seem to know the page with the latest KB article summary yet, you perhaps don't know this one where I took it from, too:

Hot Topics Navision

mbs.microsoft.com/.../navision

The site looked different until February: there were many KB summaries (for each month back to 2006 or 2007). It is a pitty that MS now has erased all former infos :-/

One word on this blog: WOW!!!!!

Since a few months now, we have been working on a new initiative in Belgium: the Belgian Dynamics Community

Hi,

Please I need someone to help me out urgently.

I have installed SQL Server 2005 and Navision client (sql server option) on my system and I was able to connect to the database, restore data and do all sort.

When I tried connecting from another system, a got an error message cannot find server. I typed the serverpath and name but it still gave me the same thing. Could this be because the systems are in workgroup not domain? Or do I have to set anything on the other systems? (Like the host file when using the native database server). Please help me out

Secondly, I dont know how to bring the stored procedure into SQL, I have already unzipped the xp_ndo.dll file into the binn directory of SQL installation. Can anybody send me the codes on how to do this.

Please, I'll appreciate your urgent response.

Thanking you in anticipation

You can reply back to debby_box@yahoo.co.uk

Hi Waldo,

Just wanted to say thanks again for this post. I am currently going through some issues with NAV 5.0 SQL 2005, etc. which requires applying some of these updates to try and improve performance.

I know that in order to check if I have applied the correct version I can find the build number (Help, About, Double click on the Version No.) and then Google it to find which update it is. The Google link returns this post. Very useful!

but from where can i download it, on microsoft they say that there is an update named KB 931841 but they don't give the link!! on this link : mbs.microsoft.com/.../General.aspx{1A824679-0B9B-4BA7-BF5A-C6EB77FC43B3}&NRORIGINALURL=/partnersource/products/navision/newsevents/news/msdynav40_sp3_officevistacompatb.htm?printpage=false&NRCACHEHINT=Guest&printpage=false&wa=wsignin1.0 ... i ca't find the update ...what can i say "i love microsoft"

Plese help

Thanks!

Recently (last Thursday) I joined the MSDN Evening, organised by Microsoft, to learn more about how to

Actually it's no wonder that you've been found in google ... msdynamics.de is not the only community that links to your blog, quite sure ;-)

On monday, I will be off to Convergence US 2008 in sunny Orlando . I have some mixed feelings about it

Have fun at Convergence and looking forward to your blogs.

Have fun! And say hi to everyone I know.

/Mark

Have a great time Eric.

i for one will be waiting in anticipation for the high quality blogs that you are now famous for at these events.

Sorry that you are there "alone" this year, and good on you for going.

It seems that I will not be able to attend many sessions this year. Too many things to do behind the

Good stuff Eric, keep it coming! Wish I were there.

A simple way how to handle different Company-Names would realy very much apprichiated. The report should be able to let the user select the company and an sp is generating an dynamic select statement. Anyone has an example how to solve?

C#/VB: Many reports do have attributes on wich you can define the value with an expression. Within this expression, you just can use VB. It took me a long time until i recogniced that my C#-Code ist not valid despite of the framework.

Very good blog by the way!

Today, it&#39;s not a NAV day at all. Very few NAV sessions - and actually not one where I&#39;m interested

I like you lively writting style. It's easy to read in one go even bigger posts.

Eric,

great stuff, keep it coming if possible. Its a pity that your "duties" are keeping you from more sessions, as I would love to read more of your blog posts. It sounds like you have your plate full being there alone.

It&#39;s going to be a busy day. Three sessions and quite some work at the booths. I love Michael Rosenorn&#39;s

I would like to know if they are going to change it to web service in 6.0.  That way they can get rid of commerce gateway and don't have to use NAS.

It'll make the setup a lot easier.

Martin Nielander (from the systained engineering team) and Jesper Reabild wanted to give an overview

This session is presented by Michael DeVoe and Robert Miller. They&#39;re both really good, so I expect

This session is driven by Chad Aberlen, one of the Microsoft Escalation Engineers. Most of his expertise

Those tools must be made available on SQL Server, so we can schedule them without having to install the Job Queue. Can you ask while you're there?

I'm willing to think about auto update statistics, I've read a lot of comments saying that it's really not that harmful. However I find the logic flawed to use autostats as well as a routine that manually does it. If auto statistics is so great, then why do we need any tool to update the statistics? Likewise, if you create a tool to update statistics manually, why would you also need to automatically update statistics?

Then I also strongly disagree with having a tool create indexes on SQL Server that don't exist in the NAV table design, I would never recommend that either.

This all sounds very negative, but I am really very happy that they are working on this. It is very good to see though that they are addressing this need, very positive.

[quote user="waldo"]

Keep in mind, if you want to go to the NAV2009 RoleTailored client, you'll have to upgrade to the latest version (5.0 SP1).

[/quote]

This reminds me, I have been trying for about 18 months now to get an answer of whether there will be a Data conversion required for 2009. Have they stated anything yet about that.

@Waldo: If the future is not yet made at this point (Q2), availability of NAV2009 in Q4/2008 is not an option.

PS: Waldo, thanks for the great job keeping us updated!

Pingback from  Neuerungen im Service Pack 1 f&uuml;r Microsoft Dynamics NAV 5? &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

I have some time on the airport to write down some final thoughts of what this Convergence meant to me

Sounds over all like a great event then. I am so glad to hear that it was better than Copenhagen.

I really appreciate reading your blogs, they really do help everyone.

Great work Eric.

Glad you had a good time, but reading your notes I am happy to have staid home altouhg I would have loved to spend some time with Olga to. :)

Excellent series of blogs Eric, thank you very much for taking the time.

Thanks for all the info Eric

Great blog! It's almost as if I'm there, but not really.

Funny, these "Performance Optimization Tools" grow like mushrooms ;c)

Is it also "free-of-charge" - as my "NAV/SQL Performance Toolbox"?

>This sounds cool, but really ... I want to do this from within SQL Server, not from within NAV

>The next tool, SQL Index Defragmentation Tool, works with the sys.dm_db_index_physical_stats DMV. You use this to defragment indexes, which can have a noticeable impact on performance.

I would like to share a solution for doing dynamic index optimization, with the Navision community. It's a stored procedure that does index rebuild online or offline, index reorganization, statistics update, index reorganization and statistics update or nothing based on fragmentation level and LOB existence. It's using sys.dm_db_index_physical_stats just as the SQL Index Defragmentation Tool.

blog.ola.hallengren.com/.../3440068.html

blog.ola.hallengren.com/.../Documentation.html

This reduces the time it takes to do index maintenance considerable. It also reduces the sizes of your transaction log backups during the index maintenance.

The solution has been very thoroughly tested and it has been running on a large Navision installation for about 6 months.

Ola Hallengren

http://ola.hallengren.com

How do you see these tools as compared to the other "tools" available for SQL performance optimization? I am here thinking about the ones from SQL Perform and the other companies specializing in this.

Pingback from  dynamicsuser.net/.../new-release-date-for-microsoft-dynamics-nav-5-1.aspx

As promised, 5.0 SP1 W1 is available for download . Versions W1 (WorldWide), DK (Danish), DE (German

Just a pity they release it just before they take the site down for maintenance. Did anyone manage get it before they took partner source down?

[quote]Our Apologies

From Friday March 28th, 2008 at 6:00pm to Monday, March 31, 2008 at 2:00am CST (GMT -6:00), VOICE, PartnerSource, CustomerSource and Commerce (NBE), CLT systems will be unavailable as they will be down for maintenance. [/quote]

I see the new Microsoft Web site just came on line, so I guess this is why partner source was down. Hopefully we get a new version tomorrow (of partner source I mean).

Pingback from  ServicePack 1 f&uuml;r Microsoft Dynamics NAV 5 verf&uuml;gbar &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

I just couldn&#39;t resist posting these links: The Waldo Ultimatum: www.youtube.com/watch

He doesn't remember who he is because he left his passport in Mexico :) Stay tuned for the sequal 'The Revenge of MexiWaldo'

Not that i have a slow connection but has anyone noticed that it can be quite painful to get into PartnerSource...

It was down all weekend, so all the people (like me) that do all their downloading over the weekend had to catch up on Monday, so it was just under heavy load. It seems to be ticking along nicely now though.

The Waldo Ultimatum is great. Obviously someone with too much time on their hands but definitely fun.

PS I forgot my Passport at Disney after Directions, so you are not the only one. Ended out stranded in NY till they found it. But not anywhere near as much fun as your Mexico story.

Thanks again Waldo. Every time I need to get to the 5.0 SP1 download page, I know the easiest way to get to it is via your blog. Much easier than searching on PartnerSource.

Yesterday, I got the message that my MVP-title has been &quot;renewed&quot;. I must be doing something

Thanks.

Congrat's to and keep those blog's comming...

Keep good work

Congratulations both of you!

And keep the blogs coming!!!!

congratulations !!!!

Well done.

Excellent news Eric, well deserved, congratulations!

Well done Waldo. You fully deserve it.

Cheers, Dave.

Sorry for being a newbie at this, but what do you mean by "Runtime Upgrade to Vista-supported clients"?

I was told today by our Solution Center and have since verified for myself, that NAV 4.0 SP1 seems to work just fine on Windows Vista - so long as you're connecting to a C/SIDE database (if you connect to a SQL database, it bombs out).

Congrats! Keep those blog posts coming!

Congratulation Eric, that was deserved...

Finally found some time to write Part II of this topic. The first part was quite a popular post, if I

Finally found some time to write Part II of this topic. The first part was quite a popular post, if I

There's a reason why some people are MVP's :) another great blog Eric

Thanks for the time you took to provide us with this great info!

Hi Eric,

Congratulations with your updated status.

Another year of blogging. I'm looking forward to your blogs on the EMEA direction sessions you will host ;-)

It has been a while. Not much has changed, just the SP1 is now officially released (but I already added

Yet another great entry in your blog. Just sad this overview isn't available directly on PartnerSource :-(

I would suggest you added some similar links for SQL updates:

support.microsoft.com/.../913089

support.microsoft.com/.../LN

great Blog wWaldo,

i was wondering about the following KB's if they are missing in the summary:

936719

940043

945992

945339

See also:

premier.microsoft.com/default.aspx

The links to the 1.4 and 1.5 updates are to the premier site which not all partners have access to. (At least I don't :-()

However; if you just take one of the other links to PartnerSource you can replace the kb no. and the links works fine.

Have a look at this - you won't believe it:

mbs.microsoft.com/.../KBDisplay.aspx

Nah Waldo,

you're noncompetitive - they do not keep it up to date like you do :-)

Your page is WAY better! More frequent updates. More hotfixes. Links to base versions.

I just noticed that Partnersource now offers a few "public" RSS-feeds, but they are also not up-to-date. Nice work Microsoft :-(

Check it at mbs.microsoft.com/.../rssfeeds

In short: Keep up the good and valuable work Waldo, it is much appreciated :-)

Thanks Waldo, for updating the List. Your List has a better overview!

If found another one for 40SP3:

KB 948302

see KB 931638 for a list of 40 (maybe there are more updates in that list for 4.0XX)

You shouldn't even have thought about stopping with it!

New hotfix update (not included even on the official site):

Build 26410

KB 950920 (not published yet)

Type: Standalone files for client and NAS.

It seems that I&#39;m not going to blog this directions. It&#39;s a bit akward for me, being able to

Pingback from  Kriki&#8217;s blog &raquo; Moving from native C/SIDE to SQL by Mark Brummel

Well he has some big shoes to fill, but I am sure he can reach your standards. I look forward to seeing this.

I hadn&#39;t put this on my blog yet, but people asked me to give a presentation about Hardware on Directions

What format is this presentation in? It contains a lot of xml files but no .ppt or am i missing something?

Great presentation, Waldo.  It's amazing to see all of this information collected in one place.

Can I ask you what your hardware recommendations are for the tempDB?

In this thread (dynamicsuser.net/.../114694.aspx)

David had the idea to put it on its own RAID 1 for large databases.

The format is in powerpoint 2007.  You can download a compatibility pack here:

www.microsoft.com/.../details.aspx

I have got good feedback on your session. It were busy days for me, so I missed the time to say hello to you and thank you ....

I think it's a shame you didn't blog here! I remember from some of the other conferences it has been very interesting to see the different bloggers different views on the same sessions...

And then of cause, I also find it a shame that the users here on http://dynamicsuser.net will not see the blogs from Directions...

I am writing the &quot;final thoughts&quot;-posts because it seems interesting for me to have somebody&#39;s

Pitty that I missed this one. I hope that next year... ;-) but there is so many events and I cannot be everywhere...

oooh, so that's what waldo looks like :p

Great post Eric, we had a great time again.

See you thursday.

I can find some reasons why you were so calm during your presentation:

1) Good preparation.

2) You knew very well what you were talking about. It was not something you learned and just reproduced, but something "you lived"!

I wanted to wait until I received some pictures, but I won&#39;t. I&#39;m a little bit too excited about

Great event and kudos for bringing this together. Let me know you if you in the future need any help from the NAV Core team and I will be happy to help you out.

Seems to be a new 4.0 version out:

4.0.3.26410 (from KB 950920).

Also, the build of NAV 5SP1 is 5.0.26084.0.

Thanks

Daniel

I can't work in Navision 4.0 sp3 with Vista Sp1

In a conference like Direcionts EMEA , I noticed again how interested people can be in sometimes such

Do you have a text file of the object that you could share?

Yes Eric, this is a nice simple and neat solution to a very commonly requested issue.

Thanks for sharing it.

I've already sent a link to this blog to customers :)

Great tip. So simple and yet so useful. It's funny how often the best solutions are the simplest.

Thanks again!

I'll start using it with all my customers from now on!

Hey Waldo! Thanks for the event. Me and the guys (aka Same Same But Different) had great fun playing at the beautiful location! :-)

Keep up the good work!

/Roel

Great tip

The best solutions are simplest - this is really neat and really useful - thanks a lot

Hi Waldo,

There is one more important hotfix for 4.0 - KB 950920, build 26410.

Cheers,

Viktoras

I love this tip and have been playing about with it. I've added a couple of extra features and I'll post something about it when it's done, but I have a question. Is there any way of stopping someone from clicking on the form and pressing ESC which then closes it? Other than setting Close Forms on Esc to No. I tried putting EXIT(FALSE) in the  or putting something in the OnQueryCloseForm() but that is BAAAAD and you can't exit the company or NAV. Any ideas?

Here we go:

Build 4.0.3.26170

mbs.microsoft.com/.../KBDisplay.aspx;en-us;949866">mbs.microsoft.com/.../KBDisplay.aspx

Build 4.0.3.26565

mbs.microsoft.com/.../KBDisplay.aspx$en-us$952355&wa=wsignin1.0

I found one more blog with hotfix information:

blogs.technet.com/gediminb

Hi it's me again. OK so I had a go at doing some things with this idea. If you're interested, take a look at my post on gaspodethewonderdog.blogspot.com/.../where-am-i.html

I did come across a few issues so maybe some of the clever readers of your blog could answer the bits that don't work. Thanks for the inspiration and thanks heaps for posting the idea. Cheers, Dave.

The updates keep on coming ... so we keep updating. If it continues with this tempo, we&#39;ll have quite

Hi Eric,

you should bookmark this one:

mbs.microsoft.com/.../microsoftdynamicsnavsupportnorthamerica.htm

The majority is also useful for non-NAs and represents a great part of the partnersource link list that I have showed you earlier.

Hey thanks Waldo, I was wondering where I should send feedback.

On the 15th of May, we had our first &quot;real&quot; information evening organised by the Belgian Dynamics

Hi Waldo,

while i was checking the updates that i had to download for the 5.0 release i noticed something in the list. I consider the Build No. to be leading in the above list. KB943581 is before Update 1 and has Update 0.1 as prerequisite. KB945339 has Build No. 25560 (directly after Update 1?).

I also found a new one KB948512 (Build No. 26026)

Hi Waldo,

it's me again! I wrote about different KB numbers!

KB943581 is before Update 1 (< build no.) and has Update 0.1 as prerequisite in the description.

KB945339 is after Update 1. See the SYMPTOMS section in the KB description:

You run one of the following products:

• Microsoft Dynamics NAV 5.0 with Update 1 installed  

• Microsoft Dynamics NAV 4.0 with Update 6 installed

Thanks to Nathalie i found out that you can download NAVXX40SP3 including Update 6 (KB940718)!

Thanks Nathalie!

And thank you Waldo for publishing this list!

Hi does it work in acitrix environment running on w2003 servers ?

thx

Jeff

Natalie pointed my attention to the link of the North American Support team. I have &quot;stolen&quot;

Have a nice holiday - you deserve it! :-)

Waldo,

first i want to wish you a very nice holiday. Enjoy it!

KB943581 has Update 0.1 as prerequisite in the description. See the Symptoms section:

You apply hotfix 936885

...

IF you use the download link 4.0 SP3 from the above table:

See the Announcement section:

29 FEB 2008 The local downloads on this page has been updated with Platform Update for Microsoft Dynamics NAV 4.0 SP3 KB 940718

So if you download 4.0 SP3 from Partner Source you now have the one with Build No. 25143!! I think the link to 4.0 SP3 has to be in front of Update 6 now?

I'm not agree with you about RAID 5. The best practices on SQL Server 2005, for max performance, (source MCS France) are RAID 5 for data, RAID 0+1 for log, RAID 1 for tempdb.

Last month (23 rd – 25 th April), Claus Lundstrøm and I took to the road and drove all the way from Vedbæk

Dear All,

I m using Vista on my system and want to run navision 4.0 Sp3. so can anybody help me out how do i run it.

Time for the next chapter for the &quot;what impact does my C/AL have on SQL&quot;-story. I already covered

Time for the next chapter for the &quot;what impact does my C/AL have on SQL&quot;-story. I already covered

Time for the next chapter for the &quot;what impact does my C/AL have on SQL&quot;-story. I already covered

Is it possible to run the client without having to elevate the permission level to local administrator ie selecting "run as administrator"?  I don't want to give users administrator level access to their machines.

John

Because I&#39;m a Belgian, and Belgium is in group 2, I&#39;m a bit more excited about the Group 2 releases

Yup!!!

It is what I forgot today - check the Patnersource if the version is already released!

Thanks for the info...

Glad I could be of your assistance .

I found following information on partnersource and I found it worthwile to put it online. I didn&#39;t

Woohoo...sounds more like new pain in the...

Better watch out for paintballs...rrr

Thx and grtz!

Hi,

I am not quite sure, but with this code you will face at least one additional problem:

You start looping through 2800 records, mark every second one, and the you loop again through the marked 1400 records.

But if you loop through a recordset with more than 500 records, FINDSET is the worst idea to use, because SQL has to fetch x times 500 records (in your case, 6 and 3 times 500 records), which makes performance really bad. Microsoft strongly recommends to  use FINDSET only with less than 500 records in the recordset, so that SQL does only perform ONE single SELCT TOP 500 command.

In recent Microsoft statements, FINDSET (with or without parameters) is regarded as being slow, unforeseeable and problematic due to strange locking behaviour.

Try FIND('-') instead, which is recommeded for loops with more than 500 records, and your performance should increase. Maybe the marks are not the problem at all...

Here some links:

www.mibuso.com/.../viewtopic.php

(advantage of find('-') compared to findset)

And an exercpt from the Microsoft resource kit:

"When you use FINDSET without any parameters it functions as a firehose and fetches

around 500 records. If you want to retrieve more than 500 records, you can still use

the FIND('-') function. Alternatively, you can use FINDSET(True).

If you need less than 500 records, use LOCKTABLE and then FINDSET."

Locking Poblems with Findset (there are additional articles available, I think):

blogs.msdn.com/.../Default.aspx

(search for FINDSET and read the following comment regarding locking problems)

This is, why I won't use FINDSET anymore. In some of  our projects, we had performance problems and even deadlocks due to FINDSET, because it locks more than the filtered records. With FIND('-'), everything worked fine and fast.

But this might also depend on the case, of course ;-)

Sorry, dude, but I still have big doubts on this.  I did my own tests (as you can read in my post (URL above)), and the results were quite clear.

When marking records, it just doesn't matter.  Probably it'll loop in cache.  And still, if not in cache, it does a seperate SELECT for every record.  No SELECT TOP 500 at all (because there is no filter, there is no WHERE-clause).

Furthermore, if just looping (not marking), I did my tests, and (als Stryk also mentions in the link you sent me) it does client side cursoring for the first 500 records.  That's why (when looping more then 500 records) you first get a SELECT TOP 500, and immediately after that a SELECT * (it looped the first 500, noticed there were more, and therefore getting the rest of te records the same way as FIND('-') did).

That's what is clearly shown in the client monitor and SQL Profiler.

But let's be sure.  We are interested in what is fastest.  I'll try to think of a scenario tomorrow to test this out in a big database... . Hope to find some clear results on this... .

Ok, I agree with you (and your test results), which are a very good work. But does it reflect the multi-user environment, which we try to optimize in our projects?

Imagine a company, typing in orders every minute and an automatic sales reservations for all items. FINDSET is fast, agreed - in a single-user environment! But with the unpredictable locking system, in a multi-user environment, I would not bet on FINDSET but on FIND('-'). I had two projects, where I could prove this behavior. FINDSET loses all performance advantages due to its locking problems.

I cannot prove this with a comparison in microseconds - but all deadlocks and waiting periods were gone at the time I replaced FINDSET.

Your idea to use a larger database is good, but maybe you should also try to build up a test scenario in multi-user style ;-) Because fast is only, what is fast in single- AND multi-user environments. It doesn't help our customers if a single user is able to work fast, and 10 users suffer from performance.

But you are right, in single-user scenarios, FINDSET should win the contest...

Hey thats very useful info thanks.

Whilst it is always implied that a Service Pack upgrade does NOT require a data upgrade, its good to see them specifically confirm this with this version.

I will try to think of a way to simulate what you mean, but it's nog going to be easy though... .

New update for NAV5SP1: mbs.microsoft.com/.../KBDisplay.aspx$en-us$954191&wa=wsignin1.0

Here is a new update of &quot;THE&quot; list . Enjoy! Released Version Update Build No. KB number Prerequisites

Hi Waldo,

its me again. Did you had a good vacation?

Look at (for 50SP1)blogs.technet.com/.../microsoft-dynamics-nav-5-0-sp1-latest-available-version-build.aspx

:

Microsoft Dynamics NAV 5.0 SP1 build 26084.

Current available fixes:

5/29/2008. KB 953245; build 26654. Cfront folder. "C/Front hangs while generating a lot of temp files "

6/11/2008. KB 952373; build 26751. Client folder. "Selecting specific Printer Tray does not always work"

6/26/2008. KB 951631; build 26751. Client folder. "NAV 5.0 SP1 locking error when you print a report that calls code in a form"

6/30/2008. KB 953545; build 26751. Client folder. "Local variable values not updated in debugger"

6/26/2008. KB 954342; build 26810. Client folder. "NAV shows unexpected results when filtering, and may crash "

and for 40SP3:

blogs.msdn.com/.../buildnummern-bersicht-microsoft-dynamics-4-0-service-pack-3.aspx

Finally, there is some (good) documentation available regarding the local functionality of NAV. For a

Pingback from  AMD Talk &raquo; Microsoft Dynamics NAV 5.0 Local Functionality

Pingback from  Pregnant Man &raquo; Microsoft Dynamics NAV 5.0 Local Functionality

I know that they told us that they are working on this documentation one year ago. I am happy that they finished it and now we have it available. Good for all of us who are working with international projects etc.

Famulos news, I have only been waiting 17 years for this.

Thanks Eric for the links.

But still, some countries are missing, like Czech Republic... it seems like GR1 and may be some other countries are on the list...

thank you very much! This is my searching for my job! But I can not download from UK???!

I was asked by MSDynamicsWorld.com to write a small piece about NAV2009. Not easy to do, because as MVP

Pingback from  windows server raid 1 or raid 5 performance sql

... Нашел интересную информацию опубликованную Waldo в своем блоге dynamicsuser.net/.../microsoft-dynamics-nav-2009-what-s-to-expect.aspx

Pingback from  Bookmarks about Microsoft

As you might have noticed, I changed the table a little bit. I think it&#39;s far more useful to see

after installing the client folder Im still getting

error"programm that should be updated cannot be found or the fix is not for this version of the programm.... blabla!" what else do i need todo

Normally, I would have done an article about Sumindexfields on versions previous to 5.0 SP1, but I decided

$Cnt is used internal by the SQL Server to find out when the record can be removed from the indexed view again.

When is scheduled the next event ?

BTW : Do you accept French in your Belgian gathering ? ;-)

I was there, unfortunatly the only person I recognized and had a chance to say hello and talk to was Hynek (he was one of my Navision trainer in the UK back in 1997) and Jorg.

I've recollection having seen Luc, Eric & Mark but back then I did not have a picture to put against the names, so next time I will say hello :-)

Hey well done Eric,

There is a ton of info out there about Indexed views, but you have done a great job of finding the important stuff, and summarizing it all in one place.

PS I wish you a fast recovery on the knee.

Only if the view definition uses an aggregate function or GROUP BY, the SELECT must include COUNT_BIG(*). The name of the column is no matter. Here it's called $Cnt but you can call the column what you want.

Why is it when I try to open the doco file above I get a http403 and says website requires me to log in.

Hi,

When I do this, my shapes seem to be on top of the textboxes (so I cannot see the text) - I know I am missing something simple...

Hi,

You need to add the shapes first - then the labels afterwards, and then the labels will appear on top of the shapes instead of being hidden :)

Just a suggestion, but do you think you might be able to display this table in reverse (newest release first) order?

Hej Waldo, great work again!

check this link for updates on 40SP3 (KB952873, 953313, 929047?, 954342, 954722):

blogs.msdn.com/.../buildnummern-bersicht-microsoft-dynamics-4-0-service-pack-3.aspx

Hi,

I have solution which allows to have information form always opened.

Idea is following - form should be allowed to close, because otherwise Navision can't be closed. But when form is closed, Navision timer is activated, which after some time (I use 100 milliseconds) opens the form back and deactivates timer.

I've created single instance codeunit (GeneralInformationMgt) with following code:

OnRun()

CLEAR(NTimer);

CREATE(NTimer);

NTimer.Interval(100);

OpenForm;

FormClosed()

NTimer.Enabled(TRUE);

OpenForm()

NTimer.Enabled(FALSE);

FORM.RUN(FORM::"General Information");

NTimer::Timer(Milliseconds : Integer)

OpenForm;

Here FormClosed and OpenForm are functions with no parameters; NTimer is global variable, Navision Timer automation.

On form's OnCloseForm trigger function GeneralInformationMgt.FormClosed is called.

From codeunit 1 I run GeneralInformationMgt codeunit instead of opening information form.

Hope my explanation is clear enough.

awarnica, you can use Fromat -> Bring to Front / Send to Back functions on controls.

That is fantastic Viktoas!

I have implemented your suggestion on my Where Am I tool and it works a treat. I just need to package it up with some instructions and pop it on the downloads page!

Thanks for sharing this and leaving the comment on my blog to let me know you had done it.

Cheers,

Dave.

Hi Waldo,

I've been trying to contact you by various means - I sent an e-mail to your Dynamics User account, I tried an e-mail to question on your MSDynamicsWorld.com article and I tried a private message to your Dynamics User account - all with no luck. This my final last ditch attempt. If you get this could you please send me a private message through this forum?

Thanks, Dave.

A new way to get familiar with the product ... and not a bad one. A few months ago, we could read about

And one tip - you can make it much better and use editbox without borders etc., with BIG font size, and e.g. with character 'g' in 'Webdings' font to fill the background with selected color. Than you can set the FOREGROUND color in OnFormat and you have truecolor background possibility without any big code for each color... ;-)

The Web Services competition in the UK is indeed serious and we have a few entries already. There is also a real prize (somewhat generous IMHO) of a classic sports car for a day. Open to all UK reselling and ISV partners.

Hi,

Sorry but I don't understand the part that said updates were language/country sensitive.

How do I check my NAV language?

Thanks

thanks so much

The &quot;Key&quot; virtual table contains information about the keys that are defined in each table

The &quot;Key&quot; virtual table contains information about the keys that are defined in each table

Hi Waldo, great post again! I just wanted to comment that Object table is fully editable - you can even modify the contents of the BLOB Reference field. I have an example of it my Automated Version Management tool: dynamicsblog.wordpress.com/.../auto-versions

I also have a problem with opening the presentation. I have office 2007...very curious to see the presentation.

Today, I received a very interesting summarizing mail from Microsoft with the announcement that SQL Server

Two posts in one day ... It&#39;s not really my habit, but it&#39;s just too interesting (and definitely

I couldn't download the file, what may be reason

A new series of MSDN and TechNet evening sessions will be organised by Microsoft Belgium. And it&#39;s

LOL in heart and kidneys, gotta keep that one :)

Here (finally) a new update of the current platform updates. One of the requests was to reverse the table

The update link for CTP4 could not be found :-/

I'm already registered on MSConnect, but they never answered my intention to sign in the Beta Access Programme (half a year ago??). They don't like me obviously :-/

You can add this link as a summary fot the 50SP1 updates/hotfixes:

blogs.technet.com/.../microsoft-dynamics-nav-5-0-sp1-latest-available-version-build.aspx

for 40SP3 are two newer ones than the 6.10 that can be downloaded, see the link thats in your overview above (KB953313 and KB954342).

thanks again for the update.nice work!

Nope, both are platform updates. the one you mention is KB929047 :)

I am a member of connect, but the link to 2009 CTP4 does not work.

On connect.microsoft.com there is no link to downloads :-/

Seems as if the design of that page strongly depends on your rights.

Hi Waldo,

when you get “inspiration” from other blogs, it would be nice if add a link back to the original, or at least mention it.

Thanks

Sebastian

My two cents concerning using of FINDSET with secondary key and using FINDSET(TRUE,TRUE).

First, about FINDSET with secondary key. As Waldo said using FINDSET will result in two queries:

SELECT TOP 500 ...

and cursor SELECT * ... WHERE PK > 500 ...

But it is true only for loops based on PK.

If you have a loop based on a secondary key you'll have extra queries.

For the table with two fields we will have the following picture:

First we will get first 500 recs:

SELECT TOP 500 * FROM "TestFindSet" ORDER BY "SecondKey","EntryNo"

SecondKey  EntryNo

A          1

...

A          500

Then we will have an extra query (cursor) to get the rest recs with SecondKey = 'A':

SELECT  * FROM "TestFindSet" WHERE  "SecondKey"='A' AND "EntryNo">500 ORDER BY "SecondKey","EntryNo"

SecondKey  EntryNo

A          501

A          502

A          503

A          504

A          505

And then we will have the query (cursor) to get the rest of the table:

SELECT  * FROM "TestFindSet" WHERE  "SecondKey">'A' ORDER BY "SecondKey","EntryNo"

B 506

...

More fields you have in the key more extra queries you will have. For example for the table with 3 fields where two of them are in the same secondary key we will have 2 extra queries:

1. SELECT TOP 500 ... OREDER BY "SecKey1", "SecKey2", "PK"

2. SELECT * ... WHERE "SecKey1" = zzz and "SecKey2" = xxx and PK > 500 ...

3. SELECT * ... WHERE "SecKey1" = zzz and "SecKey2" > xxx ...

4. SELECT * ... WHERE "SecKey1" > zzz ...

Now the most interesting part about using FINDSET(TRUE, TRUE).

When MS said "If you are going to modify any field value within the current key, set this parameter to TRUE." they didn't mean that you should use the same variable for looping and for modification (wich can lead to "NEXT from HELL" situation). You can look at example 3 of the help topic concerning FINDSET.

So what is the difference between FINDSET(TRUE) and FINDSET(TRUE, TRUE)?

FINDSET(TRUE) will open the cursor which will fetch a number of records at a time.

FINDSET(TRUE, TRUE) will result in the cursor which will fetch records one by one.

And you should know that during modification of the current key Navision will use the cursor which will fetch records one by one. This is the point.

The following example illustrates what will happen if you use FINDSET(TRUE) for key modification loop:

start reading

1. open cursor

2. fetch x

3. ...

4. fetch x

first modification occurs

5. close cursor

6. open cursor

7. fetch 1

8. modify

continue to modify

9. ...

10. fetch 1

11. modify

no more modifications at the moment - continue reading

12. close cursor

13. open cursor to read the rest of the records with the same values in the key (as described in the first part of my post)

14. close cursor

15. open cursor

16. fetch x

17. fetch x

another modification

18. close cursor

19. open cursor

20. fetch 1

21. modify

22. close cursor

23. open cursor to read the rest of the records with the same values in the key

24. close cursor

25. open cursor

26. fetch x

27. ...

28. close cursor

As you can see using FINDSET(TRUE) will result in a number of cursor creation and closing procedures.

As for FINDSET(TRUE,TRUE) the system will create the cursor only once, BUT it will fetch records one by one:

1. open cursor

2. fetch 1

3. fetch 1

4. ...

first modification occurs

5. fetch 1

6. modify

7. ...

no more modifications

8. fetch 1

9. fetch 1

10. ...

11. close cursor

So which method is preferable for loops with modifications of the key? In my opinion, unfortunately, there is no universal solution. If you are going to modify every second record in the table than FINDSET(TRUE,TRUE) will be the good choise.

But if you need to modify only a couple of records in the table with millions of records than I think using FINDSET(TRUE) is more convenient.

Hope this info will be useful.

On the German NAV Developer's Blog, there are some more Hotfixes for 4.0 SP3:

blogs.msdn.com/.../buildnummern-bersicht-microsoft-dynamics-4-0-service-pack-3.aspx

as well as for 5.0 SP1:

blogs.msdn.com/.../buildnummern-bersicht-microsoft-dynamics-5-0-service-pack-1.aspx

I wanted to get your attention to a new blogger: Claus Lundstrøm . OK, I hear you thinking &quot;just

S..t, once again I will not be the first one with that... :-(       ;-)

Want to but can't because of NDA.

Hey Eric, are you sure the color is not just the work of photoshop?  ;-)

This is an historical day for some people. Other people don&#39;t really look at it like this, but then

This is an historical day for some people. Other people don&#39;t really look at it like this, but then

Pingback from  Blogwelle zu NAV 2009 gestartet &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

Good stuff eh Eric :) finally we can talk about this, get rid of some of the wrong ideas floating around out there, and maybe get people excited just like we are.

How was the "Hardware recommendations" session ? Unfortunately I was unable to attend, although I really wanted to be there...

If you browse through the threads of MiBuSo or DynamicsUser.net , you come across posts where people

Pingback from  NAV 2009 Launch | Programmer's Edge

Pingback from  NAV 2009 Launch | Programmer's Edge

I think I said it before - but this blog post is GOLD!

You can't say it enough in my opinion :-)

I think someone said it before - but this blog post is GOLD!  :-)

I&#39;m getting a little bit lazy, so it seems. I&#39;m sitting here, five minutes before the very first

This first session (at a killing starting time of 8am in the morning ) was presented by Tom Loyal and

That&#39; s big title . If you&#39;ve read my first post (introduction) ... one might have a feeling

This first session (at a killing starting time of 8am in the morning ) was presented by Tom Loyal and

This next session is one of the &quot;Implementor&quot; tracks. I&#39;m not an implementor, and I don&#39;t

The past years you could feel Microsoft pushing people (and the product) to Sharepoint. Being a succesful

I was also hoping for more of a general NAV/sharepoint session, and I kind of expected to see an infopath webpart consuming a NAV2009 webservice, and I was very disappointed to see it was just another EP demo. It was the best EP demo I've seen so far though, very clear, and a complete runthrough of the entire process, from setting it up in NAV to seeing it work on Sharepoint.

A good session overall, nice presentation (although Tom Loyal was a bit too happy too early in the morning for my taste :)). I enjoyed the information and it will help a lot of people get started in SSRS.

This is a session of my good friend and fellow MVP Daniel Rimmelzwaan (aka Denster on Mibuso). I&#39;m

I liked this session a lot, especially the way they took it down to more of an operational level, instead of a management type overview.

BI is hot today. BIO Analytics is a company that built BI tools for Dynamics NAV, called BIO for Dynamics

Sounds like a great session. Good job Daniel, nice blog Eric.

Wish I could be there...

Hi Waldo, what sort of delay does the iFacto NAS Scheduler have between receiving a request, starting up the new NAS for the correct company and being able to handle the request? Maybe it can only be used for scheduling jobs and not this kind of message handling. Cheers, Dave.

Who doesn&#39;t want to follow that session? :-) I heard this session is going to be about the form transformation

Your opinion is correct. I also think it's faster to create a page from scratch instead of transforming it.

If you have the need to keep forms as well as pages then this could be a good strategy, although it did look like keeping forms and pages synchronized is a lot of work, and I wonder what would happen if you decide to not synch one of them, or a number of them, it becomes very difficult to manage. For situations where you don't need to have forms as well as pages (i.e. when all you need is the RTC), I think it serves you better to do development straight in the page designer.

What I wonder though, is whether we'll get a page wizard that will help us a little more than just set the page type.

It&#39;s a tradition. After a convention I always try to write some &quot;thoughts&quot;. Has it been

Pingback from  Where Am I? Now I know! - Gaspode&#39;s Brain Dump

It&#39;s a tradition. After a convention I always try to write some &quot;thoughts&quot;. Has it been

Who doesn&#39;t want to follow that session? :-) I heard this session is going to be about the form transformation

This is a session of my good friend and fellow MVP Daniel Rimmelzwaan (aka Denster on Mibuso). I&#39;m

The past years you could feel Microsoft pushing people (and the product) to Sharepoint. Being a succesful

This next session is one of the &quot;Implementor&quot; tracks. I&#39;m not an implementor, and I don&#39;t

If you browse through the threads of MiBuSo or DynamicsUser.net , you come across posts where people

This is an historical day for some people. Other people don&#39;t really look at it like this, but then

I wanted to get your attention to a new blogger: Claus Lundstrøm . OK, I hear you thinking &quot;just

Here (finally) a new update of the current platform updates. One of the requests was to reverse the table

A new series of MSDN and TechNet evening sessions will be organised by Microsoft Belgium. And it&#39;s

Two posts in one day ... It&#39;s not really my habit, but it&#39;s just too interesting (and definitely

Last month (23 rd – 25 th April), Claus Lundstrøm and I took to the road and drove all the way from Vedbæk

Few new articles about NAV on SQL released by experts: Lars Lohndorf-Larsen article &quot;Record-level

Today, I got the message that Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server

Today, I got the message that Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server

Thanks for posting this Eric, I was waiting for that announcement.

Thank you for posting this! :-) Just one small correction, an update is needed if customers are using Business Notifications and/or Commerce Gateway, not Business Analytics. From the PartnerSource announcement:

...

"The only product update to be aware of applies for customers who take advantage of Business Notification and / or Commerce Gateway functionality."

...

I have one client that is running 4.0SP3 on Win2k8 SQL2005. They upgraded form Win2k3 because they were told it would speed up Navision.

Speed wise there was no change, but it does seem very stable and nice to use.

In fact I am thinking of installing Win2k8 on my next lap top instead of Vista.

Business Notification will not be able to support Microsoft SQL Server 2008 before the "SQL Server 2005 Notification Services Components Package" has been released. Currently this in RC1 state. Business Notification is dependent on this component in SQL Server, and this was not included in SQL Server 2008 RTM.

Please ready more about the availability of "SQL Server 2005 Notification Services Components Package" here:

forums.microsoft.com/.../ShowPost.aspx

When "SQL Server 2005 Notification Services Components Package" has been Released to Web, we of course need to verify that Business Notification works with SQL Server 2008 included the "SQL Server 2005 Notification Services Components Package" before we can claim support for Business Notification on SQL Server 2008.

Regards,

Claus Lundstrøm, Program Manager, Microsoft Dynamics NAV

I fixed this problem.

Uninstall the Navision sp3 and just install Navision sp1.

Or download the updates.

Some time ago, I explained how you could use ADO to call stored procedures and stuff ... . Just another

Some time ago, I explained how you could use ADO to call stored procedures and stuff ... . Just another

I just wanted to add a note that Navision doesn't really like linked objects. They do work and often well, but with problems.

The first you've noted, a Nav restore will fail without the view in place; but if the view is based on tables in a company you won't be able to create the view until the company is restored. Luckily when the restore falls over you can create the views and continue the restore.

I haven't found any solution to the second problem; you just cannot rename companies with linked objects without deleting the objects.

BTW: The comment above: using ADO from NAV to create the views is a very good idea; that way you don't go misplacing the script.

Sorry, step 3, creating the views, fails when the view is based on a table in the company that doesn't exist yet.

You should get an error free restore if you create FAKE views at this point and replace them at the end.

Oh and you can restore "only the objects" in (2) you only need to treat the fbk as a fob if you've already loaded some objects into the DB. But it is a really neat trick then.

> The renaming is indeed a ***.

On SQL, always!

It's often faster to backup and restore to rename on a native DB!!!

But some people seem prepared to wait.

Hi Eric!

Great BLOG! In my projects I oftenly use Views & Linked Objects, e.g. to easily display JOINED or AGGREGATED data, which would be a real "pain" to do in C/SIDE ...

Regarding "performance", indeed, it could be quite poor - depending on the View. But since SQL 2005 Views could be INDEXED to speed up performance - as shown with VSIFT in NAV 5.0 SP1!

Using Views & Linked Objects gives us LOTS of possibilities: you could create a View on a "Linked Server", which e.g. could be an Excel sheet (ODBC source) or a remote Database etc.. For example, you could link a - separate - DB with historical data; thus using historical info TOGETHER with current NAV data ... or transfer/migrate master data directly from an Excel sheet (which would be eveb faster when doing a INSERT / SELECT in SQL) ... and much more!

SQL Server IS POWERFUL! And besides MSADO, Views & Linked Objects are a GREAT option to use this POWER in NAV! (IMHO)

Best regards,

Jörg

The "cool" thing about this, is that it has actually been possible to do at least since version 3.60, so it's not new. But I think not many developers know this. We used it to display values of other SQL databases directly in Navision.

Is Windows Server 2008 + Nav 4.0 SP3 really compatible ? We are facing service start error.

Nice blog!

I do know of the possibility from the beginning, but because of the problems involved, I try to avoid them.

The way I would do it, is to create a new DB (NOT NAV!). In this DB I define all the views (and maybe also tables if needed). In NAV I use ADO to read the tables/views in that other DB. This way the NAV-DB remains 'clean'.

Also if the views are on another DB, I do this. This way, with ADO I just need to access that DB and not multiple others. This way also the other databases remain 'clean'.

If I need the view on a form, I read the data through ADO in a temptable and then show the temptable. Of course, this is only possible if there are not too many records and the view-query is fast enough (here indexed views can help).

BTW : talking about ADO: thanks for your blog on it. It was very helpful to get started!

My Build: Navision 4.0 SP3 - India, let me know what exactly build you wish to know and where I can fetch that from my system.

My intention with this (planned) series of blog posts, is to give you some tips and tricks regarding

My intention with this (planned) series of blog posts, is to give you some tips and tricks regarding

In the first place, I am unable to install NAV 4.0 SP3 on Windows Server 2008, during installation, during service start, getting error and unable to complete the installation.

Thankyou verymuch. I did a fresh copy download and installed, everything went fine.

I'm installing Dyamics NAV 5.0 SP1 on a Vista machine and am consistantly getting an error during the installation.  I've also got the same program, from the same install, running on 3 other Vista machines (one of which is a mirror of the hardware and installed at the same time).

OS = Vista Businesss 32bit

Dynamics - NAV 5.0 SP1

Error Code: 1935 - An error occured during the installation of assembly component.

Google searches point to a .net issue, but I can't find anyone who's got a sucessful fix for it.

Thanks a lot! Great Blog! It really help me!

Shame on me … but this message is too late. You&#39;ll probably know it for a while but still … I&#39;m

Hi guy can u actually tell me how to hold a SQL server for many user from different network system to access the database and to work on some database alone.

Just wanted to get your attention to something quite important. Until the end of the year, to be a certified

Just wanted to get your attention to something quite important. Until the end of the year, to be a certified

So, if we are MCP, but for now we don't have, for example, Microsoft Dynamics NAV Installation & Configuration certificate, then we will be blocked in January?

It's SQL exam 70-431 -OR- 70-432.

If you need to study one, just go for 70-432 since it's for SQL 2008

Microsoft are always changing this :-)

When they took over Navision they made accreditation dependent upon SQL server exam and others, then it was also with some core and elective exams, then they overlayed gold partner, then for the past few years they juggled around with the accreditations.

Still nice to know what they expect from next year - although if you are big enough they do by pass this requirement!

A typical NAV developer will never touch 75% of the subjects tested in that SQL exam.  It would be nice if they devised certification requirements that were actually consistent with the job requirements.

Don't count on them overlooking this rquirement even for larger organizations.  I work for one of those "larger" organizations and our management was told that this requirement would not be overlooked.

Yeah, we got that same "warning" ourselves (today).

Time for another overview (it has been a while, hasn't it?). Well, NAV 2009 was officially released

Time for another overview (it has been a while, hasn't it?). Well, NAV 2009 was officially released

Is a Microsoft Dynamics NAV 4 SP3 also compatible with Microsoft SQL Server 2005 and Microsoft Windows Server 2008?

We wanted to jump up during this session to brag about Pivotier which enables Reporting Services for Dynamics NAv data including support for flowfields and option fields.  Now NAV users can use Report Builder as we automatically create Report Models with flowfields, etc.  Also ad-hoc reports without using the Builder.

See

www.centerlinesft.com/.../pivotier.html

for more.

At the latest Convergence EMEA (Copenhagen) some MVP's were asked to be (video-) interviewed by Bruce

At the latest Convergence EMEA (Copenhagen) some MVP's were asked to be (video-) interviewed by Bruce

A while ago, I posted a blog about the SQL Server 2005 Runtime license . Well, recently I received the

A while ago, I posted a blog about the SQL Server 2005 Runtime license . Well, recently I received the

A while ago, I posted a blog about the SQL Server 2005 Runtime license . Well, recently I received the

Customers need to review their licensing options for both SQL and server operating systems and select the option that fits their situation the best.  While one option may have a cheaper initial purchase it may not be the cheapest in the long run as the system is updated and expanded.  In my experience there is not "one size fits all" solution.

True ... and don't get me wrong.  I'm not really a "runtime license"-fan myself..  I would rather keep all options open at all times.

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV