-
collation problem
Hello I have a problem with setting up collations for an SQL server. I am entering german names and polish names in my server, so I need a collation that does multiple European languages, but I only have either german or polish collation. So when I use the german collation, I cant enter the polish names, and vice versa.…
-
SOLUTION: SQL Server deadlocks not automatically resolved
Dear all, this is an explanation and solution to the problem of unresolved deadlocks with SQL server. If you would like to see a previous discussion about this problem follow this link: http://www.mibuso.com/forum/viewtopic.php?t=8775 Problem Clients: NAV 4.0 SP3 on XP/32 Server: SQL 2005 Enterprise /64 on W2003/64. Other…
-
Missing data in independant tables after restore
Hello, Why would all my company independant tables be missing data (zero rows) after a restore to a new/clean SQL Navision database from a Navision Native database backup? All the structures were created and the application runs, independant tables are all creates, they are just empty. Would that happen if I chose CUSTOM…
-
Navision backup restore into SQL
Hi, I need to restore a C/Side backup for a rather large db (210+GB in C/Side) into SQL (client switching to SQL) As you may imagine it takes a while and takes a lot of space for the log. I was thinking of creating the db, then change the log model to simple, restore the backup and then turn the log model back to full. The…
-
Problem using linked servers and views
Hi, I have made a view "my_view" from a SQL Server 2000 to a SQL Server 2005 (both Windows 2003 Server) using linked servers. A Navision 3.7 client is running on the 2000 server and I use the LinkedObject property on a new table called "my_view" of course to access the view (The LinkedInTransaction is of course disabled as…
-
Table filter strange problem
Hi, Maybe someone had similar problem. I have two identical tables: - on local sql server (Table Filter works fine) - on remote sql server (Table Filter doesn't work - omit some records) I use the following combinations of filter: Field1 (Boolean): Yes Field2 (Boolean): No I have the same properties of sql server, database…
-
Windows Authentication not working on SQL 2005
Hi All- I am in the process of converting from the proprietary db to SQL Server 2005. We are running NAV 4.0 SP1. I added the xp_ndo_enumusersids and xp_ndo_enumusergroups extended stored procedures. With EXEC permissions to public & guest. I create a new database using the SA account. I go to security and add a windows…
-
SQL Server Error
Dear all experts, I faced this issue when restoring a backup for a client on Windows 2003 Server + SQL Server 2005 installed. The error comes abt when I try to restore a single company back up to the database. Here is the error msg I received: THe followng SQL Server error occured while accessing the User Group table:…
-
Connect Navision SQL Server's database & Visual Basic
Hi all, Is it possible to connect Navision SQL Server's database & Visual Basic? How? If you have any Hints then also let me know. Thanks, Sandip
-
problem when I want make new database fromDynamics SQLOption
Dear All, I'm facing a problem when I want make new database from Microsoft Dynamics NAV 5.0 SQL Option.the error appears when I choose Arabic collation. ](*,) and Select Binary The error message say >> "The file DMEMSTREAM contains a record that cannot be read completely." Please Advice Best Regards
-
Windows Logins - Only Super Works [solved]
Hello, using Nav4 SP2. I wantt to use windows logins. I have a AD group with my users in this group. I have the group and the users in Nav in the windows login table. Both users and group SQL role is public. If I assign "Super" to a users or to the group, everything works fine. IF I assign other roles (and not super) it…
-
Backup problem
Dear all I am using Nav4.0 sp1 with Sql server 2005 .I am having Win 2003 Server as OS. I need to take a backup of this database from SQL server and restore it on a different machine with win XP and Sql server 2005. When i try to restore it ,system is giving a error " Too many backup devices specified"" I then copied the…
-
Navision SQL error
Hi Experts! facing the following error The following SQL Server error(s) occurred while accessing the Object table: 50000,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] TECCOM\ANI5412 Checked this out. SQL: UPDATE "MD"."dbo"."Object" WITH (REPEATABLEREAD) SET "Modified"=1,"BLOB Reference"=NULL,"Date"={Ts…
-
Dynamics Nav 5.0 converting problem
Hi, I´m trying to convert a Dynamics Nav 4.0 sp3 SQL to 5.0 but keep geeting this error. You do not have permission to modify "TempBlob" I have checked the permission on SQL level, database role: -sysdmin -Securityadmin -public database role membership: -dbowner -public -db_securityadmin Any Ideas? #-o Thanks in advance…
-
Urgent! Need your support!
Hi all! I need your help to fix a pretty old problem - hope you remember: With NAV 4.00 - the very first version - there was a bug: no "Clustered Indexes" were created. MS released a hotfix, a TSQL script, to generate these CI afterwards. I'm currently sitting on customer's site where I found this problem still existing!!!…
-
Views, different SQL Servers
We had two databases on one SQL Server: DB1 and DB2 both on SQL Server A. Users of DB2 needs to item availability of DB1. We used views from one database to the other one and that worked fine. In SQL Server Management Studio therefor a user of DB2 needed to have DB-owner rights for DB2. The user has not to be created for…
-
Cluster size for Navision - MSSQL 2005
Hi all, .. now I'm posting to correct topic :? In documents related to navision performance, for mssql 2000 the cluster size of subsystems is adviced to be 8 kb. 1. Is this cluster size changed for mssql 2005 ? 2. The cluster size of 8kb (for 2000) is for all all subsystems or only for DB (database susbs cluster size is…
-
How to use Dymanics NAV 4.00SP3 SQL Backup on anoth. Domain
Is it possible to restore a SQL 2005 Backupfile on another Domain with different win users? ](*,) What do I need to get full access (Database Login)? We need this functionality to use a production DB in test environment. Thanks a lot for your input! cu Chris
-
SQL table locking (Nav 4.0)
I know that the problem of table locking has been discussed before and it was mentioned that some performance tuning will minimize this problem. My question is: is the table locking for Navison with SQL DB an inevitable problem? Is it possible to resolve it totally? Our company (in retail) has high volume of transactions…
-
Another Table lock question
Let's make reference to SQL server, Sales Line Table & 2 companies. Both companies exist in the same database. In SQL Enterprise Manager, there are 2 Sales Lines Tables: [CompanyA$Sales Line] [CompanyB$Sales Line] If a user in Company A & another user in Company B post Sales Orders simultaneously, will the Table lock be…
-
ODBC error when creating new NAV 5.0 SQL database
Hi. I have a strange problem with Navision 5.0 SQL. When creating a new database in Navision it begins creating the database, and after about 5 secs. it stops, and pops up an error message saying:170,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'FUNCTION'.…
-
Running SQL quarry through navision
Can we run the SQL quarries through Navision. Like if I create any button After clicking button I want to run some procedure. How can we do this??
-
Can I use other SQL.
Can I use other SQL like the nicrosoft SQL Server 2005 express edition for the Navision 3.10? Would it create problems or conflicts? Thanks in advance............ :wink:
-
will navision 3.6 SQL run on vista
curious, will navision 3.6 SQL run on vista operating system?
-
Installing SQL 2005 64bit on 32bit OS for testing purpose?
Is it possible to install SQL Server 2005 64bit version on a Windows Server 2003 32bit server? Will SQL Server 64bit stop installation on a 32bit CPU? This is just for testing and is not going to be used in the production environment.
-
When we create a new table in Navision , what is SQL doing?
Hi all, Does anybody have a clue about what is sql doing when we create a new table in Navision. I want to create a new table in SQL and view it in Navision! I think there must be a way to get it! Regards, cunny
-
Missed Fields in SQL Server
Hi, I am working in Navision 4.0, SP1. If i am looking the SQL Server through Navision i can able to see all fields. But i cann't able to see some fields for the same table if i am looking in SQL directly. For Eg., Table : 18, Customer Fields: Sales (LCY), Balance (LCY) The above fields are available if i am looking…
-
Database Schema Diagram
Hi, Is Database Schema diagram avilable for Navision 4.0, SP1? I am working on reports. I am trying to create reports in a repoting tool for the SQL Server option database. So it is difficult to prepare reports without knowing the DB Schema diagram. Is it possible to get.
-
Getting Session Error
Hi, I am getting session error when i try to login using navision 3.1 to sql 2000 database and the error message is as below: The following SQL Server error(s) occurred while accessing the Session table: 8152,"22001",[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.…
-
SQL server 2008
Does anyone already know something about Navision on SQL server 2008? Not that I am planning to use it. But just curious.