Comparing data between two tables in SQL Server

As a database developer sometime or the other you might have come across this requirement and it can be achieved using many ways including built-in features like Checksum and TableDiff utility. However, I would like to share an alternate way to achieve the objective, which might be useful in some situations. Usually the intention of comparison is to find…


Message "TFS10139: The following check-in policies have not been satisfied" comes in VSTS2010

Got this message after the upgrade from VSTS 2008 to VSTS 2010 while checking in a file. The message disappeared after installing “Team Foundation Server Power Tools April 2010” from the below location. Hope this helps 🙂  


Error while enabling CDC on a table. The server principal "xyz" is not able to access the database "msdb" under the current security context.

We came across the following error after successfully enabling CDC on a Database and then trying to enable CDC on a table in SQL Server 2008 SP1 (Version 10.0.2531.0) Msg 22832, Level 16, State 1, Procedure sp_cdc_enable_table_internal, Line 607 Could not update the metadata that indicates table [dbo].[MyTable] is enabled for Change Data Capture. The failure occurred when…


SSIS Data Flow Task fails with Unspecified Error

We have few SQL Agent jobs on SQL Server 2008 (10.0.2531) and these jobs are executing SSIS packages, which are created using BIDS 2008. The jobs are scheduled to run daily at a low frequency. The intention is to run these jobs like a demon service. We started getting the “Unspecified Error” at random intervals of time and…