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 […]
Adding a parameter to the Report
We add parameters to reports to be able to dynamically fetch very selective data from the underlying database. Sometimes parameters are used for controlling the behaviour of a […]
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 […]