select rp.name as database_role, mp.name as database_user
from sys.database_role_members drm
  join sys.database_principals rp on (drm.role_principal_id = rp.principal_id)
  join sys.database_principals mp on (drm.member_principal_id = mp.principal_id)
order by rp.name

--...

Try this for SQL Server 2008 R2 and above

The sizes will convert to mb, gb, or tb depending on how large the drive is.

The query only works with one server. ...

• This reply was modified 5 years, 9 months ago by SQL BrainBox.
• This reply was modified 5 years, 9 months ago by SQL BrainBox.
• This reply was modified 5 years, 9 months ago by SQL BrainBox.
• This reply was modified 5 years, 9 months ago by SQL BrainBox.

Those are very good points.  I too have taken safety precautions given the fact that my account has access to everything.  For the app, I use my windows credentials to...

the easiest method is to use...

"select...from sys.master_files mf cross apply sys.dm_os_volume_stats (mf.database_id, mf_file_id) vs"

then CREATE a read-only DUMMY DATABASE that has data files across all drives....

I had the same problem. I ran an index defrag process but the transaction log became full and the defrag process errored out. The transaction log remained large.

Yup deleting and adding again to the dimension usage tab solved my issue.  I'm now able to save and process everything.

So a little background.  I have a date...

I encountered the same issue with a report subscription where the developer created a separate dataset for each report parameter.  There were close to 2 dozen parameters.

Creating or...

I actually found an easy solution to this fix since I had the same issue.

I was trying to remove the filegroup [fg_LMeterDetail_13] but got the "cannot be removed because it...

simple fix exec [database name].[object owner].[stored procedure name]

you must reference the database name in either the connection string or command text. Otherwise SQL will use the default database which...

Yes, that error occurs when your database collation is set to case sensitive.

Msg 208, Level 16, State 1, Line 1

Invalid object name 'SYS.DM_DB_INDEX_USAGE_STATS'.

To resolve, just CTRL+SHIFT+L to convert the text...

Thank you all. I really appreciate your feedback and will work with your suggestions.