Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dg2011
Starting Member
7 Posts |
 Posted - 2011-04-04 : 16:40:50
|
| I have SSMS 2008 (version - 10.0.2531.0)Back end Microsoft SQL Server 2008 (SP1) - 10.0.2723.0 (X64)I have DB_ddlAdmin role on a databaseI can create/alter a table via sql script.In the SSMS Database Designer (GUI), When I right click on the database >> Tables and select New Table I get the following error."You are not logged in as Database Owner or System Administrator. You might be able to save chnages..."Then i get a screen where SSMS asks me to enter column names. When I enter column names and I can click on Save I get "Not a Table Owner" error. The table does get created but after that i can not alter it via Database designer (I can alter it via a alter SQL).So Long story short, I can create tabels via DDL sql but not via the SSMS database designer. This from a technical view point might not be a big deal but for a business person not knowing SQL syntax will be a critical issue.Can someone please shed light on this issue. Thank you very much for your time. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dg2011
Starting Member
7 Posts |
Posted - 2011-04-04 : 22:04:29
|
| Tara, Thanks for your input. I am working with my company's MS contact to see if I can report a issue/bug. Not sure how long this will take. I was hoping to find a resolution sooner. Thanks. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dg2011
Starting Member
7 Posts |
Posted - 2011-04-05 : 14:27:45
|
| Tara, Microsoft has been aware of this issue for awhile...This post is dated 06/2009. I can't see MS sitting on this bug all this time and not fix it.http://connect.microsoft.com/SQLServer/feedback/details/467582/db-ddladmin-role-doesnt-allow-use-of-design-functions-in-ssms] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Cannot create table using SSMS_Database Designer