db_ddladmin rights/Supressing Validation Warning Pop-up Box?

  • 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

  • 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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply