Came across this error while executing a SSIS package through a SQL Agent Job on a SQL Server 2008 server.The job is running under a windows security account and the SSIS package is stored on file system of the server. The exact error message received...

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...

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. http://visualstudiogallery.msdn.microsoft.com...

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 ...

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. ...

Encountered this error while running a SSIS package through a SQL Agent Job on SQL Server 2008. The processing in the package is a pretty simple and the purpose is to export data from few tables from one SQL Server to another. Both the source and target...

This error message comes when you are trying to enable CDC on a SQL Server 2008 database for which the owner is not "sa". The exact error message will be as shown below. Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 186 ...

I encountered this error when explicitly inserting values in an Identity column of a Table that is created in a SQL Server 2008 Database and the DB is not part of any kind of Replication. I have made sure that "Identity_Insert" is turned on for that table...

This error message comes while performing one (Or both) of the following actions. 1. Run SSIS Package using dtexec.exe (Either from a command file or through a Job running on SQL Server 2008) 2. Open SSIS package using VS2008 or BIDS If you have...

I got this message while checking-in a file after the fresh installation of Visual Studio 2008 Professional and TFS client. This message disappeared after installing VSTS 2008 Power Tools. The download link is provided for your quick reference here...

Sometimes we have to transfer the permissions from one object to another. Here the object could be a table or view. We can write a straight forward script using GRANT and REVOKE statements if this requirement is for one or two objects. But what if more...

Sometimes the actual error lies somewhere and the error message directs us to look at something else. We end up wasting time in this process as the error message diverted us. Recently, we came across one such kind of scenario while calling a SSIS package...

This is a proper netwrok error and has nothing to do with the coding if any of your jobs/queries/packages fail with this message. Please refer the following article for the workaround. http://support.microsoft.com/kb/942861/en-us Another work...

I guess at least once every SQL developer might have come across this error on SQL Server 2008 while running a SQL job that calls a package. Reason for the error: Old version of the DTEXEC is picked up by SQL Server instead of the new one. That means...

An error occurs if you try to open a DTS package from Leagcy --> Data Transformation Services in SSMS of 2008. The message says, SQL Server 2000 DTS Designer Components are required to edit DTS packages. Install the special web download, "SQL Server...

Reading a DTS/SSIS programmatically helps a lot in doing impact analysis. Consider a scenario in which all the packages containing a particular table or stored procedure need to identified. Let me give another usage scenario for this. The sql native clinet...

This is a pretty simple task but I would like to provide a generic method for doing this. It will help if the requirement is one (or all) of the folowing. I have only considered non-clustered indexes along with the Inclued columns and filtered indexes...

This kind of requirement may come if VSTS is used for test automation and the test results have to be loaded to a Database. Since the output of test automation is an xml file, let us look at how we can create tables and load them with data by reading...

Let us assume that there is an Employee table with EmployeeId as the Identity column in which some values are missing. The following batch will show all the missing values in that Identity column. The logic I preferred is to create another table with...