Restore Server/Database users/roles
Restore server/database users and roles from another server when we are restoring databases to another server.
2012-04-12 (first published: 2007-10-23)
3,091 reads
Restore server/database users and roles from another server when we are restoring databases to another server.
2012-04-12 (first published: 2007-10-23)
3,091 reads
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,342 reads
2011-06-01 (first published: 2007-09-02)
10,408 reads
This script helps with restoring backup files SQL Server 2005
2008-12-31 (first published: 2008-12-11)
1,594 reads
This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results
2008-01-25 (first published: 2007-11-27)
3,774 reads
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Hi, We have a user that is not an administrator that says when they...
Hello, I was looking over the Edition specifications, and Standard is capped at 128...
A client of ours is upgrading their database to SQL Server 2019. The edition...