Technical Article

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

819 reads

Blogs

Daily Coping 28 Jun 2022

By

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

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

Read the latest Blogs

Forums

SSIS - Oracle to SQL 2019 Standard error "Unexpected Termination"

By BTC100k

I have a simple SSIS package where the source is oracle 12c Enterprise, with...

Default trace file error

By ramana3327

Hi, When I tried to open the default trace it is giving me the...

Azure Pricing, SQL Server seems pretty high?

By keven11

Hi, I'm really new to this and I think I've got this wrong, wondering...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers