db_ddladmin rights/Supressing Validation Warning Pop-up Box?

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  April 26, 2004 at 7:41 am

  #101982

  Hello,

  MSSQL 7 w/SP2 and MSSQL2000 w/SP3

  In our test environment, the dba owns the database ie; the dba server login is mapped to the database user 'dbo'. Developers are added to the following database roles: db_datareader; db_datawriter and db_ddladmin. All objects (ie: tables) in the database belong to the dbo schema. When developers make changes to objects in Enterprise Manager (ie: drop table; alter table; change column position; chage datatype; etc) they receive the following warning message box ...

   Validation Warning: warnings were encountered during the pre-save validation process, and may result in a failure during save. Do you want to continue attempting to save?

  'emp (dbo)' table

  - Not the table owner

  OPTIONS: "Yes", "No", "Save Text File?", "Help"

  Having the db_ddladmin rights allow them to make the changes when they select "Yes" from the above validation warning box.

  Is there a way to supress this warning box from popping up each time a developer makes a change? They're finding it annoying ...

  Many thanks. Jeff

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738928

  More actions

  April 29, 2004 at 11:39 am

  #504721

  I don't think there is any way to change this. You could have them script changes and then run them through someone who does own the table.