No more orphan users!

I was fed up of manipulating sysusers after restoring a db from one server to another.Just put thgis script on QA after restoring db. It will check all db users (not tested for secure connections) and will restore orphan users. Check it out!Hope this script will help.

4 (1)

2003-02-03

817 reads

Blogs

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Daily Coping 23 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Read the latest Blogs

Forums

REST API through SSIS

By rocky_498

I want to call (REST) API the "GET" command and assign the return value...

How to reduce physical size of database

By coolchaitu

I deleted few tables having millions of records, but when see the physical space,...

How to get these description from XML into the table?

By NewDBA201

  I want all these description in different row. TIA Example descriptions 0|Home 1|Office|False...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers