The Curious Engineer

All blogs / Databases

SQL Server SSIS and Replication

learn.microsoft.com/en-us/archive/blogs/mangeshd

SSIS, Replication and everything SQL Server

DatabasesMicrosoft blogsMSDN archive

’10’15’20’25
Posts
24 from 5 Jun 2007 to 14 Jan 2010
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/mangeshd/feed.xml

2010 2

  1. Usage of xp_servicecontrol is unsupported
  2. 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

2009 5

  1. How to get Conexant AC link Audio working for old Compaq V2000 laptop with Win7
  2. sp_who2 (or sysprocesses or sys.dm_exec_requests) might show your thread being blocked by SPID -4
  3. SQLBrowser fails with "The SQLBrowser service was unable to process a client request"
  4. Replication Snapshot Folder Cleanup
  5. "Virtual" subscription entries in the Distribution..MSsubscriptions table

2008 9

  1. Behavior observed due to @immediate_sync parameter of Transaction Replication when adding new article to an existing publication
  2. Links for using Performance Counters (perfmon) while troubleshooting SQL Server related issues
  3. Content about SQL Server 2005 on Windows Server 2008
  4. Loading data files using SQLCLR assembly causes Out Of Memory Errors on 32-bit SQL Server
  5. How to use 'database snapshot' sync_mode while creating a new Tran/snapshot publication using sp_addpublication
  6. Altering properties of a Column fails with: Cannot alter column 'column-name' because it is 'REPLICATED'
  7. Non-dbo users may not be able to create Dabase Diagrams in SQL Server 2005
  8. A DDL Admin user is not able create/alter/delete tables from inside a database designer diagram in SQL Server 2005
  9. 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."

2007 8

  1. OLEDBDestination in SSIS does not report low-level error message
  2. You may be unable to connect (using TCP) to a SQL 2005 instance if you have Venturi Wireless Software Installed
  3. Execute SQL Task in SSIS cannot show the PRINT Statement outputs from a stored proc
  4. Linked Server Creation fails after applying SQL Server 2005 Service Pack 2
  5. SSIS (BIDS) GUI not displaying the borders of the tasks
  6. Issue with Web Services Task in SSIS
  7. SSIS Trainings - External Links
  8. MS Access Merge Subscriber not able to upload changes when the column order is non-sequential for article