mssql_info

SQL 維護雜記

給於SQL Agent權限

USE msdb;
GO
EXEC sp_addrolemember 'SQLAgentOperatorRole', '使用者';
GO

給User有Truncate權限

解決方案參閱 https://www.mssqltips.com/sqlservertip/2583/grant-truncate-table-permissions-in-sql-server-without-alter-table/