-
Copying a NAV table via SQL Server
Dear all! I need to solve the following business case: We have several decentralized NAV databases on SQL-Server. Now we want to implement a common master data management process across all business units. Therefore, we plan to implement a few NAV tables which should be sychronized automatically across all SQL-Servers…
-
Reporting Services with multiple companies
Hi all, I'm doing a few experiments with Reporting Services. I've stumbled upon a question regarding multiple companies in one database. How would I, dynamically, create a SELECT statement that would give me e.g. all records from T79 "Company Information"? Something like: SELECT * FROM [*$Company Information] Thanks in…
-
Implementation of SQL 2005 Database Mirroring
Hi Guys, Has anyone who already implement the database mirroring on NAV,Please share your experience. Regards, Sendoh
-
Backup transaction log is too big
Hello, I've not created a transaction log backup for a few days. When I want to backup the transaction log it will create a file of more than 40gb. That does'nt fit on the disk. Is there a way to reduce this transaction log backup size? I've truncated the log file, than shrink the log file and then do a full backup. But it…
-
How can I protect user use other program to connect to MSSQL
Dear Sir I have some problems about user connect to MS SQL with ODBC with others Software and to modify data in Navision .. I need your help that how I can protect it ... Thanks
-
Cannot Restore Data Common To All Companies
Hello everybody, I've created a backup in Native (Entire Database). In the database some tables have the property "Data Common to all Companies" set to No. When I restored the database in SQL the "common" tables are created but no data is stored in it. In the restore dialog I selected the option "Entire Database". I also…
-
Navision with SQL - only database file on server
Hello everybody, I need to know if, on an installation of Navision with database SQL Server, we can only restore the backup on the server of SQL and so have on server ONLY the database file (MDF/LDF) without installing no components of Navision setup (nor client nor other components...). Are there some problems /…
-
How to set autoinc
How do I set the start value for autoinc field so it wont start from the last value I had before clearing the table? Table, Test, 123456700 Variable line, datatype bigint, autoincrement
-
Initializing NOT NULL fields?
Hi, We are doing a data migration and I'm looking into using SQL scripts to copy the data over from the old database to the new one. In looking at the table definitions, it looks like Navision does not provide default values for fields, so if I do a SELECT INTO from another database, I'll have to provide a value for every…
-
Error restoring native db into sql 2005
Hi, when we restored a db into sql 2005.. we get the following error: - The CREATE UNIQUE INDEX statement terminated becaus a duplicate key was found for the object name '...$VSIFT$1' ande the index name 'VSIFTIDX. The duplicate.... I looked into the table, and there are 3 keys with the same sumindexfield, but on different…
-
enumusergroups AND enumusersids?
x64, SQL Server 2005, NAV 4.0 SP2 update 3, installed esp xp_ndo_enumusergroups, pointed it to the x64 version of the dll. When creating a new database, I get an error saying can't find xp_ndo_enumusersids. Now I thought that the sids one is for 3.7 and earlier, and that all we'd need is the usergroups one. Do I need to…
-
[SQL Server 2005 Std Ed + Windows 2003 Server] 64bit -NAV5.1
Hello everyone, I have a customer having a server with Windows 2003 Server and SQL Server 2005 Standard Edition on which we have to add Navision 5.0 sp1 database [only database and not client]. I want to know if it is fully supported and if there are knowns problems or particular configuration to remember. I read that…
-
Available databases list incomplete
Hello, I've a very strange problem, and I hope you can help me with this. I have a environment on SQL 2005 with 2 databases and about 10 companies in each database. I have a couple of users with Windows Authentication and Database Authentication. Now, i have a couple of users that have a problem with switching databases.…
-
Can't get database users to log in
Hi we had a hardware failure and have had to move the navision db to a new server. Whilst we are up an running we can not get our database log-ins to work. I have created a new user in SQL and a new user in nav and sync'd...but to no avail. We get a message "18488,"42000",[mICROSOFT][odbc sql server driver] Login failed.…
-
Nav 5.0 & Minimum Version of SQL 2005
Hi, What is the minimum version of SQL 2005 that I can use with Nav 5.0? Workgroup, Standard, etc.? I want to create a separate server as a development server. Thanks, Mega
-
Navision2.6 and SQL Server 2008
Navision2.6 can migrate to SQL Server 2008??? Thanks you
-
SQL stored procedures, Replacing nav code
HI all, Just as a general point i would be interested in peoples opinions in replacing standard NAV code with stored procedures for large posting or replication processes. We currently have 3 in place at the moment and quite happy with the performance gains that we have acheieved under the new 5.1 client with a 4.03 base.…
-
[$ndo$usrproperty] missing?
Hi can somebody help me please? I've just tried to setup a test v4sp3 database on a new server and when I try to delete one of the objects it fails with an error saying "inavalid object name '$ndo$usrproperty'" This is from a SQL statement that I've traced - "SELECT [sid] FROM [$ndo$usrproperty]" I can login to this…
-
Same database, 2 configuration
Hello, I changed my laptop ! i had xp/sql 2005 now i have vista/sql 2008 i work with the 5.01 ... i just restore my database and navision crash without any error message... could this come from sql ? i'm beginner with sql and I have no clue how to see if the problem come from sql ... i use some automation who are not from…
-
Adding stored procedures to NAV 5 on SQL Server
Hello! I need to integrate an existing web application with an existing NAV5 system, running on SQL Server. Some data need to be fetched from some definite NAV tables and some other data need to be written to other definite tables. Since the web application already relies on Stored Procedures to access another SQL Server…
-
Log File Shrink ramifications
We run Nav 4.0 on SQL 2005. The db is 48GB. The backup is put on a separate disk from the data. The backup has not completed for a few weeks because there is not enough room on the backup disk. The log file on the backup disk is 11GB. The backup runs to 90% complete then errors out. I do run a separate Nav backup to a tape…
-
about sql server
hello i have problem like this. i have database on my local machine. i want to attach that data base to sql server 2005 on different machine. i dont want to shift my database there. i just want to attach database is it possible? how?
-
Upgrade sql server
Hello. I have navision 4 running on sql 2000. I want sql 2005. Do I have to do something special or I just: 1. Backup NAV DB. 2. Uninstall sql 2000. 3. Install sql 2005. 4. Restore the NAV backup in a new DB on sql 2005. What about sql 2008? Thanks.
-
Virtualization of NAV 5 and SQL 2005 Server
Hello, I've read some posts about virtualization of NAV and SQL on VMware. Microsoft doesn't seem to support this environment. But what about virtualization with Microsoft Virtual Server? Many thanks,
-
Calling a SQL script or other solution?
We have sort of integrated another SQL database with the NAV database. When certain fields on the customer card are changed the customer record gets copied to a new table. A SQL script runs every 60 seconds to find these records and imports them into the other SQL database. I would like this to happen much faster than 60…
-
Increase invoice posting performance
Hello folks, I have currently a customer project in which it is necessary to post 150.000 invoices in <= 6 hours. We have very well servers and a storage system with raid 10. So the hardware performance shouldn't be the problem. I need now to increase performance on the software side. I have some ideas but it would be very…
-
User Login Fail on NAV 5.01 with SQL Server 2005
Hi, i have a problem with Windows Logins on SQL: every time a regular user tries to log in, NAV displays an error message indicating that there occurred a SQL Error while accessing the Session Table via dbo scheme. Users with dbo role or admins don't have the problem, though. On the server, the extended stored procedures…
-
Synchronization from SQL?
Hi We have created a new database in NAV with many data in it... we then created some users but before we could Synchronize with the SQL database the client crashed and now we cannot get access to the database... saying that the username and password does not match... We are pretty sure that we need to synchronize the…
-
SQL Error
Hi all, I encounter the following error while I try to drill down to look at the session. 'SQL Error While accessing the session table. 535.22003 Microsoft ODBC sql server driver. Different of two datetime column. Cause overflow by run time. Thank you
-
Problem refreshing form with sql view
I have a sql view. And a linked table. This table views the info of the sql view. I create a form that shows the table (with the info of the sql view). This form is not editable. The problem is: i have filters in this form (user can intro, for example, vendor). When filter applies, many times show correct information and…