Hello group,
We have recently come up with a problem where SQLServer 2005 differs
from 2000.
We have an application role, which needs to run DDL to alter tables
etc. The documentation for 2005 states quite clearly that application
roles cannot be made members of built in roles like db_owner or
db_ddladmin - which proves to be the case, but this was possible in
2000.
How are we to give application roles these rights in 2005 (and, for
all I know 2008)?
Thanks,
Jim