each database has a system view named sys.database_role_members, which is just ID's associated ot roles; you have to join that against database_principals to get what you are after.
you'll need...

After a large delete, you'll need to rebuild the indexes on the table.
the deleted items still take up the pages they used to occupy, and reindexing rearranges and deletes...

I managed to break the javascript in a post, so I cannot edit the post, nor use the mini "Explore "menu in the upper right that typically has a link...

i have this saved from something i built off of an msdn, does this help?

left join ReportSchedule rs on Sch.ScheduleID = rs.ScheduleID
  left join...

I tried slapping a full example together, but i find it pretty annoying that Format-Table is leaving extra whitespace.
there a line in the  beginning where  a header would be...

no problem with asking for another look, I'm glad to help.

yeah you could potentially be seeing new logins being created after your delete, so they show up in your query;...

you should...

very weird;

since you got an SMO error, i might worry that you are using an older version of SQL Server Management Studio to connect to a higher version of SQL...

are you a sysadmin?

are you connecting via a dedicated connection?

does this return anything with the IsEncrypted column being 1?

SELECT

sm.object_id,

OBJECT_SCHEMA_NAME(sm.object_id) AS SchemaName,

OBJECT_NAME(sm.object_id) AS object_name,

o.type, o.type_desc,

sm.definition,

CAST(CASE WHEN...

you could create it WITH NO CHECK so it does not validate the existing data, and would be untrusted...but why would you want to do that?

referential integrity is a good...

i just confirmed this still works on SQL2016, so you are good for all lower versions too.

ok, try opening a dedicated admin connection,

and in the database in question, add this...

take a look at this thread, which explains you can use a combination of the Dedicated Admin Connection and a procedure to view the encrypted definition.

http://jongurgul.com/blog/sql-object-decryption/

if you happen to...