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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(23)

You rated this post out of 5. Change rating

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

35,461 reads

Search SQL Error Log

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

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

2,072 reads

Blogs

Even preparing for a class or seminar with set materials takes a lot of...

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

This image is from 2010, and it goes along with my last post of...

I have a login I need to deny connect to on a server, but...

All week we've had issues with the site being up and down. There's been...

I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?