SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Move DB roles

By Shanjan Sapra,

This is useful for scripting permissions in a development environment before refreshing development with a copy of production.This will allow us to easily ensure development permissions are not lost during a prod to dev restoration.

Total article views: 1214 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Developers, developers, developers

A survey of developers on Stack Overflow has some interesting results that Steve Jones notes. Some o...

FORUM

sqlserver developer

sql server developer certification

ARTICLE

Developers vs. DBAs

Why don't developers and DBAs get along?

FORUM

SQL 2005 Developer version software

Developer License

ARTICLE

Rulebreaking Developers

How much of a problem is it when developers can blamed for issues?

Tags
restore    
roles    
security    
 
Contribute