SQL

Query to change the schema / Owner of database objects like  EXEC sys.sp_changeobjectowner <Object Name>, <New Owner Name> ...

There are many reason for not shrinking of Transaction log. Our production database backup was failing for last several weeks, so the backu...

Below query returns the SQL Server name, Version, Edition, Authentication Mode, No of CPU and RAM available in system SELECT SERVERPROPER...

In SQL Server 2008 or later following are the backup types: Full backup Differential backup Partial backup Differential partial backu...

You will not be able to know from which system records are deleted directly. But you can get this information if you add a trigger and a lo...