-
Date / Time Stamp displayed differently in SQL vs. NAV
Hi: I have a "staging" table where I have an outside process write records into this table. The table is then processed by a NAV report to import some data. I am in SQL Management Studio and I run the following command: UPDATE [StagingTable] SET [ImportDateTime] = '09/23/2009' Then, if I display the records in SQL Mgt…
-
SQL query field names in SQL Mgt Studio are case-sensitive
Hi: In my Nav SQL databases running under SQL 2005 (3.60 database running under NAV 5.1 client), my queries require field names and table names to be case-correct, e.g. the following query will NOT work: select * from [CRONUS USA, Inc_$G_L entry] I receive an error: "Invalid object name 'CRONUS USA, Inc_$G_L entry'."…
-
How to solve SQL collation problem?
Hi, I've developed a german solution in SQL database with SQL collation 52 (Western-European dictionary sort order, code page 1252, case-insensitive, accent-sensitive (52)) Now we have a international customer that needs SQL databaes with collation 82 (Latin-1 dictionary sort order, code page 1250, case-insensitive,…
-
Dynamics NAV 2009 sp1 and Sql Server 2000
Can Dynamics NAV 2009 sp1 run with Sql Server 2000?
-
SQL Querie - Incorrect syntax error
I tried to create a querie to list the customer no, customer name and the location name. The WHERE condition is giving me an error (Incorrect syntax near the keyword 'INNER'.) and I am not sure how to fix it? SELECT [No_] ,[Visions$Customer].[Name] ,[Visions$Location].[Name] AS [Location Name] FROM [Visions$Customer] WHERE…
-
Preferred code base with SQL 2005
Offcourse with a new customer we will use the latest version but I would like some insights of which combination is running fast with your customers. And may I ask how many orderlines are processed each day? and how many days of tuning did you need to do? 1. NAV 4.0 SP3 (code and exe) 2. NAV 5.0 SP1 (code and exe) 3. NAV…
-
Optimization Problem
Dear Concern I m using Navision SQL database.My DB size is more than 80GB.I want to optimized the DB.If I'll optimize DB, then what will happen to my DB?I'll face any problem after Optimizing DB?
-
Read NODBC (NativeDB) from SQL 2005 SP?
hi I am trying to create a stored procedure using .NET in SQL 2005 (SQLCLR) to refer the customer table in Nav 4 SP3 native DB in another server. Is there any samples of the connection strings any one has? I tried using ODBC (and DSN) and it doesn't work. TIA
-
Database size (KB) and Unused Space
hi everyone, i am almost monopolying this section's new threads, but i hope my questions can be useful for anyone else. :wink: Back to topic, i am trying to reduce the space of a 40SP1 database ,and i was wondering why navision holds strange values in File->database->information->tables->Size(KB) Example: i have Item…
-
Installing DB
Hi Everbody, Is it possible in some way or another to install a db when having the .mdf file only?
-
Creating a function to copy data between 2 tables
I am new to development in Nav and need some help with developing the following function: A new table was created which contains a few similar fields as an 'obsolete' table. I need to copy the data from the old table to the new table for all matching records for certain common fields. After it copied the data from the…
-
SQL Server Developer install ?
I have SQL Server 2008 installed, but I was wanting to use SQL Server 2005 Developer edition and I was wondering if they can coexist on the same machine. The reason I as this is that I originally had SQL 2005 Express that was installed when I installed Visual Studio 2005, but when I installed SQL 2008 Express, SQL 2005…
-
Best Practice for Transaction logs?
hi Everyone: Greetings! I am new to Navision and as well as SQL server 2005, I need your help in regards to Best Practice to setup the transaction logs, should it be auto-grow or fixed space for it usage? What are the best practive to maintain the transaction logs? delete it? detach it? shrink it? truncate? backup? which…
-
Designing a basic SQL query - Using join
Hi there, Can anybody please help me compiling a basic query? The query should filter for customers belonging to a certain posting group (Customer table) and then display the customer number along with the current customer balances. I am not sure how to compile it since I need the data from 2 or maybe 3 tables: Customer…
-
Type Variant!!!
Hello, Variant type for field table doesn't exist in navision? I have a stored procedure that contains some fields and a sum of amounts and I call it from navision and the result is an error message even if I store the sum in field of mytable datatype decimal. How can I resolve that problem???? I'll be greatful for your…
-
Compatibility of Navision 4.03 with 64 bits windows server
Hi, can you please confirm if Microsoft Business Solution navision 4.03 is compatible with windows 2003/2008 server of 64 bits Thanks
-
Error in counting number of records!!!
Hello, I have a : select columnA, count(*) number from matable group by ColumnA The result is an error message "Arithmetic overflow error converting expression to data type int." how can I resolve that problem :( Thanks for your help
-
A Story of the Deleted Transaction Log
Follow the Link: http://www.sqlservercentral.com/article ... ery/63311/ <- to read the whole article, you must be a member of this site. But this is a good site for SQL Admins or developers who use the SQL-Server. I'm sure that some members of mibuso also be a member of sqlservercentral Regards
-
A question about views
I created a VIEW name newAuthors and I can access it like so: SELECT * FROM books.dbo.newAuthors au where Row>=5 AND Row<=15 order by au.au_lname desc; My question is I can access a normal table without using books.dbo.authors as in select * from authors; but if I try doing the same thing with a view I get errors unless I…
-
Code with SQL
hai friends... i am new to sql, i have a general doubt... is it possible to code with in sql tables(with sql), instead of using CAL in NAV :-k . :?: if its possible... which one is recommended more??? 8-[ thank you!
-
SQL Server Collation
Hi, I am Single Sql Server 2005 Instance having multiple databases. All the databases using default collation Latin1_General_CI_AI. Now i need to create One more database that uses Japanese Language. Is it possible On Single Instance we can use different Collations for different databases? Is there will be any issues?…
-
Active Directory Users Syncronize to SQL Server 2005
Hi, Is there any option when i create User ID's in Active directory automatically create in SQL Server. Please let me know. Regards, Anil
-
Database with Japanese Language
Hi All, I need to setup a SQL Database with Japanese Collation(Japanese Language option). I need to Clarify some of the points. 1.) I am creating database from NAV. Which collation i need to select? 2.) Also i need to Change Collation at Sql Server level also? What Collation Should i select? Because i heard if i change…
-
Time-out occurred while waiting for buffer latch type 2 for
When importing an fob into sql 2k5 sp3 with 5.0 sp1 exe I get the following error. The table has 1.2 million records. And based on sql statement it errors while creating the VIEW for SIFT Has anybody seen this and a solution? The workaround I've found is export the data through dataport. Delete the records. Import the fob…
-
Any experience changing the Collation for single fields?
I'm unable to find a collation in SQL2005 that fits my needs, so I plan to change the collation of a few fields directly in SSMS. Tests seems to be ok, but has anyone tried this on a live system and had any good or bad experience with it? (Btw SQL2008 introduces a new Norwegian collation, which seems perfect for my Danish…
-
Navision Restore Question
Hi, We are using Nav 3.7a with SQL 2000. I'm trying to restore a 32gb database onto a 48gb drive. On our runtime database we use "Simple" transaction logging so there is no problem with the log file. Unfortuantely, the restore creates a log file that is about 30% larger than the actual database file and the two won't fit…
-
SQL Backup size
I take the SQL database backup (full) it is near about 9 GB. If I take native backup it is near about 1.5 GB. I am using SQL 2005.Navision 5.0 SP1 .The database size in SQL is 13GB. I had already truncate the log file. How I can reduce the SQL backup size. :-k
-
Corrupt SIFT Tables
Using Navision 3.7, SQL 2000. It appears some of our SIFT tables are corrupt. Specifically for Item Ledger Entries. The Quantity on Hand from the SIFT tables does not match the sum of the Quantity field in Item Ledger Entry. Dropping and Creating the indexes has not fixed the issue. Any thoughts on why this happens and how…
-
Special Characters being returned from Data Formula fields
Hello - I am having an issue with the data being returned from "Date Formula" fields such as the Item table's "Lead Time" or "Reorder Cycle" fields. If I have "16W" in the field, SQL returns "16" with a little box as shown in the image below. I get the same sort of results in the "Payment Terms" table as well so I'm…
-
SQL server backup vs. Navision backup
Hi Is there a reason to use navision backup when using sql server option? Of course a navision backup offers the possibility to restore companywise or only objects, etc. But is it also needed to detect data corruption or anything else (as I've heard)? I guess no, but your opinion is appreciated. Thanks Thomas