The DBCC OPENTRAN command gives you the information you need by displaying information about the oldest active transaction and the oldest distributed and nondistributed replicated transactions within the specified database. You can run this against any database and it gives very useful information very quickly. /*Select the database where you want to check open transactions*/ use History […]
Enable SQLCMD Mode in SQL Server Management Studio
Read more
SQLCMD mode in SSMS allows you to use the command line tool within SSMS. Using this feature of the SSMS, you don’t have to connect SQLCMD using the command prompt. It is really very helpful and less distracting when you want to connect with multiple SQL Server instances. You can follow the below steps to […]