Unable to begin a Distributed Transaction

Problem When your application uses the distribution transaction then you may encounter below error. Error: The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "Linked_Server_Name"…

Read Full
152 views 19:22 0 Comments

Database restore history in SQL Server

Introduction This script will help you to get the restore history for all the databases. If you need to know the restore history only for a single database then please…

Read Full
190 views 22:49 2 Comments

Set Auto growth for all the databases wit T-SQL

Introduction Managing the growth of database files is an essential aspect of maintaining a healthy SQL Server environment. As databases grow over time, it becomes crucial to configure appropriate growth…

Read Full
118 views 18:45 0 Comments