This script will allow you get all the users and roles with permission on objects on all databases.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.61 (23)

You rated this post out of 5. Change rating

2014-09-18 (first published: 2009-03-05)

34,751 reads

Search SQL Error Log

Easiest way for searching inside one or all SQL Server Error Logs

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (4)

You rated this post out of 5. Change rating

2009-04-14 (first published: 2009-03-05)

2,059 reads

Blogs

How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...

Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

So, I have an interesting situation that I need a double-check on. One of...

I am new here and will like to learn as days goes

I have completed a successful migration of an access database to SQL Express. Most...

I have this data in a SQL Server 2022 table:

PlayerIDPlayerNamePlayerStatus
1The \%ChampActive
2The ChampActive
3The_ChampionActive
4The__ChampionActive
5The\_ChampActive

How many rows are returned by this code in SQL Server 2022?

select PlayerName from player
where playername like 'The\_C%' escape '\'