Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Bob 38 posts 160 karma points
    Jul 31, 2017 @ 19:17
    Bob
    0

    I'm installing umbraco and when i enter the database and server name the database adds a schema name to all the table names. How could i avoid this?

  • Nicholas Westby 2054 posts 7100 karma points c-trib
    Jul 31, 2017 @ 22:06
    Nicholas Westby
    0

    Are you talking about when it says something like dbo.cmsContent? I think the dbo portion is just something SQL does (though, I've never really questioned it, so I don't know). Is there some reason you don't want that (assuming I've understood your question correctly)? You can still query tables without specifying the schema.

  • Bob 38 posts 160 karma points
    Aug 01, 2017 @ 05:41
    Bob
    0

    Yes, dbo.cmsContent becomes Iis_apppool\user.cmsContent. I don't know why it does it but like to keep it to the original naming.

  • Nicholas Westby 2054 posts 7100 karma points c-trib
    Aug 01, 2017 @ 06:12
    Nicholas Westby
    0

    That sounds odd. Not sure exactly why that would happen, but I would guess it has something to do with how you've configured the permissions for the login or the user in the SQL database.

  • Nik 1593 posts 7151 karma points MVP 6x c-trib
    Aug 01, 2017 @ 09:46
    Nik
    0

    In the past, that has very much been caused by how the user you are using to create the database is configured. I can't however, remember how to stop it I'm afraid.

Please Sign in or register to post replies

Write your reply to:

Draft