-
sysobjects
Hi expert, what is the sysobjects? when I tried to check table with BCC CHECKTABLE ('sales header'); it shows error: Could not find a table or object named ' Sales Header'. Check sysobjects.Thank you!
-
SQL and Oracle
what is the exact difference between SQL and Oracle and which one is better from job prospect. Can you give me some more information please.
-
UK Time Zone
Hi, My web orders are coming with 1 hr. difference we are hosting our own website any idea how can i fix this, must be somewhere in SQL mgmt studio ? Thanks Ajay
-
Backup Restore Error (SQL SERVER 2008 R2)
Hi, When i am restoring the DB ,getting Error Message like this, ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that…
-
NAV Code and SQL Procedure in same transaction
Hi all, 1. Do some NAV code that inserts some data 2. Call a stored sql procedure with automation that should have access to the data from 1. There should be NO commit between 1 and 2 because when a error occurs it should roll back the hole thing. Is it possible to access uncommitted data in an sql procedure? SQL Server…
-
Warning when install SQL Server 2012
Hi expert, in the middle of the installation of SQL Server 2012, everything was fine except that there was a Warning beside the firewall. I had all of the ports open for the inbound of firewall and tried to re-run, but it still showed the same warning. I ignored it and had it completely installed. Will the warning reflect…
-
Restore Database
I am trying to restore the database in SQL Server 2012. I logged in under SQL Server Authentication, not Windows Authentication in the management studio, backed up the database and then created new database . After the data were restored to the new database, it had an error as below. Please advise! Thank you! Restore of…
-
Login failed
Hi expert, I have an error when trying to login. Error 18456 user login failed in SQL Server authentification, but window authentificaiton works fine. Please adivse! Thank you!
-
Copy database
Hi, I copied company database and restored on my laptop for some testing. but I can't open the database - login failed of-course domain and user is different from company server I have tried my best to give dbowner for database to local admin etc. I can login on my other database but still can't login on this database. it…
-
Error in Event Viewer
Hello, When looking in the Event Viewer at the SQL server every evening the same messages and errors are shown between 22:05:00 and 22:08:00. The following messages are shown for every database: "I/O is frozen on database <database name>. No user action is required. However, if I/O is not resumed promptly, you could cancel…
-
Connection Problem
Hi expert. Recently I installed the SQL server 2012 and NAV 2013 demo database. It ran for a week and suddenly from yesterday, it didn't work. I cannot open the demo database and it says I don't have permission. I cannot connect to database engine of the SQL Server Management Studio which throws erro 233. I checked the SQL…
-
Windows Authentication Error Message
I am receiving the following error message while trying to login with windows authentication (SP2). I have created the stored procedures and copied the xp_ndo.dll file into the proper location. Has anyone ever seen this before? The following SQL Server error(s) occured: 17750,"42000",[Microsoft][ODBC SQL Server Driver][SQL…
-
About statement- LOP DELETE SPLIT
hi, Anyone knows what does below statement do? will it change the data inside database? taken from: [http://social.msdn.microsoft.com/Forums/sqlserver/en-US/e64f6f30-fd62-4ac4-b8bf-bef98b85ecbe/how-do-i-view-the-transaction-log-in-sql-server-2008] SELECT * FROM ::fn_dblog(NULL, NULL) WHERE operation = 'LOP_DELETE_SPLIT'
-
SQL Database Configure
Hi Just need some advice before I make any changes on my database NAN 4.03 on SQL 2005 with 250 users and db size is 500 gb Currently database is on Auto-grow - Should i change it to manual ? Database is 95% full, should it be something between 70-80% ? Navision Security is Enhanced - Should it be Standard ? Currently NAV…
-
Master Data Services SQL Server 2008 R2
Hi, I'm posting this message to see if anyone has had experience with the Master Data Services that come with SQL Server 2008 R2. I know of a solution that manages master data from within Navision: http://www.to-increase.com/en/Solutions ... ement.aspx This solution is integrated into NAV and calls the Business logic, but…
-
Unable to synchornize navision user with SQL
Hi all, I would like to transfer user from LIVe database to test database(both using sql 2008), so i run sp_revlogin to export out users from LIVE. test database have existing user in sql already (the user lists was updated 2010). NOTE: I am not SQL trained.. :( Few questions I am not sure. 1.Do I need to delete all…
-
Find out Build from SQL Database
I wonder if there is any way to find out the NAV Build from an existing SQL Database. Something like an SQL Script who shows the Build Number. I´ve got an SQL backup of a Database and I don´t know the associated Build I could open it with. :-k
-
figuring out deadlocks
hi, So this one installation is getting a lot of deadlocks. Most of them are on Reservation Entry. I can catch them with Profiler, but the graph shows somethings strange, both SPIDs requesting exact same KEY. How can I figure out the lock order of previously locked tables? Half of the queries are called through WebService,…
-
SQL Triggers And Navision 3.7
I have created this trigger which will update my table (non-nav table) on insert. However, it causing error on posting journal: Item Ledger Entry already exists. Identification fields and values: Entry No.= '<Entry no>' The trigger is basically reading the INSERTED table and update my non-nav table's quatity field or…
-
Two rows with ecid=0 for one NAV user in sysprocess view
Hello, I have SQL log table with informations about users logged to NAV (version 5). These informations are from SQL view sysprocesses. In very few cases there are two rows for the same user, the same spid and host. User is logged to DatabaseA with NAV client, so why there is the same connection with the same spid to…
-
Navision Windows login not authenticating
Hello all, Last week couple of our Navision Windows Login users lost connection to Navision. They are getting the below error when they try to log in: "15161, "42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot set application role '$ndo$ar$000...' because it does not exist or the password is incorrect I've tried…
-
Cannot create new Windows Login on SQL - User allready exist
Dear all, I've several problems on development databases. If I want to create a new Windows Login in NAV I get an error message from NAV/SQL telling me, that the user or group allready exists on the server. In fact I have checked, that this user is not existing on the server, but after the error message I find a new User…
-
Moving NAV-SQL-DB to new Server - SQL Error 1088, 42000
Hi All, a bit mysterious I recently set up a new SQL-Server, same OS and SQL-Versions like the old one: Win2008R2-64, Sql 2008R2-64, same patchlevel. Same xp_ndo_x64.dll, same startup flags. I restored a sql backup of a NAV-5 DB from the old one on the new server. For a couple auf days, everything worked fine. Then we got…
-
Insert into SQL --> Access
Hi @ll, I have a query in access (office professional Plus 2010) and exactly the same query in SQL (Server 2008 R2), if I run it from SQL inserts the data in the table perfectly but if I run it from Access I get the famous "Microsoft Access set 0 fields to Null due to a bug in the type conversion and added 732 records to…
-
SQL Server 2008 R2 - Standard Vs Enterprise for Nav 2009 R2
Hi All, I am working for a client and we have currently installed Nav 2009 SP1 and SQL Server 2005. The management is considering a complete upgrade of hardware and software. We plan to upgrade to Nav 2009 R2 and SQL Server 2008 R2. We are currently debating on whether to implement SQL Server 2008 R2 Standard Edition or…
-
Solid State Drives
I am looking for some feedback from people out there that have NAV systems running with SSD. While I appreciate all feedback, I am not looking for what you may have read or heard. I can and have done lots of reading myself. And also have experience in non-NAV environments. I'm looking for feedback from people that actually…
-
Grant All User to view Server State
Hi All, I need to transfer all users from LIVE to another Server. Export part was done using query: exec sp_help_revlogin which will provide a lists of login id's and password. i copied this to a text file. CREATE LOGIN [BruceLee] WITH PASSWORD = 0x01002A52EF6D9FBDB5DC11780391626B2DD9E3E2511F46138952 HASHED, SID =…
-
Installation license for NAV SQL version
I need to install a new license for a NAV SQL version (NAV2009) but it doesn't let me to upload the license. The error I'm getting is that I don't have the permission to run the 'Per Database' License System. The current license might not have the 'per database' granule. But how do I install the new license? The option I…
-
Login in navision fails: The SELECT permission was denied...
Hello, I have SQLserver2005 with Navision 4.0SP3. When I try to log in with a user (who does not have dbo-rights) , I get the following Message: The following SQL Server error(s) occurred while accessing the Object table: 229,"42000",[Microsoft}[ODBC SQL Server Driver][SQL Server] The SELECT permission was denied on the…
-
Looking for DBMS tool to connect to Nav2009 Native
Can anybody give an advise for a freeware (or cheap-ware) Database Management System (DBMS) tool that can connect to Nav2009 native database, for instance via the NODBC driver. We used to use Microsoft Access for this. But we have some tables with many records for which an Access query takes very long (sometimes a few tens…