mibuso.com
Home› SQL General
Options

SQL Server Error on Field Rename

sggsgg Member Posts: 109
edited 2008-01-24 in SQL General
Setting :
Attain 3.70 B Client Running on SQL

Issue :
After Renaming a field in a Table, I could NOT save the Modifications made. I get the following error:

The following SQL Server error(s) occured while accessing the Employee Table:
15333, "42000",[Microsoft][ODBC SQL Server Driver][SQL Server] error: The qualified @oldname reference database(DatabaseName) other that the current database.
Sunday, Godwin G

Comments

  • Options
    DenSterDenSter Member Posts: 8,304
    I've seen that error where the customer was on SQL and we developed on C/SIDE. For some reason there's something that doesn't go together well. I think we just created our own SQL database and redid the development.
    Daniel Rimmelzwaan
    RIS Plus, LLC
    MVP - Business Apps
  • Options
    sggsgg Member Posts: 109
    In this case, I am Developing in 1 Database (SQL database).

    But I could not save the Table after Renaming the Field.
    The system did not allow the modification made.
    Sunday, Godwin G
  • Options
    ara3nara3n Member Posts: 9,255
    Hello the problem is that when you select your database name, navision is not case sensetive, but when you try to rename a field SQL errors because it's case sensetive.

    Please close the database. login again and do a lookup on database and and select the database. This way you have selected the right name with correct case. Now you can rename fields.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    sggsgg Member Posts: 109
    Thanks ara3n
    I will try what you suggested.
    Sunday, Godwin G
  • Options
    kinekine Member Posts: 12,562
    What about recompile all objects?
    Or try to disable all keys, save, enable them... to recreate the SIFT triggers on the table...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    sggsgg Member Posts: 109
    Thanks ara3n,
    your suggestion to Login by Using the Lookup to DatabaseName rather than typing the DatabaseName WORKED.
    =D>
    Sunday, Godwin G
  • Options
    ara3nara3n Member Posts: 9,255
    you welcome. Ran into the same problem programming on site, working on sql. It's not the lookup that you have to do. Just make sure the database name is in correct case.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    krikikriki Member, Moderator Posts: 9,090
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.