Get all user information at the database level

By Wesley Brown, 2004/09/02

Total article views: 553 | Views in the last 30 days: 18

Rate this |

Join the discussion |

Briefcase

This is based on Clint Herring's work and was better than what I was using ;). It has one user definded variable @path that is where to store the files generated. It will make one file per database and one master file to restore all user permissions into that database. Used mostly for DR and moves into QA.

By Wesley Brown, 2004/09/02

Total article views: 553 | Views in the last 30 days: 18

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

Database Growth Monitor

By Brian Knight | Category: Miscellaneous

| 2,886 reads

The Log Watcher

By pochinej | Category: Miscellaneous

| 2,083 reads

Script to Show All Failed Jobs in Specified Period

By Janine Bocciardi | Category: Miscellaneous

| 1,101 reads

Reset Identity Columns for Tables Using Them

By Chris Kempster | Category: Miscellaneous

| 460 reads

Like this? Try these...

Grant Read-only permission to user on jobs

By SanjayAttray | Category: Maintenance and Management

| 113 reads

Import network computer EventLogs to SQL table

By mdenner

| 418 reads

Grant EXECUTE permission to users

By Parag Sohoni | Category: Maintenance and Management

| 67 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com