Home Forums SQL Server 2005 SQL Server 2005 Security Create table permission denied RE: Create table permission denied

  • November 26, 2009 at 2:15 pm

    #1084716

    cute_lhen05 (11/26/2009)

    Thanks for your help! it worked! however there's a message showing everytime the user creates a table like

    "you are not logged on as the databae owner or system administrator. You might not able to save the changes to tables that you dont own"

    Simple fix for that. Don't use the GUI table designer.

    Isn't there an option to see the warnings generated?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass