-
sql 2005 standard v. enterprise version
Hello Are there anybody out there who has done a comparison between enterprise vs. standard sql 2005 to see the performance difference? Thanks.
-
Attaching SQL database on UNC path
How do I attach a database on an unc path on SQL 2005? Due to discplace shortage I'm trying to attach a database using an unc path. Through some reading I have seen that I need to set traceflag 1807, but it's still not working :cry: I can point to the mdf file when sql askes me what database to attach. This works. But then…
-
Which Build for SQL2005
Hi experts We have to migrate a rather small customer from Navision 4.02 from Native DB to SQL Server 2005. I think we will also do a technical upgrade to 4.03 because of the security model switch. What Navision build would you recommend, e.g. is the SP3 alone ok or are there important *technical* hotfixes concerning sql…
-
Read Only ODBC Connection
Hi all, Is it possible to create a read-only odbc connection to SQL? We often use odbc to pull NAV data from the SQL tables into MS Access, but as this is a r/w connection there is always the possibility of changing or erasing data from the tables. I have created an SQL login which only has read access to the tables, but i…
-
Installing SQL Server For Microsoft Dynamics on x64 Server
I'm trying to install the SQL Server for Microsoft Dynamics (it's on the Dynamics price list) on a x64 server. The CPU is an Intel Xeon 5130 with the EM64T. When I try to run the windows installer for the SQL Server the following error occurs "The Microsoft SQL Server Native Client Package is not supported on the current…
-
Hardware sizing
Hi guys, I was just reading the Hardware Sizing for 4.00 (hopefully the latest version) and I noticed that for DBs > 80GB and 150+ users they recommend 2 mirrorred drives for log files and 6-7 for data. I always thought that you needed more than that especially for the log. I am trying to decide some HW sizing for a client…
-
sql 64 bit memory setting
Hello. One of our client has a sql 64 bit os 64 bit SQL 2K5 standard navision with RAID 10. The system has 24 gig of memory RAM. The sql server only utilizes 10 gig of it. The users mostly do searches for orders and customers. The disk activity is very high, and I was wondering why sql uses only 10 gig and does go all the…
-
Can't Connect to Server
hi guys, I currently test to make SQL 2000 as my Database in NAV 3.7, in my client it will connect fine, but if i go to another computer and try to connect to the server, it could't connect. do i miss some setup? please give some advice...
-
create Nav user
Hello, I need to create new Navision user using only SQL Server (e.g. Management Studio). My client has Navision instaled with one user, for whom I don't know the password. I can't delete this user or chang password for him, so I can't log on and synchronize user id. I have administrator rights in Sql Server. I use nav…
-
Collation Question
I've searched the forum and read the relevant section of the Application Designer Guide, but I still have one specific question about collation. The Application Designer Guide states "We recommend that you use a Windows collation when you create a database. This type of collation closely follows the collation rules of the…
-
Could not run BEGIN TRANSACTION error - Nav SQL
Hi Experts! when I am creating a new purchase order, the following error message is appering on the screen: The following SQL Server error(s) occurred while accessing the Purchase Line table: 3906,"25000",[Microsoft][ODBC SQL Server Driver][SQL Server] Could not run BEGIN TRANSACTION in database 'XXXXX' because the…
-
sp_prepare?
Hi, While running the SQL Profiler trace, I see a lot of delays in the sp_execute command when we ran through a sales order. Doing a quick search on Google, I found that sp_execute is ran after sp_prepare is done (where the SQL code is). However, searching through the trace log, I don't find any sp_prepare? Is there an…
-
Nav 5.0 with SQL Server 2005, while importings objects
Hi Experts! I am facing a problem while importing objects. Error message as follows: Microsoft Dynamics NAV The following SQL Server error(s) occurred while accessing the Sales Header table: 1902,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create more than one clustered index on table 'IFoods_MockDB…
-
Problem Restoring 370 native into SQL 2k
Hi: I'm trying to restore a backup of a native 3.70 database into SQL 2000. I've already check dates and corrected them. When I try to restore the data, the RAM starts getting higher and higher, and it collapse the system. So, I have to reboot the server. Server specifications are: 2 dual core 2ghz, and 4 g RAM, and…
-
Sorting Issues after conversion to SQL... version 4.0
Let's see if I can explain this clearly... There is a production order posting routine in codeunit 5407 (the exact code is not significant) that worked under C/Side but does not work after conversion to SQL. Investigation revealed that the problem is the inherent difference in sorting between the Navision 'code' datatype…
-
Is SQL2000 more clever than SQL2005?
I found a very interesting blog about this that I wanted to share with you. For search reasons, I copy/pasted the text in this thread. Link: http://msdnrss.thecoderblogs.com/2007/09/20/is-sql2000-more-clever-than-sql2005/ Text: I have seen a number of (good) arguments that some issues with Dynamics NAV on SQL2005 are…
-
SQL Server Licensing
I have one customer with the Dynamics NAV Business Essentials Edition. As we know the users in Dynamics are concurrent, I can have 20 users created in the database, but if my license is for 5 users, only 5 can access the system at the same time. The SQL Server license that comes with Dynamics NAV is named user. I don't…
-
NAV5 and SQL freeze in the Sessions window
I frequently experience problems with NAV5 suddenly freezing when looking in the Session table. (Drilldown into CurrentSessions) Has anybody else seen this and maybe even know of a solution?
-
Unable to restore my backup due to missing tabledata
My customer and me are running NAV4SP3 and SQL2000. I have been making some development in my DB that hasn't been given to the customer yet, but for testing purposes I wish to import recent data from the customer in my dev db. I'm just using the NAV backup/restore functionality, and it usually works fine. However; today it…
-
Extended stored procedures SQL Server NAV5.00 vs NAV 4.00SP3
Good morning, somebody knows if the extended stored procedures are different for the two versions 5.00 - 4.00sp3 of SQL Server 2005? I have installed a server SQL2005 with 4.00 sp3 never used and so deletable and I have to swich to 5.00. I don't know if it is enought to restore a db backup of 5.00 or there are others…
-
unused index on sql
Hello Navision erp system have a lot of index. Sql might only use 70 percent of the index. I would like to know if there is a way to get index statistics on how many times they've been used.
-
The timestamp column
Hi all Is the (binary) timestamp column always increased over time - even across records and tables? That is, if I e.g. change customer AA and then change customer BB, will the timestamp for BB be "larger" than the one for customer AA? And is it also the case if I change a record in an other table? E.g. change Contact CC…
-
NASSQL.exe deadlock problem
We have switched from C/SIDE to SQL 2005 a week ago and most things are going well. One problem we are running into is that one of our NAS's keeps on getting deadlock errors and eventually the NAS can't restart (fatal error) We have 2 NAS process's: one post's invoices and the other charges credit cards. The one that…
-
[closed] Dbcc Pintable
Hello i was reading the sql server resouce.pdf and read that you can use the command DBCC PINTABLE to make certain tables to stay in memory. It recommends small hot tables that are used a lot. I would like to know the experience people have had with using this command on navision tables. One of our customer uses the…
-
Show SQL-Server-Log in a view
Hello everybody! I have to implement a table in NAV 4.0 SP3 that shows the current SQL-Server-2005-Log. As far as I know it's possible to implement it as a Table with the property "Linked Objekt = yes" and give the table the same name of the SQL-View that "keeps" the data. So this is a question for all you T-SQL-experts:…
-
SQL Server Replication
We have two databases on two SQL servers DB1 on SQL Server A DB2 on SQL Server B User enters all transactions in DB1. This has to be replicated in DB2. If SQL Server A goes down, users should be able to use DB2 on SQL Server B. When DB1 on SQL Server A is up, we want all the transactions done in DB2 on SQL Server B to be…
-
Is Navision to stupid or is SQL to smart
Currenly I am again fighting with SQL2005 at a customer. Many, many reads on tables whilst there are perfect and selective indexes. Now I've never experienced this problem on SQL2000. SQL always uses the right index for the query. I also know Navision has not changed the communication with SQL. What has happend to…
-
xp_ndo on clustered environment
When you add an extended stored procedure, you point it to the dll, which should be stored in the Binn folder on the C drive. In a clustered environment, you don't have access to the C drive from with the dialog in SQL Server, I'm guessing because if the cluster fails, the C drive is no longer the C drive but the C drive…
-
Login message SQL2005 NAV50CH permission License
Hello, I have the following message when I log in in NAV5.0 with SQL Server 2005 with windows authentication in the case the Windows User has not SUPER role. 229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The select permission was denied on the object 'MYDB$License Agreement', database 'MYDB', schema 'dbo'. I…
-
SQL data type ntext
I can asign the value of a sql field type = ntext to a Navision variabel type Variant and it has the correct value, but when I try to convert this variant to text or bigtext it gets this value ¤ (char 164) Is it because Navision cant find the end of the string ? And how do i solve this ? regards Peter