mibuso.com
Home› SQL General
Options

Error deleting company in NAV 5.0 SQL 2005

tinoruijstinoruijs Member Posts: 1,226
edited 2008-03-27 in SQL General
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?
Tino Ruijs
Microsoft Dynamics NAV specialist

Answers

  • Options
    ara3nara3n Member Posts: 9,255
    Make sure you have db_Owner rights on the db.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    tinoruijstinoruijs Member Posts: 1,226
    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 specialist
  • Options
    ara3nara3n Member Posts: 9,255
    You are welcome.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    DenSterDenSter Member Posts: 8,304
    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
    Daniel Rimmelzwaan
    RIS Plus, LLC
    MVP - Business Apps
  • Options
    tinoruijstinoruijs Member Posts: 1,226
    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! :lol:
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Options
    ara3nara3n Member Posts: 9,255
    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! :lol:

    well with 5.0 sp1, they are getting rid of sift tables, so if you do exe upgrade, you can forget about them
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.