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,088 reads
Lester Policarpio
Select, Update, Delete, Insert etc.. in many servers using 1 query
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,338 reads
2011-06-01 (first published: 2007-09-02)
10,385 reads
Automatically Restore Backup Files for SQL 2005
This script helps with restoring backup files SQL Server 2005
2008-12-31 (first published: 2008-12-11)
1,591 reads
Server Login/Role And DB User/Role Script
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,772 reads
Blogs
Azure Data Engineer Associate
By Arun Sirpal
You can read about all the new role based qualifications from Microsoft here –...
Social: Going Along to Get Along
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
Daily Coping 3 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Update table and then executeJob in loop
I need to write a query which will first update the table, then execute...
Using two different backup products for each of data and log
To shorten a long story, my organisation has decided to have a vendor...
Compare sql-2012 and sql-2016 settings
Hi everyone, W are just doing a migration from sql 2012 enterprise to sql...
Ask SSC