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,599 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,076 reads

Blogs

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...

When mirroring was first released for Azure SQL Database, it used Change Data Capture...

We have two "identical" instances of an ASP.NET web service (or so I have...

Comments posted to this topic are about the item OPENQUERY Flexibility

Comments posted to this topic are about the item A Full Shutdown

Which of these are valid OPENQUERY() uses?