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 |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2011-04-25 : 10:38:14
|
| In SQL 2005 a user with ddl_admin previalges was able to add column to a table through GUI interface though it gives a warning message but in SQL 2008 its not the same, is there any work around so that users can modify table using GUI. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-04-25 : 13:51:01
|
| In Management Studio, go to Tools:Options:Designers:Table and Database Designers. There's a checkbox to "Prevent saving changes that require table re-creation". I recommend leaving that checked, as that kind of table change should have a safety in place. |
 |
|
|
|
|
|
ddl_admin changes in 2008