Creating New Tables

funduguy

Hi,
how can i create a new table using sql server database.

HalMdy

As you create it using native DB ...

Go to the Object designer - tables and use the "new" butoon. Remember to create the new table in an open range (50.000 ..)

Never try to create the table directly in SQL ...

johnson_alonso

Dear Funduguy,
HalMdy is correct. You must know that navision database can be created either in the server or native database of navision. So, if you choose sql server, it means that your navision system database installed in SQL server and the clients will be installed navision system (start MBS-Navision). If you want to design or create a new table then it will be same method as you create in the database standard of navision.


Rgds,

funduguy

Hi,
i have tried all the options but its working fine with nav dbase but with sql server its giving error. 8)

DenSter

Please post the error message, so we can see what may be going wrong.

bbrown

Your SQL account must be assigned the db_owner role.

funduguy

Hi,
the error is 'Permission not allowed', contact system administrator'. the same error i got when itried to create new tables in nav dbase but when i tried the right numbering for the tables it was working fine, but with sql server even the numbering is not working.
i'm logging into sql server through nav by windows authentication not databae authentication. i'm entering with the same user as the windows user. ](*,)

bbrown

Check in Enterprise Manager to see if your Windows Account has been assigned the db_owner role.

DenSter

That will probably do the trick. Any user that needs to be able to modify objects must have db_owner on the SQL Server.

Just to make sure you cover that too, check to see if you are using the right license.

funduguy

Hi,
Thanks a lot guys for ur help, i tried db_owner and its working.
\:D/