Error deleting company in NAV 5.0 SQL 2005

tinoruijs

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?

ara3n

Make sure you have db_Owner rights on the db.

tinoruijs

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!

ara3n

You are welcome.

DenSter

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

tinoruijs

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!

ara3n

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 them