Remove SQL Logins from All Databases and SQL Server
Locate and remove/delete user logins from all databases and even SQL server.
2008-08-08
11,083 reads
Security
2008-07-23
2,990 reads
To Check for Orphaned Users in a Database
This script is helpful to identify the orphaned users in a database, useful when we restore a database from a different location.
2013-05-22 (first published: 2008-07-20)
2,672 reads
How insiders hack SQL databases with free tools
When you find out how easy it is for insiders to hack SQL Server databases with a few free security tools and a little luck, you'll re-examine your database security practices.
2008-06-30
8,714 reads
2008-05-15
3,366 reads
2008-03-26
2,960 reads
2008-03-24
3,180 reads
2008-03-19
3,064 reads
2008-03-11
3,140 reads
2008-03-10
2,412 reads
Blogs
T-SQL Tuesday #185–Being a Video Star
By Steve Jones
This month we have an interesting invite. Erik Darling is the host, and since...
Building Resilience: Leadership Insights from Sports
By Chris Yates
In the bustling world of sports, leadership appears as a beacon of hope and...
T-SQL Tuesday 185 - Produce a Video!
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Snapshot Replication: Pre-application script to check prerequisites
Is it possible to write a script that checks a subscriber's environment for prerequisites...
t-SQL help..
I have the following...anyone can point me the right direction to rewrite this code?...
install sql express
I yesterday dowload a sqlexpress and intalled on one of a testing database for...
Question of the Day
The User Login
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers