Script to sync all users to their respective logins
When restoring a database to a different server, this script will sync the users to the system logins. (as a relative newcomer, I'm pretty proud of this)
2002-05-23
434 reads
Blogs
Daily Coping 10 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 9 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Refreshing a Power BI Dataset in Azure Data Factory
I recently needed to ensure that a Power BI imported dataset would be refreshed...
Forums
Controlling Intelligent Query Processing Features
Comments posted to this topic are about the item Controlling Intelligent Query Processing Features,...
To use the same function to pass table name as a parameter
I have this function, but I wanted to pass a table so as to...
Create SQL Login to View only one database on server
Hi All, I have one task to create a login, and user need to...
Ask SSC