Browse by Tags

Navision SQL Roles

Hi, I'm having a problem where a User which is granted SUPER roles in Navision gets an error when doing a transaction. The following SQL Server error(s) occured while accessing hte PW Inventory - Lot table: 1088, "42000", [Microsoft][ODBC Sql Server Driver][Sql Server]Cannot find the object...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by pwellar on 10-14-2008
table data 50000 does not exsist

dear friends i have to convert the navision 4.0 database to SQL DataBase (i have run max test in navision and took a back up in Navision) then i tried to restore the Navision DB to SQL Database(wich i have created using SQL sever option in Navision) then i am getting the following error massage. Table...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by satheeshNav on 11-29-2007
Navision 4.0 Company wise Roles Problem

Dear All we have installed Navision 4.0 at one of our client. now we have to create a roles company wise (There are 2 companies in this database) we have assigned company name to each user name. when we try to open this database using any of the usernmae it gives error " YOU DO NOT HAVE PERMISSION...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by ashbhardwaj on 09-10-2007
Re: Recommended Maintenance Plan for Dynamics NAV on SQL 2005

My plan is: Job 1: DBCC REINDEX [Table] x (n = processing tables) - daily Job 2: DBCC REINDEX [Table] x (n = entry tables) - weekly Job 3: DBCC REINDEX [Table] x (n = other tables) - monthly Job 4: DelZeroSift - daily (ref: http://www.mibuso.com/dlinfo.asp?FileID=812 ) Job 5: Update Stats - daily (as...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by Nicholas Bartie on 05-04-2007
Re: Recommended Maintenance Plan for Dynamics NAV on SQL 2005

[quote user="DenSter"]You need to keep the statistics on the indexes current though. sp_updatestats will update the index statistics, and in turn will make the query analyzer more accurate. [/quote] Yes, Good statistics are critical to query optimizer. But there are several ways to update statistics...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by Nuno Maia on 03-30-2007
Re: Recommended Maintenance Plan for Dynamics NAV on SQL 2005

You need to keep the statistics on the indexes current though. sp_updatestats will update the index statistics, and in turn will make the query analyzer more accurate.

Posted to NAV / Navision - Microsoft SQL Server (Forum) by DenSter on 03-30-2007
Re: Recommended Maintenance Plan for Dynamics NAV on SQL 2005

In optimization subjects there are a few scripts related to sumindex fields optimization. In SQL there are a few scripts (I never tested) to optimize scripts. I also don’t usually run update statistics. I rather prefer to periodically rebuild indexes during night. Large tables I might don’t rebuild every...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by Nuno Maia on 03-30-2007
Re: Recommended Maintenance Plan for Dynamics NAV on SQL 2005

[quote user="triff"] I try and time the backups to happen after any overnight polling/ processing but before the start of the working day so the first thing the dba should do is remove the backup tape and put it in a fire proof safe. [/quote] I agree, but if you have more or less 24-7 activity...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by Erik P. Ernst on 03-30-2007
Re: Recommended Maintenance Plan for Dynamics NAV on SQL 2005

The "Update Statistics Task" of the MP actually perfroms an UPDATE STATISTICS statement. Means, existing stats are updated - which presumes, that the stats have been created previously. But stats are only created automatically, if the "Auto. Create Statistics" property is set; and...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by Jörg A. Stryk on 03-30-2007
Re: Recommended Maintenance Plan for Dynamics NAV on SQL 2005

Hi Erik I would usually recommend the following. 1) Transaction log backup every 15 min 2) Full Backup once a day I recommend that the backups are copied offsite as soon as possible (easy with the transaction logs over a WAN but may not be possible for the full backup). I make it part of a backup of...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by triff on 03-30-2007

Page 1 of 2 (13 items) 1 2 Next >