Browse by Tags

• 2000
• 2005
• 2008
• distributor
• enhancement
• environment
• ftp
• Hardware
• hotfix
• impersonate
• Integration
• kba
• linked
• monitor
• oracle
• parameter
• performance
• publisher
• security
• service pack
• service pack2
• SQL Server
• ssas
• ssis
• SSMS
• subscriber
• transactional
• troubleshoot
• tuning

• Property LoginSecure cannot be changed or read after a connection string has been set.

  I was stumped on the above error when configuring distributor afresh using SSMS. Eventually found that this is due to impersonate settings that were not setup, so to resolve this simply: Right click local publicaiton->Distributor properties Select Read More... Posted Friday, August 24, 2007 6:55 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, replication, impersonate, distributor

• Simple steps to monitor Replication activities

  There are few simple steps involved to monitor the replication actvites, as usual with Replication Monitor is useful to monitor the overall health of a replication topology. Replication Monitor provides detailed information on the status and performance Read More... Posted Friday, August 24, 2007 1:06 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, Integration, replication, transactional, troubleshoot, monitor

• FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: "OLE DB Provider 'OraOLEDB.ORACLE' for Linked server <LinkedServerName> returned message"

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you try to create an Oracle Read More... Posted Monday, August 20, 2007 7:40 AM from SSQA.net | (Comments Off) Filed under: SQL Server, kba, replication, service pack2, linked, oracle, publisher

• FIX: Data is not replicated to a subscriber in a different partition by using parameterized row filters in SQL Server 2005

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: Data is not replicated to a subscriber Read More... Posted Monday, August 20, 2007 7:39 AM from SSQA.net | (Comments Off) Filed under: SQL Server, kba, replication, subscriber, parameter

• The following KBAs were recently modified for Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition.

  The following pages were recently modified for Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition. FIX: Error message when you synchronize a subscription by using Windows Read More... Posted Friday, August 17, 2007 6:39 AM from SSQA.net | (Comments Off) Filed under: SQL Server, ssis, service pack, kba, replication, hotfix, ftp

• Dust out few tasks to gain transactional replication performance in SQL 2005

  Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at Read More... Posted Thursday, August 16, 2007 7:20 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, Integration, SSMS, ssas, replication, transactional, tuning

• Replication security information you need to know with SQL Server 2008

  I was able to install SQL 2008 July CTP as a Virtual Image, tried to test few replication tasks to know what has been changed since last versions. At this time I would like to use the replication scripts from SQL 2000 version to see what it takes, nothing Read More... Posted Wednesday, August 15, 2007 9:00 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, enhancement, environment, 2008, 2005, 2000, replication