Re: Script Database Roles, Application Roles, Server Roles

On Dec 14, 10:08 pm, Tim Patterson <Tim
Patter...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I would like a tsql script to script out the already created database roles,
application roles, and server roles for a SQL Server 2005 database.

Please help me create tsql script to complete task using the adventureworks
database.

Thanks,  

right click on the DB and there should be a Generate Script option
somewhere there, not sure if it will do everything you want. you might
have to break this up into a few steps and transfer things like logins
via SSIS
.

Relevant Pages

  • Script Database Roles, Application Roles, Server Roles
    ... I would like a tsql script to script out the already created database roles, ... and server roles for a SQL Server 2005 database. ...
    (microsoft.public.sqlserver.security)
  • Re: permission problem
    ... These are server roles. ... You have to create on the specific database you are talking about. ... "Caminar sobre el agua y desarrollar software a partir de unas ...
    (microsoft.public.sqlserver.programming)
  • RE: Security Problem with AD Group in SQL Server Security Logins area
    ... Second problem - if I uncheck that Server Role and leave all the Server Roles ... I can use the Database Access tab to configure who has access to the ... I see dbo ...
    (microsoft.public.sqlserver.security)
  • Re: What commands can a user execute
    ... mapped to any server roles but is a db_owner in almost all databases. ... just learned from a security monitoring script which logs security ... events that a member from this NT Group created and dropped a database. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)
  • Re: SBS2003 and SQL
    ... All have server roles as ... >Do you have your domain account listed? ... >on it to open the properties page and go to the Database ... >> either group or user with admin access. ...
    (microsoft.public.windows.server.sbs)
Loading