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
430 reads
Blogs
Simple-Talk Article…Understanding Azure Storage Options
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
T-SQL Tuesday #120 – Recap
The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...
Setting Certificate Backup Permissions for an Instance–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Union with temp table
insert into dbo.details ( DetailId ,DetailName ) select distinct st.stdid ,st.name from dbo.student st...
need help with a query to avoid while loop
i am struggling with a query to avoid while loop, please guide me if...
Ask SSC