-
Navision Recovery
Hi, If you needed to perform a restore due to a disaster, what would be the steps to get a "company" up and running? We are using Nav 5, on SQL 2005 and also run Reporting Services. All backups are been performed by BackupExec. 1 job for all files using Advance Open File Agent and 2nd job that uses the SQL Server Agent to…
-
How to know computer name that access SQL Server via remote
Dear all, When I am on computer A, I remote computer B and open Microsoft SQL Server Management Studio (SQL Server 2005). On computer B, I have used 'sys.dm_exec_sessions' and got the result that the host name is computer B. How to know that SQL is accessed from computer A via remote access with SQL query? Thanks before :)
-
Connect using SSL
We have a client asking why we don't use SSL to secure the connection to their SQL server. :-k I have looked at the Hardening Guide, but it doesn't mention anything about it. Does NAV support it? If so: Is there a guide somewhere? Does it noticeable affect performance?
-
sql backup process
Hello A client of mine has setup backup process the following way. Doing a full backup nightly and doing differential backup hourly. They are in process of creating a new test environment and I suggested to do a sql backup and restore, which would be faster than native. One of their IT wrote back that we should make a copy…
-
Show records if SUM does not return any records
Hi everybody. I'm trying to write a view that will also show 0 in a value even if the SUM function does not return any records. I'll try to explain by an example. SELECT TOP (100) PERCENT dbo.[BAXT AS$TS Shops].EntryNo_, dbo.[BAXT AS$TS Shops].ShopName, dbo.[BAXT AS$Tradesolution].ItemNo, SUM(dbo.[BAXT…
-
SQL Permission Problem Navision 5.0
Hello, After being investigating this problem, I cannot find a solution for myself. When I try to use the new Send to Microsoft Office Word function in NAV 5.0, it goes OK if the user is dbowner, but if the user is public in SQL, I obtain a SELECT denied error for table 2000000067 "User Default Style Sheet". If I try to…
-
SQL server 2005 / SQL server 2008 behaviour versus C/AL Code
Situation: We have taken over a customer of another Solution Center. A codeunit was written to run some jobs from the job scheduler executed by a NAS. This codeunit contains a loop where fields are updated which are in the current key (The famous Next from Hell). As the example below: recCust.SETRANGE("Country/Region…
-
Join Sales Header & Sales Invoice Header
How can I join the Sales Header and Sales Invoice Header in a single query and only return a distinct selection of order no's? I started with an Union query but it is not getting me a distinct list of all orders. Here is what I have so far: Select SIH.[Order Date], Case SIH.[Order Type] When 0 Then 'Catalog' When 1 Then…
-
SQL Server Disk Array Configuration
I guess this has probably been covered before, if so please accept my apologies, but we are setting up a server which will be used to upgrade a Nav 3.70 database (which has already had a technical upgrade to SQL 2008) to Nav 2009 and will be then become the permanent home of that database. Hardware is as follows: Server:…
-
SQL Server/Database Auditing
Has anyone implemented SQL Audit on a system hosting NAV? if so, any issues?
-
Procedure,Function SQL server - VB.NET
Help me: create procedure sp1 @giatri bit, @output nvarchar(max) OUTPUT as begin if @giatri set @output='OK ' else set @output='Failse ' end create Function F1 @giatri bit, returns nvarchar(max) as begin declare @output nvarchar(max) if @giatri set @output='OK ' else set @output='Failse ' return @output end In VB.NET sp1…
-
Error while installing the SQL Demo database
Hi all, This is Santhosh Kumar ,Please go through the Attachment that is the error i am having while installing the SQL Demo Database (NAV6) into my system . Please provide solution for this issue. Thanks in advance Thanks & Regards Santhosh Kumar Korada
-
help me create UNIQUE Constraints
I want: on my table (Department_ID nvarchar(2),Possition_ID nvarchar(2)) never occur: exists SELECT Department_ID FROM MyTable WHERE Possition_ID = '00' GROUP BY Department_ID HAVING COUNT(Possition_ID) >= 2
-
SQL View
Hi I've created a view in SQL 2008 SP2 for usage in Navision 6.01. The view actually works, but I'm not sure that I've designed the view correctly. The main idea is to create a customer list which also shows the balance of the customer. When I created it in Navision it was very slow, but with this it's quite fast. Any…
-
Compatibility of Dynamics NAV with SQL Server 2008 R2
Hi there, is there any official statement available (from Microsoft) regarding prerequisites and compatibility of NAV with "SQL Server 2008 Release 2" ? Same actually applies to "Windows Server 2008 R2" ... Cheers, Jörg
-
Don't use SQL to Update/Insert/Delete a Nav Database?
Hi, I've been warned against using SQL to populate a navision database - is this the case or do I just have to be careful. Here are some of the things I've done: - Set "Maintain defaults" to true - Made sure transfers into Code fields are all CAPS - Been careful about what associated tables/fields would be affected by…
-
Inventory field
In SQL BD where´s the inventory field of the item table, in other table¿?, and how to use it. This type of fields i watch that the use is diferent at the nav in bd propietary.
-
Problem Replication sql2005/navision 50sp1
Hello, I'm implementing the replication process between two servers/istance. The database is Nav5.0sp1. The connection between two server is unstable. Some errors occurring during the process to replicate the first snapshop in the server subscription. It's Snapshot Replication method. i.e: "TCP Provider: The semaphore…
-
face problem when create the SQLmaintenance plan
when i try to create the maintenance plan in sql, i face an error,kindly refer the attach image file
-
NAV and SQL database backup
Hi all, my company now is going to start the NAV 5.0, for the database backup, can i just backup the database in SQL management studio ? or i need to backup both include backup in NAV program ? please advise , thanks
-
Technical Migration and zup files
Is there a way to make a technical migration (SQL2005, client nav4.1-->client nav5.1upd2) and maintaining the old users' zup file? Thank you in advance
-
SQL Report locks NAV Table
Hi, actually I have a customer that has problem with a sql report (SQL Server 2008) that locks a table in MS Dynamics NAV 2009. Although the report is quite complex, it only reads records from the database, there is no write process (tested it with SQL Profiler), thus I don't know why the table gets locked. Is there a way…
-
Switching from Enhanced to Standard Security
I would like to switch a databsae from Enhanced to Standard security in a NAV 2009 database. These are the steps I have: 1. make sure no one is in NAV 2. set db to single user 3. switch security model 4. unclick single user 5. sync security Have I missed anything? Any othe gotchas I should be aware of?
-
NAV Synchronization
Hi, I am using NAV 2009 SP1 with SQL Server 2008. I would like to ask a few simple questions with respect to Synchronization. When is Synchronization exactly required in the NAV db for the following scenarios: 1. When new user is created in the NAV db and roles assigned to the user 2. When the permission in a specific role…
-
SQl Server 2008 vs NAV 2009 vs NAV5SP1 login issue
Here is my situation. I have a SQL Server 2008 box with both NAV 2009 and NAV 5SP1 DBs attached. I created a SQL (not windows) login and gave it the "public" role for both NAV DBs. I opened each NAV DB and created the DB logins for the account there and gave it the SUPER role. In both cases, I have login problems: On NAV…
-
SQL-Server 2008 with NAV3.70
Dear all, we are going to setup another SQL Server for one of our Navision databases. The Navision version of it is 3.70. We would like to use the current MS-SQL Server version 2008R2 with MS Windows Server 2008R2. Does anyone has experiences with this combination or let me know where to find a compatibility reference ? I…
-
Users unable to login on some computers
Hi, our customer has nav 4 with 4 sp3 client and SQL 2005 database. Recently one of the new computers arrived with win7. Sp3 client with rollup were installed. When navision@win7 was trying to connect to SQL an error message about setting trace flag T4616 appeared. Trace flag was set and nav@win7 worked fine. However, some…
-
Enterprise Manager not appearing
Hi, I have installed SQL Server 2005 express edition in Windows XP Prof environment. After installing, i dont find the Enterprise Manager in the menu although all other things have been installed. How to get the Enterprise Manager.. Plz help
-
xp_ndo_x64.dll Registering Extended Stored procedures
Hi I've had this problem a couple of times. I think it may be related to SQL 2008. I've manually added the extended stored procedure and the server seems to accept them. Then when I go back to view the setup the DLL property is blank. OS Windows 2008 (64-bit) DB SQL Server 2008 (64-bit) NAV 2009 (classic client used) Has…
-
SQL Server 2005 on Win 7 Home Premium
hi all, I want to ask several questions arround SQL Server 2005 & Win 7 Home Premium 1. can SQL Server Reporting services work in Win 7 Home Premium? 2. what should i install in win 7 home premium before i can access all facility using Dynamic NAV 2009? (like RTC ,etc)