Documentation for NAV 2009 SP1

ta5

Hi

Where on the installer DVD is the section for the extended stored procedures xp_ndo_enumusersids and xp_ndo_usergroups?
In pre 2009 Version it was in w1w1isql.pdf...
I know, there is now the nav_install.chm, but I can't find it there ](*,)

Thanks in advance
Thomas

jannestig

In your DVD directory

\Documentation\PFiles\Microsoft Dynamics NAV\60\Documentation\Install Guides

Or there is also the NAV PRO developer on MSDN which you can also download off partnersource

XP files under

SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database

ta5

Thanks.
Yes, I can find this directory, but the pdf files there are for EP, NACG, etc. and in the nav_install.chm I cant find the info I'm looking for.

jannestig

To manually add the extended stored procedures, follow this procedure:

Using a Microsoft tool such as Enterprise Manager, add the
file to the extended stored procedures already installed on
SQL Server. (The name of the extended stored procedure must
be xp_ndo_enumusergroups and xp_ndo_enumusersids.)

After the extended stored procedure has been successfully added
to the server, you must grant execute permissions to the "public"
role by following this procedure:
- Open Enterprise Manager.
- Expand the server and expand the databases.
- Expand the master database and the Extended Stored Procedures.
- In the right side panel, right-click xp_ndo_enumusersids and
xp_ndo_enumusergroups and select Properties.
- Select Permissions and grant EXEC rights to "public."

To Update an Existing xp_ndo.dll File:

---

If you have upgraded to the SQL Server Option for Navision 4.0
you must copy the new xp_ndo.dll file to all the instances of
SQL Server in your network.

- Stop the server before you copy the dll. This ensures that the
old dll is not loaded and is overwritten by the new dll.
- Locate the xp_ndo.exe self-extracting file on the product CD.
- Extract it so that it overwrites the existing dll file which is
stored in the BINN subfolder of the SQL Server installation folder.

The new dll contains a new extended stored
procedure - xp_ndo_enumusergroups. If you are going to connect
to SQL Server with an older version of the Navision client,
the old extended stored procedure xp_ndo_enumusersids should
also be added to the server.

The installation program for Navision 4.0 installs the dll and
adds both of the stored procedures to the server.

---

SQL Server 2000 - 64 bit

If you are running on SQL Server 2000 - 64 bit, you must use
another compiled version of xp_ndo.dll. This can be found on
the Navision Installation CD-ROM, in the folder $:\SQL_ESP\WIN64,
where the $ is the CD-ROM drive.

To add the extended stored procedure, follow the instructions
described above.

ta5

Thanks very much. I know this information from the pre 2009 versions, but wanted the crosscheck with the 2009 SP1 documentation. But I still can't find the information for 2009 SP1, neither on the DVD nor on the internet. ](*,)
A directory called SQL_ESPWIN64 does not exist on the 2009 SP1 DVD, but did always exist on the older installtion DVDs.

Thanks
Thomas

jannestig

well i guess MS supposed it would never fail during install etc so left it out.

But its an SQL side action so the process is the same