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
How to get Conexant AC link Audio working for old Compaq V2000 laptop with Win7
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_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
Links for using Performance Counters (perfmon) while troubleshooting SQL Server related issues
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
SSIS Trainings - External Links
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