Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL   (RSS)
Tuesday, October 27, 2009 1:29 PM

CREATE DATABASE failed when installing Cronus Sample Database

Today I did run into a problem installing the “Cronus Sample Database”. In the error report view I found this error message SQL Server option Cronus Sample Database for Microsoft Dynamics NAV 2009 Fatal error during installation. CREATE DATABASE failed.
Posted by peterwib | 0 Comments
Filed under: , , ,
Thursday, October 08, 2009 10:42 AM

“User ID and password are invalid.try again?”

If you get "User ID and password are invalid.try again?" when starting RTC you need to first check that you can login to database in the classic client. Note that the database should be the same as the service tier (the service you are trying to connect
Posted by navblog | 0 Comments
Filed under: , ,
Monday, September 28, 2009 10:43 AM

Run As Administrator if you are doing an upgrade from the same machine where SQL is hosted

When doing an upgrade running Microsoft Dynamics NAV CSIDE client on the same machine as your SQL server, please run the CSIDE client with full administrator rights (Run as administrator). The reason why this is important is because, when connecting locally
Posted by navblog | 0 Comments
Filed under: , ,
Wednesday, September 23, 2009 10:03 AM

More troubleshooting multi-machine installations of NAV 2009

Today I found a really good and interesting blog about general troubleshooting of multi-machine scenarios in NAV 2009. Most of the blog is checking SPN settings, delegations settings and different problems with those. Intro The NAV 2009 documentation
Posted by navblog | 0 Comments
Filed under: , , ,
Friday, September 18, 2009 3:14 PM

How using SQLIndex property can affect which index NAV uses

The usual rule for specifying a key in NAV is, that it will chose the first key that matches all the fields specified by SETCURRENTKEY, RunformLink, etc. Example: Table 21 "Cust. Ledger Entry" has the following keys (not all of them listed): - Entry No.
Posted by navblog | 1 Comments
Filed under: ,
Thursday, August 27, 2009 1:55 PM

How to install more than one Dynamics NAV 2009 Demo Database alternative 2

Earlier I did describe how to duplicate an installed and existing database in post " How to install more than one Dynamics NAV 2009 Demo Database ". This time I will attached the DB directly from DVD. The steps is as follow Create the directory where
Posted by navblog | 0 Comments
Filed under: , , ,
Tuesday, August 25, 2009 3:09 PM

Table Information including Index information (Usage, Blocks and Reads)

== Nov 9 update == In some cases we got integer overflow when running this query. So the table definitions in the query have now changed from using int to bigint to avoid this. == end of update == The query below combines these three queries into one:
Posted by navblog | 0 Comments
Filed under: , ,
Thursday, August 06, 2009 10:41 AM

How do Record Links encode their data in SQL server?

Recently I was asked about the encoding that it is done for record links in SQL. If you are not familiar with Record Links, which have been available since NAV version 5.0, just open any Card or List and then click Edit -> Links (Ctrl + L). “ Record
Posted by navblog | 0 Comments
Filed under: ,
Thursday, July 16, 2009 2:34 PM

Index Usage Information Tool

Attached at the end of this post is a set of NAV objects that collects index usage information, and displays it in a NAV client so that you can sort tables by no. of Indexes / Index Reads / (Index) Block wait time, etc.: The tool is using these three
Posted by navblog | 0 Comments
Filed under: ,

Attachment(s): iuit.fob
Tuesday, July 07, 2009 2:28 PM

How to read a SQL Profiler trace file into a SQL table

Just a small tip that I use often when I have a large SQL Profiler trace. Rather than reading through trace files line by line, you can read it into a table and then query it. This syntax creates a new table in SQL Server and loads your trace file into
Posted by navblog | 0 Comments
Filed under: ,
Monday, June 08, 2009 5:49 PM

Trace flag in SQL Server for Dynamics NAV 2009

When starting the RTC client or open the database in classic client you will get a warning if you have not set the trace flag correct. Because of changed security in SQL Server 2005 Dynamics NAV 2009 will only connect to the SQL Server if the trace flat
Posted by navblog | 0 Comments
Filed under: , ,
Thursday, June 04, 2009 2:05 PM

SQL Query to show tables, their indexes and index usage

The SQL query below shows a list of tables sorted by the largest tables first. For each table, the indexes in the table are shown. For each index it shows when the index was last used. The query is designed to collect various pieces of information in
Posted by navblog | 0 Comments
Filed under: ,
Monday, June 01, 2009 5:58 PM

Failed to execute SQL string when Installing Dynamics NAV 2009 #2

When reinstalling Dynamics NAV 2009 or if you have attached a Demo Database manually you will probably run into this problem: -------------------------- Microsoft Dynamics NAV 2009 Build 27808 Error Report SQL Server option Cronus Sample Database for
Posted by navblog | 0 Comments
Filed under: , , ,
Monday, May 25, 2009 5:38 PM

Installing Stored Procedures for Dynamics NAV 2009 Manually

It’s recommended that you use the installer on the product DVD to install the stored procedures. But if you are running more than one name instance of SQL server on the same machine that approach will not work. Then you need to do it manually: 1. Copy
Posted by navblog | 0 Comments
Filed under: , , ,
Monday, May 18, 2009 11:20 AM

How to install more than one Dynamics NAV 2009 Demo Database

By default when you are installing the demo database by the installation program you can only install one Demo Database. But if you would like to have more than one Demo Database to try different things in, how to accomplish that? I assume that you know
Posted by navblog | 0 Comments
Filed under: , ,
More Posts Next page »
 
Page view tracker