Script All Logins / Users / and Roles
This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.
2016-11-02 (first published: 2013-10-31)
33,254 reads
Logins
2012-04-24 (first published: 2012-03-30)
1,854 reads
Remove Logins Script
Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.
2012-04-05 (first published: 2012-03-26)
1,364 reads
Verify SQL Server Login and Login Settings
Verifies that a specified login name exists and has correct settings.
2011-07-27 (first published: 2011-07-11)
1,746 reads
Blogs
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Forums
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
The Mythical Bus Accident
Comments posted to this topic are about the item The Mythical Bus Accident
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers