SQLServerCentral.com Content tagged Security, users

List orphaned users from all databases

Tue, 29 Dec 2009 07:00:00 UT

The script returns all orphaned database users across a SQL Server.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Resolving User Security Identifier (SID) Discrepancy in Read-Only Databases

Mon, 28 Dec 2009 07:00:00 UT

Many experienced DBAs understand the issues with matching up users and logins in a restored database. But what do you do when the database is read only? New author Tychang Chen brings us a technique that can help.

Please, Sir, I want some more… orphaned database users.

Fri, 04 Dec 2009 07:00:00 UT

Permissions on our development servers are considerably less stringent than elsewhere with developers afforded the freedom to restore backup’s ad-hoc....