If your environment doesn’t have any kind of auditing and you need to find since when an object was dropped.
This script is very helpful when you need to know all the permissions a user have in detail.
Use the .WRITE (expression, @Offset,@Length) clause to perform a partial or full update of varchar(max), nvarchar(max), and varbinary(max) data types. For example, a partial update of
SQL Operations Studio Agent is visual way to see, edit and create SQL Server jobs and everybody was asking this