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.

SQL DB Connection Error
I've attached a backup of the SQL DB into SQL and i've added the same DB user to the database but m problem is that when i try to map the DB user to the NAV DB in SQL it wont let me as it says that the user or group already exists in the NAV DB, any ideas how i can map this DB user to the NAV DB?
language caption quering OBDC -SQL
Hi to everybody: I upgraded a customer from native to SQL and he was using native ODBC. right now he can use but all the caption fields are in english, and he wants them translated in Spanish ("as it was before upgrading"). I have read a post by waldo, suggesting about "maintain views", but when I click it, I get an error…
ADO - SQL Server - data type - Error
Hi @ll, I have the following problem. This is the Error Message:Dieser Datentyp wird von C/SIDE nicht unterstützt.Sie haben Zugriff auf Daten der folgenden Datentypen:VT_VOID, VT_I2, VT_I4, VT_R4, VT_R8, VT_CY, VT_DATE, VT_BSTR und VT_BOOL and this is my Codeunit: VARADOConn@1000000005 : Automation…
ADO Recordsets and SQLServer Type 'Decimal'
I have to access an external database (SQL-Server) from inside Navision (4.00). I use Microsoft ActiveX Data Objects 2.8 Library to do the job and everything works fine, exept one thing: When I try to get a SQL-Decimal (9-bit float) into a Navision-Decimal (8-bit float) I run into an error telling me that these types are…
migrating Navision database from SQL 2000 to SQL 2005 !
Hi I am moving my Navision 4.0 SP3 database from an SQL 2000 server to a SQL 2005 server. on my new server I have created the same logins in SQL 2005 that exist in my navision database. after moving the database I have sync'd the user logins from within Navision (Tools->Security-Syncronize All) I am now able to open the…
Unable to create new NAV db (sql server)
Hi I would be grateful if someone could advise what i am doing wrong as i am trying to restore a db, but to do so i first need to create a db... When i go File < DB < New i have 2 options either SQL Authentication or Windows. When i select SQL Authentication i get a message saying that 'The combination of user ID and…
SQL Server Reporting Services and NAV
Hello, I was wondering if anyone out there has any tips, dos/don'ts regarding using SQL Server Reprting Services and NAV together. Also, I was searching for some sample SQL Server Reporting Services reports for NAV and could not find them. Does anyone have a link? Thanks and have a great day! gad1
Starting with SQL reporting
Hi, Please suggest good websites where i can learn SQL reporting from scrach. Thank you... :)
NAV 5.0 sp1 ERROR Key may not exceed 252bytes
DB: NAV 5.0 SQL Cliente: NAV 5.0 sp1 SQL I have this error when compile one table, http://img59.imageshack.us/img59/1779/79339221gw8.jpg This key it's from an Add-on to NAV and in the NATIVE DB it worked fine, also in NAV 4.0 sql and NAV 5.0 it worked too, I just got this problem after the client upgrade for SP1. I already…
Error recreating a user on NAV
Hi all, Am having the following problem when trying to reCreate A user on Dynamics NAV 5.0 that uses an SQL 2005 Database. Sorry but am using a french version of SQL Server 2005. Here's my own traduction of the two first lines : 2714,"42S01",[Microsoft][ODBC SQL Server Driver][SQL Server]An object named 'UserZ' already…
NODBC Problem when sending the data between 2 DB's
Hi, I had one problem. we are using SQL Server2005 with two data bases. I want to transfer the data from one DB to another DB. I created two DSN's for two DB's. I created Conn type as Automation " Microsoft ActiveX Data Objects 2.8 Library'.Connection " i can transfer the data from one DB to another DB. I wrote this Code.…
by SQL database
Accordingly, we need to add xp_ndo.dll and a new group before using Windows authentication. My question is the server is using a named instance instead of default, will the same procedure (switching to the new named folder) still applied ?
Error Opening ADORecordset to Retrieve Flowfield from SQL
I have a report which connects to multiple DB's on SQL Server using Microsoft ActiveX Data Objects 2.8 Library. It calls a stored procedure from the SQL Server which returns a table of records from several databases. The report works fine but it throws up an error when I try to retrieve a flowfield. On the SQL side I've…
SQL 2000 database maintenance
Hi, We have a mix of Nav 3.x and 4.0 databases on MS SQL. Some of these are a few years old, and in active use. Everything seems OK. Although performance is not an issue, I have noticed database sizes seem to be growing, at rates which do not seem reasonable, given the data that is changing. For example, one database is…
Very short questions about NAV - SQL Server Option
Hi, Are this statements true: 1. If I have no Active Directory I can't use "Windows Logins" 2. If I use "Database Logins", I have to create the user logins in the SQL Server first
Nav 5, SQL 2005 on seperate servers
I have been using Nav 3.60 with a native db for years. We are about to install a completely new Nav solution using Nav5 and SQL 2005. The supplier has quoted for new hardware, but I am unsure why the supplier is quoting for a separate server to run Nav5 on. I've read in the forums about the SQL server specs and performance…
Ecellent article about transaction log
http://www.sqlservercentral.com/article ... ory/63350/ For those of you who have always wanted to know about the transaction log but were afraid to ask.
Impact of removing checkmark from - Validate Code Page
Hi, What could be the impact of removing a checkmark of "Validate Code Page" from Alter Database form (Collation tab)?
views and security problems in navision
Following scenario: DB A :4.0 navision with standard security DB B :4.0 navision with standard security Both on sql 2005 In DB A: views to retrieve data in DB B. Views defined as linked tables in navision User X , super role on both databases, not db_owner. When user x opens linked table, sql error no priviliges. According…
connect to Navision
hello, I have SQL Navision client instaled outside local net. I use VPN with firewall. Which port should be unlocked to connect ?
Putting seperate company data into seperate .ndf files
Hello, Is there any way for putting seperate company data into seperate .ndf files? (SQL Server secondary data files)
Connection error check
Hi guys, I have a question regarding connection check. We use ADO connection to database outside NAV and we sometimes reached error (timeout) during connection. Is it possible to check connection (via C/AL code) without raising an error? Thanks for your responses.
Hardware Setup for Nav 4 sp3
Hello I am about to upgrade my server with the following specs OS: Windows Server 2003 x64 DB : Microsoft SQL 2005 2 x Intel XEON 3.6GHZ 16 GB RAM Intel SRCU42X Dual-channel, Ultra320 SCSI RAID Controller 64-bit/133MHz I am trying to decide on HDD configuration and came up with this 2 x 146GB - OS & SQL Server Partitioned…
Granules for SQL database
Hi Which granules I need for SQL database? My customer has only 2,010 Server - Microsoft SQL Server Option Do I need any other? Second question, what about SQL Server? Should I buy Microsoft SQL Server 2005 or there is any cheaper option? Thanks in advance ;)
Profit and Loss via Reporting Services
Good afternoon all :D (well in australia anyway), Using Navision 4 SP3 on SQL 2005. I have been asked to create a Profit and Loss report in Reporting Services (so that non Navision users can run this report rather than having to run via Navision). After something like GL Account MTD MTD Diff $ Diff% YTD YTD Diff $ Diff%…
Nav SP1 role permission
I try to implement role for user that he/she could process sales orders by giving them all roles that concern sales order processing. Althought roles include all permission for table 246 Requisition line, I receive message "You do not have permission to read table Requisition line". After giving roles and permission, I…
Duration changing enhanced to standard security
Hello, Can anybody tell me how long it approximatly should take to change security from enhanced to standard on a small (500 MB) sql 2005 database?
NAS throws error: 515,"23000",[Microsoft][ODBC SQL
Hello, I have installed Navision 4.0SP3. The client works without problems. Now I installed the corresponding Navision Application Server. Then I created a NAS service (middle tier). The account used to authenticate the service has all rights in SQLServer (sysadmin) and in Navision. It has the super role in general and for…
Navision vs Sql Server table data
hi, i created sql query: select * from dbo."IT 05_nov 2007$Vendor Ledger Entry" where "Vendor No_" = 'DELL' and "Document Type"=2 and "document No_" = 'OA01942' Output: timestamp Entry No_ Vendor No_ Posting Date Document Type Document No_ Description Currency Code Purchase (LCY) Inv_ Discount (LCY) Buy-from Vendor No_…
SQL Reporting services 2005
I have a question, If I have e table where in the filter i can select all or just a single item. How should I do that (NOT using the Multi Value) option in the parameters?

SQL General

Discussion List

Categories