amazon-rdspermissionssp-blitzsql server
I am trying to install sp_blitz on AWS RDS SQL Server (14.0.3223.3) standard edition and getting following error:
Msg 262, Level 14, State 18, Procedure sp_Blitz, Line 1 [Batch Start Line 0]
CREATE PROCEDURE permission denied in database 'master'.
Msg 208, Level 16, State 6, Procedure sp_Blitz, Line 2 [Batch Start Line 3]
Invalid object name 'dbo.sp_Blitz'.
Please advise, thanks.
You have a database trigger that logs DDL event to a table ddl_DBEvents in the database DBMonitor.
You can either delete or disable the trigger from SQL Server Management Studio in the Object Explorer under YourDatabase - Programmability - Database Triggers.
You could also disable or delete the trigger from code:
DISABLE TRIGGER dbtrg_DBEventsmodel ON DATABASE;
DROP TRIGGER dbtrg_DBEventsmodel ON DATABASE;
References:
DISABLE TRIGGER (Transact-SQL) - Books Online
DROP TRIGGER (Transact-SQL) - Books Online
There's a weird bug that only pops up on some instances of SQL Server when the Trace File path has problems. I can't diagnose those, but we took some steps to avoid that bug which are in the latest version of sp_Blitz.
Please head over to firstresponderkit.org to grab the newest version, and file an issue at the GitHub repo if you run into anything else.
Thanks!
Best Answer
That error message means you don't have enough permissions to install things in the master database.
That's okay: you can install sp_Blitz (and any other stored procs) in a user database instead, and they'll work fine there.
If you run into that same error in a user database (one you created), then you'll need to check with your sysadmins about your permissions.