AWS/RDS – SQL Server – Error – “The EXECUTE permission was denied on the object ‘agent_datetime’, database ‘msdb’, schema ‘dbo’ “

Background Here is an error I have been wanting to talk about for a while here. Code msdb.dbo.agent_datetime Outline The agent.date_time function accepts two integer values, date and time. And, returns the corresponding datetime value. SQL Output Output - AWS Here is the result when we issue command against an ASW/RDS MS SQL Server Instance. … Continue reading AWS/RDS – SQL Server – Error – “The EXECUTE permission was denied on the object ‘agent_datetime’, database ‘msdb’, schema ‘dbo’ “

AWS/RDS – Delete Instance

Background For one of the projects we are standing up in AWS, I will like to test out different Instance configuration options. Constraints It has a big database and I did not want to continue eating the cost of standing up various instances.  It is time to stand down of some of the instances.   … Continue reading AWS/RDS – Delete Instance

SQL Server Agent on AWS/RDS

Background There is quite a bit of SQL Server management surface area that is not available when running on AWS/RDS.   Surface Area For instance with SQL Server Agent :- SQL Server Agent Category Add new category API sp_add_category Error Msg 229, Level 14, State 5, Procedure msdb.dbo.sp_add_category The EXECUTE permission was denied on the … Continue reading SQL Server Agent on AWS/RDS

AWS/RDS – SQL Server – Self Identify

Background Playing around more and more with AWS/RDS. There is quite a bit of restrictions compared to self hosted platform. Self Identify To use some code on premise or cloud hosted, need to sprinkle in conditional statements. Code Outline Here are some fingerprints to look for :- Server Name AWS/RDS EC2AMAZ-N4O Databases RDSADMIN SQL Output … Continue reading AWS/RDS – SQL Server – Self Identify