-- This script creates the SQL to create the role members for all roles on the database. -- This is useful for scripting permissions in a development environment before refreshing development with a ...
-- This script globally enables or disables the specified trace flags. -- Requires the SQL Server account to have Local Admin rights (which it normally doesn't) so this script may be of limited value.
You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here’s how you can do so by using SQLAgentReaderRole in SQL Server. We may earn ...