Monthly Archives: September 2010

SQL Script to add and Remove Database role members

/*========================================================== Author: Suleman Mohammed Description: Scripts out statements to add & drop Database role members for each of the Database roles, ordered by Database role name and Member name ===========================================================*/ SELECT [Database Role] = r.name , [Member] = m.name , … Continue reading

Posted in SQL Server, T-SQL Scripts | Tagged , | Leave a comment

SQL Script to add and Remove SQL server role members

/*========================================================= Author: Suleman Mohammed Description: Scripts out statements to add & drop SQL server role members for each of the SQL server roles, ordered by Server role name and Member name ==========================================================*/ SELECT [Server Role] = r.name ,[Member] = m.name … Continue reading

Posted in SQL Server, T-SQL Scripts | Tagged , | Leave a comment