-
SQL Server Edition
Hi. I have data of around 55-60 GB, We have around 25 user which can in future go to 50. I want to know which edition of SQL server I will use(standrad or enterprise). :?: Thanks in advance
-
Raid/Alocation unit on new server
Helo guys I have two issues: 1) I have a new server for the Navision Database. It will have Sql 2005 x64, Windows 2003 Server 64. I have 3 RAID 10 systems for the database. I intend to use one for transaction log and I am wandering what to do with the two left: - split the database in 2 (using the same filegroup by…
-
SQL Security Model
What's the difference between the two SQL Security Models, Standard and Extended? Apart from the fact that Extended is slooooooooooow (sometimes several days!) and Standard is fast, the only difference seems to be that users can be synchronized independently when using the Extended model. However, as synchronizing of a…
-
restriction on no. of fields in primary key
Hi, I'm currently doing a migration of a native DB to SQL. I'm using the migration script from NAV (with a little adjustment here and there to kick out some extra special characters). But .... during the restore of the navision backup (taken after the exec of the migration codeunit) I get an error that the primary key of…
-
Corrupted SIFT Values
I noticed that in combination with SQL Server 2005 it happens from time to time that theres a difference in between calculating the Item Inventory (field "Inventory", table item) using CALCFIELDS and summing up the item ledger entry table. It seems that somehow the SIFT tables inside the SQL Server are not updated…
-
Session Table only show own session
Hi, we are running Nav 4.0 SP3 on SQL-Server 2005. We have a strange behaviour here. When reading the session table, only my own session shows up. It doesn't matter if I have super-rights or restricted user rights. Same if I go to "File => Database => Information". On the Sessions-Tab the field "Current Sessions" always…
-
FINSQL License Problem
Iam using SQL Server2000 database. when iam open navision through FINSQL command it takes default cronus license. i already delete the cronus license in c:\program files\MBS-navision\client and server. i put our license. but it takes only cronus. it allows only 2 sessions. when opening navision it shows our license. but…
-
ZUP file settings in SQL Navision
A couple of questions: 1) In Nav 4.0 for SQL, running 4.0SP1 executable, Are the ZUP file settings for a user stored in a SQL table? The reason I ask is, I am logged in as Administrator to a customer's server via remote desktop. I can start Navision SQL and log in as one of the users (katy) and the navision menu is exactly…
-
Security : SQL and ODBC
Usually, permissions to the Navision DB on the SQL side is simply an "all access"-like permission (DBOwner, ...) and it works perfectly, but ... with that kind of permission, an OBDC expert could make a lot of "bad" thinks in the datas. How to prevent that ? In other words, how to restrict the ODBC access ?
-
Altering database of sql 2005 from navision
I am getting an error while altering the sql 2005 database from navision.
-
SQL ,Stored Procedures and DataProviders in C/AL?
hi ADO.NET 1.You use a Connection Object to Connect to a DATA PROVIDER(ODBC/ORACLE/OLEDB/SQLSERVER) at Runtime. 2.You use a Command and DATAADAPTER /DATAREADER object to Run your SQL and Stored Procedures 3.You use the Datasets which give the disconnected functionality to ADO.NET C/AL eg. OnAfterGetRecord():…
-
Bad Dates during upgrade to SQL Nav 4.0
I am upgrading a client to SQL Nav 4.0. their data appears to contain numerous "bad dates" that SQL does not like. Does anyone know of a utility that I can obtain that will search all date fields in all Navision tables and list them for corrective action?
-
Got Seesion error while try to open the database
HI I try to open the Navision database which is on server I got error message ERROR - The following SQL server error(s) occured while accessing the session table 535."22003",[Microsoft][odbc sql server driver][sql server][different of two datatime columns caused overflow at runtime. Can any one give me solution what i have…
-
SQL Backup
Hi, Is it possible to take an SQL Backup while users are logged on to the server. Will that cause any sort of problems to the database. Plz advice.
-
Log File in SQL Server
Dear Friends, One of the client is running Navision on SQL server. Change log is activated and the size of the log has become very large. Client require that the log file should increase upto a particular size and after that it deletes the old entries while creating new entries so that the file size remains the same. Is it…
-
Nav 4.01 and SQL2005 SP1
We are using NAV4.01 over SQL2005. We intend installing SP1 over SQL2005. Is there anyone having already tried this environment? And with NAV 4.03? Thank you in advance
-
Change Log - Custom SQL Triggers
Records are only inserted in the Change Log Entry table by userinteraction within Navision forms and not by codeunits or dataports. Could anybody tell me if they have some bad experience with creating custom Insert, Update and Delete triggers directly in SQL Server to fill a Navision table. This isn't a very nice solution…
-
Retrieving FlowFields by SQL-Server ODBC
Hi everybody! I was browsing through this forum for some time but I didn't find a helpful hint to a solution concerning my problem. I have a Navision-SQL-Database and I'm using Microsoft Dynamics NAV 4.0 SP2. Retrieving the values of FlowFields (SIFTs) by using the "N/ODBC" in a Native-environment is no problem but as I…
-
SQL Server Name and Password
In Navision, we can use USERID for login user id how can i get password and SQL Server Name from navision? thx
-
Linked SQL Server to C/ODBC
Hi! I'm using a Linked Server in SQL Server 2005 to connect to C/ODBC, and it work fine. http://www.codeguru.com/vb/vb_internet/ ... php/c8903/ My problem is when I try to declare a variable (@Timestamp) in my stored procedure, it says "Column not found: @Timestamp". I can't see what’s wrong, any idée’s? Create PROCEDURE…
-
SQL Server 2005 64 bit on NAV 4 SP3
Are there any outstanding problems running the 64 bit version of SQL Server 2005 with Navision? Anyone currently running it okay in a production environment?
-
Collation Change
Hi All We have several SQL servers that interface with NAV. All the servers are running on the same collation (SQL_Latin1_General_CP1_CI_AS) with the exception of our NAV database, which is using Latin1_General_CS_AS. I would like to change the NAV database to SQL_Latin1_General_CP1_CI_AS so that it matches our other…
-
Traceflag 4616
Hi As I understand, traceflag 4616 must be set on SQL Server 2005, regardless whether Nav 4.03 or 5.0 is used. Is this correct? If yes, does anybody have experience with this instance globally flag if other applications are running on the same SQL instance? Or to ask more directly: Could it be a problem for other…
-
Strange Navision Encounter. (BCK/Rest/Upgrade issue)
Hi, I have a very, very strange encounter with Navision 3.7 today. Ok, here's the story. I have a customer with SQL2000, Navision 3.7. What happen is, they have to migrate their SQL2000 to another server. So I backup (Navision backup) from the old SQL2000, and restore it (Navision restore) to the new SQL2000. I restore it…
-
open database
when i am opening the navision which has sql database then it is giving an error: The following SQL Server ERROR OCCURED: 4064,"42000",[Microsoft][ODBC SQL Server driver][SQL Server]Cannot open user default databse login failed.
-
Nav 4SP3 SQL Server 2005 Logins not working
Hi. I have a Navision 4 SP3 database running on SQL server 2005. I was able to get one user , me ,to log into the database. Now none of the new users I create in SQL can open the navision database. I Added the users to the Navision Logins and Syncronizing but navision says the users does not exist SQL. Anny help please?
-
Nav40 SQL Data Type
Recently converted Nav40 to SQL. Is there a utility available that can be used to look at all tables and fields and recommend the setting of the SQL Data Type in all tables? Experiencing major speed issues after conversion to SQL. Several "sorting" issues have cropped up in Account Schedule reports, Manufacturing Prod.…
-
Export Users from SQL Server to Another
Hi All, Is it possible to export all the user from one SQL server and import to another. I'm installing a new database for my client and I need to take the same users from the pervious server. Is this possible ?? Thanx
-
SQL Roles
Hi, I received an error message stating: "8104,"42000",[Microsoft] ODBC SQL Server Driver Error. The current user is not the database or object owner of table %. Cannot perform set operation." I have looked at http://www.mibuso.org/forum/viewtopic.php?t=7262&start=0&postdays=0&postorder=asc&highlight= and noticed that the…
-
Fields moved from table 15 after SQL upgrade ?
I've just runtime-upgraded a Navision 3.60 Native database to Navision 4.02 SQL. Looking in table 15 in Navision everything seems ok, but when I look in exact the same table in the Enterprise Manager i miss the fields: "Net Change" and "Balance at Date". These fields are both flow fields, but I don't know if it has…