-
DBO rights for NAV
Hi, If a user go's to the Sales Module, Sales Order he receives a message that his user account and /or passord is not okay. If we give him just DBO rights on the Database it works. We have a view which will be checked(data) when opening that Form. Why does the user needs DBO rights or how can we modify this so the users…
-
4.0 and 2009 databases coexisting on the same server
Hi everyone, we have our 64bit SQL 2005 servers running our 4.0 Prod and Dev environments. As anyone run into any issues installing the 2009 database and components on the same servers running a 4.0 db?
-
Manage NAV Sessions - Auto Log Off
My customer had requested a customization which will auto log off a Navision Idle session if number of user sessions is exceeded from the license allowed. How can i achieve this goal on Dynamics NAV 5.0 SP1? Thanks for your answers.
-
Delte data directly by sql server.
I want to delte the customer data in the customer table in sql. If i delte this directly by sql can accurred any problem in Ms Nav. Thanks ina advance
-
Runtime license
Hello SQL server runtime license is on the NAV price sheet. If a customer will license sql server through NAV (I know the rules for using this), what kind of installation media and product key for sql server will be used in this case? Thanks in advance Thomas
-
Extended Stored Procedure error(urgent)
Hi, I created an extended stored procedure namely xp_ndo_enumusergroups as described in the IC pdf. My SQL server was running smoothly and i was able to login with windows authentication successfully until one day i started getting error about the same extended stored procedure when i tried to login with windows…
-
Connection Issue...
I work in a Fitness Center with a piece of equipment called the Power Plate. The machine itself is great, but the usage tracking software it came with is horrible. It saves all user information on an SQL server. I have virtually NO knowledge of SQL servers, databases, etc. I would like to use excel to run queries on…
-
exporting out all my sql tables at once to excel
I have SQL server 2005 express installed and SQL Server Management Studio express installed. I have a client's database loaded up into SQL. They have a bunch of tables and I can go into each one and export out to excel, but this will take forever. Is there a way I can hilight ALL the tables in SQL and export them all at…
-
New db permission errors
I am using SQL 2005 and NAV 4.0 SP3. I am not a dba so bear with me. I created a new db. I imported the data I needed through SSIS. I don't need all of it and SSIS seemed simpler than dataports. When I go to login to the new db I get an error about the object table and permissions. I don't remember the exact error but I…
-
Pivot table query !!!
Hello, I'm using a pivot table query and in the result I have NULL amount, how can I do to get 0 and to replace the NULL values with 0 :( Help :oops: SET @query = ' Select Customer ,"Agence" ,"Id Commercial" ,"Commercial " ,"Adress" ,"Postal Code " ,"Country" , ' + @cols+ ' From #detail PIVOT (sum(Amount) FOR Period IN ('…
-
SQL Server 2008 - Set Trace Flag in Clustered Environment
Hi, can anyone tell me how to set the trace flag 4616, for Dynamcs NAV 5.0, in a SQL Server 2008, clustered environment? Best Regards.
-
Item ledger entry table fields not in SQL database
Dear All, I am facing one problem in standard navision table 32 (ItemLedger entry table) has some fields which does not exist in SQL database however I can see them in Navision tables. I am using SQL 2005 and Navision 5.0 Enabled Field No. Field Name Data Type Yes 5803 Cost Amount (Expected) Decimal Yes 5804 Cost Amount…
-
SQL query plan
Hi everyone, can someone tell me how to decypher this query plan, or better where can i find a guide which explains all the operators? (i found on msdn something which explains the words, but what about the numbers like [2,1],[3,2] etc? thanks in advanceSort[2,1];Filter[3,2];Nested Loops[4,3];Index Seek($3)[5,4];Clustered…
-
TCP/IP error ECONNREFUSED
Hi, I am new to NAV and i am getting the error message "The TCP/IP connection's 'host' is not answering (TCP/IP error ECONNREFUSED).You can see how to make changes to your 'hosts' and 'services' files in the documentation for the network. Contact your system manager if you need assistance." on trying to connect NAV 6…
-
Open Excel File with SQL Server 2005!!!
Hello, I have an excel file and I just need to open it using SQL Server 2005 and to save it. Who can tell how to do that :( Thanks a lot.
-
Is NAV using Dynamic and/or FastForward cursors?
Once again Microsoft has released a KB article which confuses me. Can anyone please enlighten me regarding this hotfix: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;974798 All my NAV5SP1 customers are currently using build 27191 which uses Dynamic Cursors. We tried one of the first newer builds that…
-
Navision 4.0 & SQL Server 2005 or 2008
Does Navision 4.0 work with SQL Server 2005 or 2008?
-
SQL 2005 restore error 4902
Can anyone help explain this message which occurs at the end of a restore of a company with VERY little data? The message follows table and key creation. Going into SQL Mgmt studio shows the table DOES exist both as table 7 and as 100000007 so it must be permissions. I am logged in as sa (dbo). The following SQL Server…
-
Buckets Effectiveness
Hi everyone, i am taking a look at SIFT buckets optimization, and i would like to unmanage some of them in order to reduce db size and increase write performance (oh, well...i think anyone knows why i want to do it :) ) I recently have read an official MS manual about optimization, and it is written that you can proceed…
-
How to Execute SQL instructions from Navision
Hello, I have some instructions SQL Server on my Unit Code, but I don't know how to use these statement, any one can help me please :( IF ISCLEAR(lADOConnection) THEN…
-
32 bit sql 2005 on 32 bit OS or 64 bit OS
Hello Client is buying a new hardware and I wanted to know which would perform better. The sql server is 32 bit, so they won't change that. The question is will 32 bit sql 2005 perform better on 32 bit OS or on 64 bit OS? Also the max memory is 4 gig. With 64 bit you can have more memory for OS and 4 gig for sql. Also I'm…
-
SQL Server Connection Error? Sessions not responding.
At certain times of the day, I am getting the following error message from ALL my Dynamics NAV clients (at the same time): Your connection to the full.dns.name server is no longer responding. This is probably because one of the following reasons:* The server has been shut down, either manually or as a result of an error.*…
-
Setup Linked Server
Hi, I creatd a System DNS with C/ODBC in order to connect ro our NAV 3.70 native DB. MS Query and Excel shows, that the Setup is ok. Now I would like to add this DNS to a SQL 2005 Server as a linked Server, but I could not get it right. ](*,) Any Suggestions which Information to put in the Setup? cheers, Chris
-
Error - change SQL type from undefined til VARIANT
I have a problem changing the type in tabel 110,112 and 114. After a while I get an error message: 3728,”42000”,Microsoft ODBC SQL Server Driver`”Tabelname”$0 is not a constraint (se the attached file) (the first sentence in norwegian only says : The following error occured when accessing table.... I have deleted all the…
-
Cannot select tables with . in the name
I haven't had this issue until this client, and I searched and found nothing. Probably a rookie SQL mistake. I get a syntax error when trying to select records that have a period in the name, even when I drag and drop from the SMSE explorer. It says there is a syntax error around *last word in table name*. So if I try to…
-
General sql query question (compare date ranges)
I'm trying to create a report true SQL BI that compares the sales of a product/customer between two given date frames. For example, I want to see the difference in sale from item "111" from (01/01/2008 till 31/12/2008) and (01/01/2009 until 31/01/09.) All data is in the same table, so no external joins are needed. Data…
-
New Database - Default File Path
I have a server that has a lil mirror'd pair for the OS and programs (C:), then a separate set of disks for data (E:). On the SQL 2008 side, I have the server's Database Properties "Default Locations" for the Data and the Logs as simply "E:\SQL\". Any new database I create with SQL pays attention to those defaults. But not…
-
Login error when working with sql in windows authenctication
hi friends, I have connected the system and navision with sql on the same system and it has network functionality . It is able to connect to other system in the network using the the sql authentication user. But with the windows authenctication from the client side i get this error. 229,42000{microsoft]{odbc sql server…
-
Export Dynamic Table to Excel
Hello, I have created a dynamic table with pivot... in my stored procedure I have to export the data result to MS Excel, I found a code to do that but it didn't work (it works only for static table :( ) Anyone knows how to do that? Thanks.
-
Permission Error while modifying Table 112
Hi All, I logged into the DB in SQL. with windows login. when I tried to change the length of Address filed in table 112 an error was coming. ERROR:: Microsoft Dynamics NAV ClassicThe following SQL Server error or errors occurred when accessing the Sales Invoice Header table: 1088,"42000",[Microsoft][ODBC SQL Server…