Category: Microsoft Sql Server
Truncate log file up to 504 KB – SQL Server 2008, 2008-R2 & 2012
USING POWERSHELL TO BACKUP SQLSERVER DATABASES for Express Edition
SQL Server memory performance metrics – Part 5 – understanding Lazy Writes, Free List Stalls/sec, and Memory Grants Pending
Check if Service is running and start it when it is not running
How to migrate the logins of a database to a different server
Cloning a SQL Server Login with all permissions using PowerShell
Get logins, databases users/roles and object level permission (T-SQL)
Introduction
This script contains three code parts, one to get the result of server level logins and related roles, one to get the result of user databases’ users and related roles, one to get the result of object level permission of specific database.
Scenarios
This script can be used to get the following results:
- Server level logins and related roles
- User databases users and related roles
- Object level permission of specific database
https://gallery.technet.microsoft.com/scriptcenter/Get-logins-databases-816f66b2