SQL Server Performance

Please suggest for this query.

Discussion in 'SQL Server 2005 General DBA Questions' started by amitadmin, Jan 29, 2009.

  1. amitadmin New Member

    Hi Friends,
    I have user and that user has add some database rolemember as like (Datareader and Datawriter). When I am genreating the script of user by SQL "Generate Scripts" on that time I am not able to capture the database rolemember within user script.
    Please suggest any method to resolve this.
    amitadmin, Jan 29, 2009
    #2

  2. rohit2900 Member

    Check these links...
    http://www.sql-server-performance.com/articles/dba/object_permission_scripts_p1.aspx
    http://www.sqlservercentral.com/scripts/Administration/64959/
    Hope this help....
    rohit2900, Jan 29, 2009
    #3

Share This Page