SQL General

This forum is for all SQL-related topics: installation, integration, maintenance, security, ... Don't post messages about SQL performance/tuning here: there is a separate forum for these topics.

Change data capture
Has anyone used the SQL Server 2008 Change Data Capture feature to track changes to values in records? The client where I work the most currently uses Lanham's History for that purpose. That works fine, but we are at the point of needing to add more history tables to the license or doing something else. Since the client is…
Database Logins
Hello We have a (test) installation of a database that was migrated from native to sql server 2005. In Nav there are no explicit database logins, only windows logins. However, on the sql server there is a special user (lets call him xy) with server role sysadmin. User xy is able to login with a Nav client to the mentioned…
SQL 2008 and "Rows Data"
Hi, One of my clients bought a new server and installed SQL 2008 on it (64 Bit) and has transferred the db from the current SQL 2005. When I look at the db properties in SQL 2008 I see that the datafile data type is set to "Rows Data" (in SQL 2005 used to be just Data and not even the help for SQL 2008 shows that option).…
SQL 2008 + Navision 3.6 Version
Hi, Currently we are using Navision 3.6 version with SQL 2005 db and now we are planning to upgrade the db to SQL 2008, whether Navision 3.6 version will work with SQL 2008? Appreciate your advice on this. Thanks.
Navision Backup through SQL company wise
Dear All, i have navision 4 DB with 2 companies,i want to take only one company but through SQL not Nav client,it is possible??? Regards
SQL Query for Outstanding amount per item
Dear Collegs, I have one question and hope that somebody can help me. Namely, I need to make SQL query (for SSRS) which as result will have Outstanding amount per item per period. Report should be something like this : Item : SalesInvNo : Turnover : Current : 1-30 days : 30-60 : over 60. Hope that somebody have experience…
How to install chart Generator
Hi All Can any one tell me how to install chart generator. its urgent Regards Shweta
SQL Server 2008 Standard Edition CAL related
Hi all, In case of a hosted solution where SQL Server 2008 Standard Edition is used as a Back-end, do we need multiple CAL license for the end user to be able to use it or one CAL is enough.
SQL Mirror - Client auto reconnect in case off mirror live
Hello, I'm looking for a way that clients (NAV5 SP1) automaticly reconnect in case off that the mirror goes live. Explanation: dbserver : principal dbmirror : restore db witness No connection to the dbserver, so the witness brings the db on the dbmirror live. Now the problem is that the clients still are connected to the…
Replicating a Database for Reporting
Hi All, We are using SQL Server 2008 and Navision as front end. The users dont want to run the reports in Navision from Production DB. We want to create the database for reporting purpose in SQL Server and must replicate Production database to that reporting databse. We need to create a Scheduler for replicating the…
Navision disconnects from Serve when internet dies.
Ok so I had this very odd situation, but it was only ever happening on Vista so I just assumed it as another one of those vista things, that would finally go away when I upgraded to XP. But now I have upgraded, and still I have the issue, so thinking through, the only other common factor is SQL 2008. So I think this is…
SQL 2000 & VMWare
Hi, We have the following: * SQL server 2000 * Nav 2.6 * 32gb database on IBM SSDs We recently moved out SQL server over to a VMWare machine and upgraded to SSDs for our 32gb database. We've been getting performance issue where the database slows down and occassionally the navision client will disconnect. Performance…
SQL join problem
Hi, I am using the following query with a zip bind variable. from Store _a join Pricing _b on _a.storeid=_b.storeid where _a.zip=:zip I get the following error:Run Query error: Unexpected Token: on near line 1 column 59 [from com.wavemaker.gasprice.data.Store _a join Pricing _b on _a.storeid=_b.storeid where…
Unable to find usable Collation - HELP :-(
My customer recently migrated from Native to SQL but encountered several sorting issues. We picked the Danish_Norwegian_CI_AS collation, which we also used during tests. During migration we handled most of the sorting issues by prefixing primary key fields with zero. They had numeric Location Codes with different length…
SQL Report
Hi, I am not sure whether it is right forum to ask this. But i hope you people will guide me on this. but wats wrong in the following query. SELECT [Transfer Line].[Document No_], [Transfer Line].[Transfer-from Code], [Transfer Line].[Item No_], [Transfer Line].Description, [Transfer Line].Quantity, SUM(ILE.Quantity) AS…
SQL Server Technical Kit for Microsoft Dynamics NAV
Source: My Blog Sorry for the poor editing job, but it just takes to long to edit it property :oops: (and it's already quite late). At least the "search" will work :wink: . It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled all tools that are important for SQL Server, and…
SQL 2008 with NAV 4.0 SP2 in Windows Vista ?
Hi all, I've just installed SQL server 2008 and NAV 4.0 SP2 in my laptop which is using Windows Vista (i know..i tried to switch to another version, but failed) anyway, the question is, are those 3 compatible with each other? i read some of threads said SQL server 2008 and NAV 4.0 SP2 are compatible. Is the problem with my…
Service, webservice tier connection a client or device?
Is the service tier connection to the SQL database considered a client or a device as far as the SQL license is concerned?
Move a NAV database to another location! It´s safe?
Hi guys! I want to change my database files to another location. I will try this procedure( but i want to know your opinion - It´s safe to do it on ): Consider backing up the database before you start, in case anything goes wrong. Get a list of all the filenames for files currently used in the database. Do this using: Use…
SQL 2005 Sp3 CU4 installations
Hi, Has anyone used CU4 patch on SQL 2005 sp3? I'm running CU1, but was recommended to upgrade to CU4. If anyone has had and positive experiences or otherwise, i'd like to be reassured that all is well. I'm running Win 2003 64bit, 64 bit of SQL and V5sp1 of Nav. Thanks
Database user acces on SQL2008
Hello, We are in migration test moving from sql2000 nav4.3 on sql2008 nav 5.1 I took a Navision Backup and restored it on a new empty 5.1 database with standard security model on our sql2008 server. I synchronized the security. Login with windows login works fine but I can´t login with an sql server login & password. I…
After converting sql database, tables name are different
I had an MSDE backup, and restored it into a 2005 SQL express database, Now when i look at the tables in SQL Server Management Studio, they all look like this. dbo.FA41100 dbo.FA00500 dbo.AF50001 dbo.BM30100 etc etc I am not sure why this is, but unless i export out each table into excel, I don't know what table it is…
SQL Login import single user AD or group.
Hi people, i wont organize my SQL Logins with Dynamics NAV. what is best? 1 -Create a SQL Login that has a Active Directory Group call ( p.e ) NAV_ALLUSERS and import on the Active Directory all users that should have access to Dynamics NAV? 2- Create a SQL Login for each user that is on Active Directory on SQL Server…
No Clustered Index
hi everyone, as you can imagine from my recent threads, i'm messing with a test db in order to investigate indexes and SIFTs occupation/performance in a 4.01 sql database (45GB) in "SQLIndex" thread i recently posted here, i learnt something about bookmark lookup on clustered indexes and some other stuff, therefore i…
Import Data from one into another SQL2000 Database
Hello, i have already used the forum search but i have not find the right solution for my problem. :cry: our firm has one server with two SQL 2000 databases. Now we have the problem that we want to import data from the first into the second DB but i have no idea how i can solve this problem. And we dont want to do this for…
Automatic SQL Backup/Restore
Hi guys, I'm trying to think of a good way of automating a backup/restore of a SQL database on a weekly/biweekly basis. Anybody know if this is possible through a SQL script or similar, or have any examples? Any help would be great. Thanks.
Restore incomplete
Using SQL Server 2008, we cannot get restore to restore objects (other than tables) and data common to all companies. I was able to create a company, restore Cronus from backup, and everything worked perfectly. But not so with the live db. There is no error message, only the usual message about the restore being completed.…
NAV 5.02 Stored Procedures SQL
Hi, I'm getting an error when i start my NAV Client: 17750,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL "C:\Program Files\Microsoft SQL Server\MSSQL.10.NAV\MSSQL\Binn\xp_ndo_x64.dll, or one of the DLLs it references. Reason: 126(failed to retrieve text for this error. Reason 15100). SQL:…
new SQL instance with NAV
Hy people, does anyone can help me please? I've installed SQL server 2008 and NAV 2009. Also i have two instance of sql server. Problem is that when i want connect to named instance, my client doesn't see it. I can connect to default instace and all works fine, but when i trying connect to named instance i get message…
Windows Essential Business Server 2008 Premiuminc SQL
Has anyone implemented nav on the Windows Essential Business Server 2008 Premium edition which includes the free the sql small business edition? Any positivies or negatives about doing so ?

SQL General

Discussion List

Categories