Find out when/who dropped an object without auditing
If your environment doesn’t have any kind of auditing and you need to find since when an object was dropped.
Tag: tsql
T-SQL script to get detailed login permissions
This script is very helpful when you need to know all the permissions a user have in detail.
Method to update LOB data with minimal log
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
Using SQL Operations Studio Agent
SQL Operations Studio Agent is visual way to see, edit and create SQL Server jobs and everybody was asking this
