This post provides a practical walkthrough on how index creation and modification affect execution plans, particularly in SQL Server 2008 R2 using FactResellerSales and DimProduct tables from the […]
“ALTER DATABASE” failed error when configuring mirroring
Error Message TITLE: Microsoft SQL Server Management Studio —————————— Alter failed for Database ‘Mirror’. (Microsoft.SqlServer.Smo) The ALTER DATABASE command could not be sent to the remote server instance […]
Loading data from Excel AcquireConnection Error
[Excel Source [108]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC0209303. There may be error […]
SQL Server Replication Series – Fixing “Cannot Drop Distribution Database” Error
When removing replication using the wizard, you may encounter the following error message: Msg 21122, Level 16, State 1, Procedure sp_dropdistributiondb …Cannot drop the distribution database ‘distribution’ because […]
SQL Server Replication Series Part 1
Introduction and Concepts This blog is the first in a series on the topic of SQL Server replication. The topics are the same for the most part for […]