Recompiling a stored procedure and rebuilding indexes is something that many DBAs are familiar with but even then there are a lot of misunderstandings about how the process […]
Alter database failed error message when setting up database mirroring
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 ‘TCP://XXXXXX:2022’. The […]
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: – Errors cannot drop distribution database
When removing replication from a server using the wizard you might get the below error message if you choose to drop the distribution database. The reason for the […]
SQL Server Replication Series Part 1
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 SQL Server 2008 […]