Thanks a lot. Assigning full control to SQL SErvice Account on respective file/folder works.:-)

The query with inner joins is not getting correct results in all cases. Try this one

select sys.schemas.name 'Schema'

, sys.objects.name Object

, sys.database_principals.name username

, sys.database_permissions.type permissions_type

, sys.database_permissions.permission_name

, sys.database_permissions.state permission_state

, sys.database_permissions.state_desc

, state_desc...

I am also experiencing similar problem occasionally with our workload while running in SQL 2014 sp1 getting error: There is insufficient memory available in the buffer pool. I run the...

I found an easy way in SSMS menus select Window > Reset Window Layout and click yes on the confirmation box. Now you can click and open Registered servers window...