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,598 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

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

One of the things I’ve tried hard to do in database development situations if...

The T-SQL Tuesday topic this month comes James Serra. What career risks have you...

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?