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 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Things to look out for while TDE is encrypting existing data

By

Monitoring for Problems The encryption of your existing data occurs as a background process...

Daily Coping 26 Jan 2023

By

Today’s coping tip is to focus on what’s good, even if today feels tough....

Read the latest Blogs

Forums

Context_Info across databases

By micaden

I have a stored procedure that works across databases.  So the "integration" database will...

Interview Question

By arvind.patil 98284

Hi Team , Today i had an interview call. there was a question asked...

AG failover databases go into Initializing / in recovery

By Summer90

We did a failover of an AG and two databases went into Initializing /...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers