-
Native -> SQL Server (Date check)
Hi, could anybod please help me with the date check in the native database? Is there a routine to find out, in which tables incorrect date fields exist? The restore of a native backup failed at 55%. So I have to correct the date an make a new backup to restore it in thesql server. Thank you very much for your help!…
-
linked server between sql server and access proplem
Hi guys i want to make linked server between sql server 2005 and office 2010. (I try to access The Microsoft Access database from SQL server)but sql server 2005 connected to domain but Microsoft access work as work group computer not connected to domain . is possible to connect between each others and what i write in…
-
sp_createstats
I am running the following script daily: exec sp_updatestats go exec sp_createstats 'indexonly' go The sp_createstats raises an error: Msg 1927, Level 16, State 2, Line 1 There are already statistics on table 'XXX$Detail Line' named 'B-Account'. If I set the property MaintainSQLIndex to NO on the specific key. The script…
-
Error with Logins
Hi I have a strange issue. When adding, deleting a user, also when trying to sync we get this error: 15138,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The database principal owns a schema in the database, and cannot be dropped. I have found this, but its not fully clear to me: viewtopic.php?f=23&t=48458 NAV…
-
SQL Server 2012 SP1
Hi there Is there already a recommandation concerning the compatability of NAV 2009 R2 (Classic Client) with SQL Server 2012 SP1? Thanks in advance Thomas
-
Multiple NAV connections to Master database
We have seen this issue on 3 different systems so far. All 3 sytems are running NAV 2009 R2. However, it's been 3 different NAV clients. One site is RTC. The second is NAV classic. And the third is happening with an NAS sessions. The issue is that, when lookign at the sessions, there wil be multiple connections to the…
-
Drop or modify index in SQL-Server, but not in Navision
Hey, I have a question regarding the dependencies between Navision and SQL-Server. What would happen, if I for example would drop an index in sql, but would not deactivate it in Navision or if I add a new field to an existing index only on the SQL-Server, but not in Navision? Would this be a problem for Navision? My first…
-
SQL ver 8.00.194 migrate to sql 2005/2008 32 bit
it is possible to migrate SQL ver 8.00.194 database direct to SQL 2005 of SQL 2008 32 bit version? SQL ver 8.00.194 support to windows 2008 32 bit ? help? regards BS
-
Microsoft SQL Server 2012 certification exams
There are three exam for Microsoft SQL Server 2012. They are 70-459, 70-465 and 70-466 exams. I have both 70-465 and 466 materials and recently looking for 70-459. Anyone can help me?
-
Import and export to more tables data in sql server 2005
Hi guys I have database have 20 table name AA and sql i have is sql server 2005 can i make auto processes import and export by ssis to data only.because what i want to is moving data from database to another database. and this two databases not in same place and no network between two databases meaning every one work…
-
Difference between SQL and SQL Express
Hi Everyone, What is the difference between SQL and SQL Express??? Please explain. regards, Anand tiwari
-
Two SQL versions installed - How to manage?
Hi everyone, I started working with NAV 2009 R2, having SQL Server 2005 SP3 installed... Today, I installed SQL Server 2008 R2. I wanted to ask how can I , from now on, when I need to restore a backup, select which SQL Server to use??? And what about the existing databases (in SQL Server 2005)??? Shall I simply restore…
-
Error 229 - Permission denied
Hi I am upgrading a Navision 3.70 database to Dynamics NAV 5.01SP. My method is a bit rude but it works: first, I create a native backup of the original database (in a fbk file). Then, I create a new database in NAV 5, and from there I restore the old database. Well, all seems to work fine: all functions are restored and…
-
NAV Table access outside of Role permissions
Hi, we run NAV 5 SP1 on a SQL 2005 Database with Enhanced Security. Everything seems ok but I've come across a strange issue that I hope someone can help with. Our users have a Windows AD Login account to access NAV and the NAV Roles are assigned to Windows Groups instead of the individual user accounts. I've noticed that…
-
Minimal security setting to see all sessions
NAV 5.0, SQL Server 2005. My user is set up as db_owner of the NAV database only, and I can only see my own session in 'Current Sessions'. This has been discussed before, and I can make it so I see all sessions by giving the user 'serveradmin', but I am wondering if it is possible to do this without a server role. I've…
-
Transfer Logins to lower version SQL
Hi All, Is there T-Script like sp_help_revlogin to transfer logins from SQL 2008 R2 back to SQL 2000? I am only able to find the other way (SQL 2000 to SQL 2008). :roll: Rgds, Angelo
-
Stored procedure/NAV
I am using NAV 3.7 to execute a stored procedure residing on sql server 2000. The stored procedure executes fine on the sql server, however when I tried to run the report, the error occurs: lADOParameter:=lADOCommand.CreateParameter('@TemplateID', 200, 1, 20, vTemplateid); lADOCommand.Parameters.Append(lADOParameter); <--…
-
database server authantication problem in SQL option SP3
I install sql 2005 and create database using sql option . I create super user in sql and then create super user in navision. But when I am trying to login with super it shows me error Any body got this type of error. Please suggest any soln.
-
SQL Restore Options
Hello We have an automated script that backups the production db and restores it in a staging db on the same server. We use the restore command with the "WITH MOVE" clause. So far, so good. It would be nice if the logical filename could also be changed, otherwise the logical file name of the staging db would be the same as…
-
SQL Loop
Hello I try to select a value from a NAV table through SQL script. This is not very complicated, but I try to do that dynamically for every company in the db. Has anybody done something like this and would share parts of the code (loop and variable table name of a given table because of "CompanyName$TableName")? Thx in…
-
SQL Kill Session script on NAV 2009
We have a SQL Job that run every min to kill idle user from NAV 4.0 running on SQL 2005. When we transfer the same SQL Job to NAV 2009 running on SQL 2008, this SQL job no longer function. Is the Command for Transact-SQL script require any modification for the newer version? zsp_KillIdleUser 20, 30, 'CG Live', 0,…
-
how to find out vendor entries without tax
Hi! Can somebody tell me as to how to find out the vendor entries that do not carry any tax? Is there any such filter in Navision?
-
NAV integration with SAP BOPC / Oracle hyperion
Has anyone made a integration between nav and sap bopc or oracle hyperion? Which approach do you suggest? Make an SQL job to extract the data and send, or a .net app? which of the 2 dw tools is the best for integration with nav 2009?
-
Select Permission Error
Hi, We have a user who is setup as windows authentication and has had no issue logging in to NAV using that. We have now created a new company and added him in and synchronised his user but he is getting select permission error as below. 229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] the SELECT permission was…
-
Error while using Trigger forinserting data in Linked Server
Hi, I am created a trigger on SQL Server's table for inserting data into a table on Linked Server and getting following error: 7391,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "ServerName" was unable to begin a distributed…
-
SECURITY: Secure NAV Employee data from Excel ?!?
Hi experts, I used the search, but found no topic about my problem. We use NAV 2009 with SQL 2008 and build up our role concept so nobody (instead of the HR crew) can look in our Employee data. But the problem is that any User with a little experience with Excel know the "Connect to database" function. How can we block the…
-
How to prevent users from connecting to the DB server?
Hello, I wonder if it is possible to prevent users from connecting directly to the DB server (eg: in a program - or worse - via the SQL server management studio itself). They must be able to connect via Navision though :) Only special roles / logins should be able to execute / select on the DB server itself All other users…
-
Error while restoring (SQL Migration)
Hello All, I am trying to migrate from FDB to SQL Server. I took a backup of the live database and did the followint: 1) Restored the FBK as FDB on a test environment 2) Ran a full database test 3) Used migrate.fob from Upgrade toolkit and made all necessary corrections to make the DB SQL Ready 4) Took a fresh fbk of the…
-
ODBC + SQL Navision database
Hi guys, Can somebody tell me how to give a user ODBC rights to a navision database (SQL 2005) without giving the user DB_Owner rights ? Without the DB_Owner rights, the user is getting the error message "Select permission was denied the object xxxx$yyyy". I don't think it's a good idea to give DB_Owner rights to a normal…
-
Log Shipping to SQL Azure for backup purposes
Here's an interesting scenario. One of my customers wants to have a backup of their database in the cloud, and was asking whether it is possible to log ship an on-premises SQL database to SQL Azure, and use it as the source for disaster recovery. If their on-premises server goes down, they would take a backup of the SQL…