-
SQL Server accessing the Sessions table
Hi All Can somebody help me with the following problem I am Using Nav 6.0 Sp1 Database SQL server 2008 In Codeunit 1 we have defined a variable of session table which reads the no of session of that particular user id and does not allow him to login more than once . But the problem started when we made the users as public.…
-
Database conversion log file issue with SQL 2005
I have a customer running Nav 4.03 BL=23305 on SQL 2005. I need to upgrade them to 4.03 BL=25143 so their Windows 7 work stations can run fat client. It is a 57 gig navision database. The SQL log file cannot be set to unrestricted growth. They have plenty of disk space, but I cannot change the log file max size beyone 2…
-
Understand Keys Fields - How this improve performance?
Hi guys, i´m newbie on Nav and i had some doubts for the Fields of the Keys Table. I want to know what impact they can do the performance of NAV. I have read this http://msdn.microsoft.com/en-us/library/dd338617.aspx. Field KeyGroup Explanation: Keygroups - Determines which key groups the key is a member of. By making the…
-
Enable time to be recorded while creating a record
Hi, I want to insert the time when a sales order was created inside Nav. I see the fileds are all of type DateTime, could anybody please suggest how to enable time logging inside Nav database.
-
Synchronization of logins between Nav 2009 and Sql server
Hi Could you please give the step by step procedure or links explaining the synchronization of logins between Nav 2009 and Sql server. Thanks and regards, Usha.
-
Service Account User for SQL Server
Hello experts As we all know sql server service can run under a domain user or a built in user (local system, etc.). I'm interested in your opinion about what do you think about this issue. Do you ever use "Local System"? Thanks in advance. Thomas
-
Filter on Dynamics NAV 2009 SP1 SQL Server
Hello to everyone, We have updated a database from 3.70 (native) to Dynamics NAV 2009 SP1 on SQL Server 2008 SP1. We have the new database with the Latin1_General_100_CS_AS Collation. If we filter in the table 7012 - Purchase Price, field "Item No." with the filter "S*" to show all the records that start with S, the sytem…
-
Display NAV field properties w/ SQL Server statement
Hi, I want to design a SQL Server report to display certain NAV table properties. Example: Table:__________Field:____________Data Type:____OptionString: Sales Line_________Document Type______Option__________Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order ... As far as I know it is saved as a BLOB reference in…
-
Move NAV 5.0 Database to another SQL server
I need to move the NAV 5.0 database to another SQL server. What are the initial preps to make this transition? I have copied a backup of the NAV database and restored it to the new server. The trace flag 4616 has been added to the startup parameter. On the client, when I attempt to connect to the database, an error message…
-
Replicating Record Link Table
Hi , In my code I am replicating the Record link table from Nav to my database. The Identity is set to true. Identity Management = Manual I keep etting the error - "Cannot insert explicit value for identity column in table 'Record Link' when IDENTITY_INSERT is set to OFF. (Source: MSSQLServer, Error number: 544)" when I…
-
database connectivity
hi!!!! All i want to connect the native database through C# .net. Please give the idea that how we connect the database (Native database) in C#.
-
getting a SQL error PLZ Help....!!!!
Hi, I just have migrated a NAV DB(SQL) from 4 to 6 SP1 ....now after taking the backup when i try to restored into 6 SP1 SQl is throwing an error however the backup is restored successfully..... The error is like:-- Microsoft Dynamics NAV ClassicThe following SQL Server error or errors occurred when accessing the Object…
-
Locking Types
Hi, Under what circumstances you would use; page locking, record locking, table locking ? Thank you
-
sales and marketing module dfd
Hi all Please suggest me how can I make dfd for sales and marketing module
-
Database Size
Hi expert, I have a question on the database size. Our database is running in SQL server. Currently the usage of the database is 60%. Even though I searched the forum and read the menu, I am little timid of expanding the database size. The database files for MDF is 1200 and file growth is 10% and for NDF is 3766 and it has…
-
Auto-import a fob with SQL
Hello, This is my first post here. Here is our problem : We have several salespersons (30 and going up) with a Navision Database, so this is 30 databases to maintain. The problem is that deployment of new objects on their databases using the tool recObject."BLOB Reference".EXPORT generates files which are too big (4 times…
-
Table ID and Table Name
Hi all, In the Object Designer we can see Table ID and Table Name information,Where is this information store in the sql or how to retrieve the information from SQL? Thank You.
-
2.6 Database Migration
What are the steps involved to migrate a 2.6DB c/side 2009R1 executable database to SQL 2008? I would be grateful for any advice thanks.
-
maintain keys table 7002
hi everyone, i was wondering what'w the reason in maintaining both these keys in table 7002 Isn't it safe to UNmaintain the second key?what's the reason for sql to use the second one?
-
Upgrade 4.00 SP3 to NAV 2009 R2
We are busy with the upgrade of our Navision database from version 4.00 SP3 to NAV 2009 R2 -(classic version). The database is now 250 GB, Sql server 2005 - 90 users in 8 companies. SQL server : Win 2003 x64, SQL 2005 X64 Standard editition, 4 dual processors and 32 GB RAM. All data is stored on a SAN (HP EVA 4000). The…
-
SQL server 2005 mirroring in high availability mode
One of our clients wants to run SQL server 2005 mirroring in high availability mode (auto failover). My understanding is that high availability may not provide 100% duplication. Will this work for them or should they rather do log shipping? Navision version is 2009, though they may be on SP1 by the time they do this.
-
Problem with linked table/view
I have a linked table that's been working fine for a few years. I've now added a field (to the view and table) and am getting several "the multi-part identifier XXX could not be bound" errors when I run the table in NAV. But the related view runs fine in SQL. Thoughts?
-
Will Standard Model Solve my Problem?
I recently just moved our database from SQL2000 to SLQ2008. I did a backup and restore. Unfortunately, I've been getting some weird permissions errors since the restore. Once user was trying to rename an item and got an error about SELECT from the "Item Price Change" table. I fixed that by granting access to Public, then I…
-
using wildcards doesn't work (SQL2008SP1)
friday troubles... ](*,) having following table: No descr ========= 1000 toto 1010 titi 1234 mibuso 1305 explain 1535 thefive 2000 people 2020 rain 3456 onemore No = CODE Descr = TEXT if you filter out *o only mibuso appears, no toto !! if you do the same in SQL with the LIKE clause, same result... SQL :bug: ? Exactly same…
-
NAV SQL Server DR Solution
Hi All, I'm running NAV 2009 SP1 on SQL 2008 SP1. I've been asked to come up with a disaster recovery solution for my company that will allow us to continue working in NAV should our primary SQL server fail in any way. We are very prone to power outages, weather etc. I've been playing around with Amazon Web Services and…
-
SQL code for export Daily Inventory Recieved Report to excel
Dear all, i am new on NAV and now i have problem with SQL code to export Daily Inventory Recieved Report to excel. kindly if someone had this code, please help to send me :cry: Rina
-
issue when set up the promotion in NAV (ex: buy 10 free 1)
Dear all helper, after i had successful with export report to excel, and now i have issue with some code again. i had setup the one promotion in NAV (ex: buy 10 free 1). when i posted the invoice and checked again in report, many reports show the total of sale in 11 (infact it shoud be 10, because 1 is free)... kindly…
-
Expand Database to other drive
Hi, we are using SQL 2008 with a dedicated drive respectively for user db, temp db and the transaction log. Analysis shows that temp db is almost never used, while the drive of the user db sometimes has some nasty peaks in the queue, so I'd like to split the user db in half and put one part on the drive of temp db. What…
-
Problem in NAV SQL DB
Hi, If we create new DB in NAV SQL option in version 3.7 and then we are unable to reopen the created DB again. Following error is displaying. "The session table contains a MBSNavision field data type that is not compatible with SQL Server data type, Type : Integer,SQL Type : BIGINT" Waiting for your early reply. Thks Asiri
-
How to choose the right PHP Framework for web development?
Hi! I'm a PHP Pro, but haven't use any PHP framework till now, so I have no clue on how to choose a PHP framework. Do you have some tips to help me choose the/a right PHP Framework? I want a stable and secure PHP framework for Projects with about 400 hours development time. It should be possible to use the framework on…