Login failed for user ‘XXXX’ (Microsoft SQL Server, Error: 18456)
Scenario You often get complained that user is not able to connect to SQL server or Application is not able to connect to SQL for some reason. There might be…
Read FullAuthor: Soyeluddin Biswas
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
Find the database file growth for all the databases in SQL Server
Introduction Find the database file growth for all the databases. It is not a good practice to keep your database file growth limited. In that case, you may get an…
Read FullHow to get all statistics information for a database in SQL Server
Introduction: Sometimes your query gives you very bad performance because of statistics as SQL database engine Query optimizer uses statistics to create query plans. Updated statistics will give you good…
Read FullSQL Instance Last restart date and time in SQL Server
Introduction: When your SQL instance was last restarted? I understand it is very simple script but we often forget simple scripts. Hence I thought to write this simple script and…
Read Full
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
Find Physical file location for all the databases in SQL Server
Introduction Very often DBAs need to find the location of the physical file (MDF, LDF & NDF) of a database. Simply we can obtain the output by executing the below…
Read Full
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