Error deleting company in NAV 5.0 SQL 2005

tinoruijs
Member Posts: 1,226
I'm getting an error when I'm trying to delete a company (CRONUS Nederland BV) in NAV 5.0 on a SQL 2005 server.
Microsoft Dynamics NAV
The following SQL Server error(s) occurred while accessing the Payment Terms table:
3701,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'CRONUS Nederland BV$Payment Terms', because it does not exist or you do not have permission.
SQL:
DROP TABLE "Tausch Expo"."dbo"."CRONUS Nederland BV$Payment Terms"
I've checked in SQL Server Management Studio and there is indeed no table with that name. The table for CRONUS Nederland BV are named for example CRONUS Nederland BV$5065$0.
I have 4 other companies in the same database and they do have the correct names.
How to proceed?
Microsoft Dynamics NAV
The following SQL Server error(s) occurred while accessing the Payment Terms table:
3701,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'CRONUS Nederland BV$Payment Terms', because it does not exist or you do not have permission.
SQL:
DROP TABLE "Tausch Expo"."dbo"."CRONUS Nederland BV$Payment Terms"
I've checked in SQL Server Management Studio and there is indeed no table with that name. The table for CRONUS Nederland BV are named for example CRONUS Nederland BV$5065$0.
I have 4 other companies in the same database and they do have the correct names.
How to proceed?
Tino Ruijs
Microsoft Dynamics NAV specialist
0
Answers
-
Make sure you have db_Owner rights on the db.0
-
ara3n wrote:Make sure you have db_Owner rights on the db.
It worked!
:oops:
This afternoon I tried with my database-login to delete the database.
Now I tried it with my windows login.
They differ in rights. My windows login has got db_Owner rights.
Thanks Rashed!
Tino Ruijs
Microsoft Dynamics NAV specialist0 -
You are welcome.0
-
In case you don't know: CRONUS Nederland BV$5065$0 is not a core NAV table, it is a SIFT table, it's where SIFT buckets are stored for SIFT key number 0 of table number 50560
-
DenSter wrote:In case you don't know: CRONUS Nederland BV$5065$0 is not a core NAV table, it is a SIFT table, it's where SIFT buckets are stored for SIFT key number 0 of table number 5056
Hi Daniel,
Didn't know that. Thanks.
Until now I only worked with native databases. In the past I've read the sql-posts here on Mibuso not so often. Guess that's gonna change now!
Tino Ruijs
Microsoft Dynamics NAV specialist0 -
tinoruijs wrote:DenSter wrote:In case you don't know: CRONUS Nederland BV$5065$0 is not a core NAV table, it is a SIFT table, it's where SIFT buckets are stored for SIFT key number 0 of table number 5056
Hi Daniel,
Didn't know that. Thanks.
Until now I only worked with native databases. In the past I've read the sql-posts here on Mibuso not so often. Guess that's gonna change now!
well with 5.0 sp1, they are getting rid of sift tables, so if you do exe upgrade, you can forget about them0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions