Script Users and Database roles using t-sql and not with Wizard

• VRR

  Ten Centuries

  Points: 1170

  More actions

  January 12, 2010 at 2:48 pm

  #140706

  Hi All,

  How to generate Script for Users and Database roles using t-sql and not with Wizard in SQL Server 2005.

  I want to automate scripting Users and Roles to a file and schedule it in a job to run monthly once in our servers.

  Appreciate your help on this.Thanks!

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  January 12, 2010 at 4:56 pm

  #1102831

  Try this one

  http://vyaskn.tripod.com/scripting_permissions_in_sql_server_2005.htm

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events