Hi, I would like to know what to insert in “Defaut Schema” option when creating a new user in SQL 2005 Server. It’s “dbo” by defaut, but I have read that it’s better to leave it blank for Navision. Is this option a real impact in NAV? What is the best thing to insert? Many thanks,
From my experience, if I leave it blank, then it says ‘dbo’ next time anyway. I would guess (stress guess) that unless your tables were owned by somebody other than DBO, leave it blank and let SQL do the work for you.
Thanks for your answer, I will let it blank (i.e with dbo