SQL Server SSIS and Replication

SSIS, Replication and everything SQL Server

Usage of xp_servicecontrol is unsupported

I have seen some posts (and some forums) discussing about using xp_servicecontrol. There was also a...

Author: mangeshd Date: 01/14/2010

SQL Server 2008 transactional replication to DB2 subscriber can fail with: DB2OLEDBV2: Error "System.DllNotFoundException: Unable to load DLL 'mseidrda.dll': The specified module could not be found

Recently came across a situation where the DB2 subscriber was failing with the below...

Author: mangeshd Date: 01/14/2010

I have a old Compaq V2000 laptop (almost 4.5 years old) (Intel Centrino Mobile and 512 MB ram) and...

Author: mangeshd Date: 11/07/2009

sp_mergemetadataretentioncleanup not cleaning merge metadata during regular sync causing stale data in metadata tables

I recently came across an interesting situation in merge replication and thought I should write...

Author: mangeshd Date: 10/02/2009

sp_who2 (or sysprocesses or sys.dm_exec_requests) might show your thread being blocked by SPID -4

You might find that when sp_who2 (or sys.sysprocesses or sys.dm_exec_requests) is executed on a SQL...

Author: mangeshd Date: 10/02/2009

SQLBrowser fails with "The SQLBrowser service was unable to process a client request"

Recently worked on an issue where sqlbrowser was getting bunch of errors:<error> 07/31/2009...

Author: mangeshd Date: 08/10/2009

Replication Snapshot Folder Cleanup

Snapshot agent creates snapshots for the subscribers to initialize. These contain various different...

Author: mangeshd Date: 05/20/2009

"Virtual" subscription entries in the Distribution..MSsubscriptions table

If you are using Transactional Replication, you may find entries in your...

Author: mangeshd Date: 01/27/2009

Behavior observed due to @immediate_sync parameter of Transaction Replication when adding new article to an existing publication

  • sp_addPublication procedure for creating a new transactional replication has a parameter...

Author: mangeshd Date: 11/07/2008

Understanding Performance Counters data while troubleshooting Performance issues in SQL Server:...

Author: mangeshd Date: 11/06/2008

Content about SQL Server 2005 on Windows Server 2008

Here are some of the links related to SQL Server 2005 on Windows Server 2008 Cluster: Support...

Author: mangeshd Date: 11/06/2008

Loading data files using SQLCLR assembly causes Out Of Memory Errors on 32-bit SQL Server

Recently got one where using .NET assembly (through SQLCLR) to load data files was failing on 32-bit...

Author: mangeshd Date: 06/06/2008

How to use 'database snapshot' sync_mode while creating a new Tran/snapshot publication using sp_addpublication

Writing this blog post to ensure other can try - how to use 'database snapshot' mode of snapshot...

Author: mangeshd Date: 05/30/2008

Altering properties of a Column fails with: Cannot alter column 'column-name' because it is 'REPLICATED'

Recently had one where Altering column properties or running sp_rename against that column was...

Author: mangeshd Date: 05/22/2008

Non-dbo users may not be able to create Dabase Diagrams in SQL Server 2005

When non-dbo users opens a Dabase Diagram in SQL Server 2005, they get...

Author: mangeshd Date: 02/08/2008

A DDL Admin user is not able create/alter/delete tables from inside a database designer diagram in SQL Server 2005

If you create a DDLAdmin user (a member of the Db_ddladmin database role), still she will not be...

Author: mangeshd Date: 02/08/2008

If you are using SQL Server Notification Services 2.0, you can get "Error 4085: The number of WaitHandles must be less than or equal to 64."

If you are using SQL Server Notification Services 2.0 and you are using a complex NS application...

Author: mangeshd Date: 02/08/2008

OLEDBDestination in SSIS does not report low-level error message

I got a new one where we found that SSIS does not report the actual low-level error message while...

Author: mangeshd Date: 11/28/2007

You may be unable to connect (using TCP) to a SQL 2005 instance if you have Venturi Wireless Software Installed

I recently came across a situation where If you are trying to use TCP connectivity to connect to a...

Author: mangeshd Date: 11/22/2007

Execute SQL Task in SSIS cannot show the PRINT Statement outputs from a stored proc

If you have a stored proc that has some print statements inside it and you execute it using Execute...

Author: mangeshd Date: 09/12/2007

Linked Server Creation fails after applying SQL Server 2005 Service Pack 2

I came to know about an issue with Linked Server Creation: Creation of a new linked server using the...

Author: mangeshd Date: 07/25/2007

SSIS (BIDS) GUI not displaying the borders of the tasks

Recently came across an interesting one where the SSIS GUI was not showing the borders of tasks...

Author: mangeshd Date: 07/23/2007

Issue with Web Services Task in SSIS

Recently I've observed a new issue with Web Services Task in SSIS (2005 build). The Web Service Task...

Author: mangeshd Date: 07/13/2007

Please find some useful SSIS recorded presentations here (external links): Ignoring a SSIS...

Author: mangeshd Date: 07/09/2007

MS Access Merge Subscriber not able to upload changes when the column order is non-sequential for article

If you have a merge publication with many articles and you may found that in one of the articles,...

Author: mangeshd Date: 06/05/2007