Browse by Tags

Real-time replication with SQL Server reporting, strategies and resolution to the problems?

Published 30 January 8 12:23 PM | SSQA.net

Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always have a primary focus in providing protection for the data assets stored in SQL Server. Protection that...

Filed under: sql server, microsoft, data, integration, security, download, replication, reporting services, magazine, windows it pro

Transactional Replication Snapshot Issues - useful resources to resolve

Published 16 January 8 1:8 AM | SSQA.net

When you have problems with SQL Server replication where the transactional replication is common case in setting up, eventually you will have problems when the data is growing up and any sudden changes in the ETL will also have affect on replication process...

Filed under: sql server, microsoft, security, replication, merge, transactional, tips, setup, links

How to perform Replication within different domains?

Published 18 December 7 12:15 PM | SSQA.net

Got a question via email asking to configure Transactional Replication between two servers with in SQL Server 2005. By all means I would like to refer this KBA http://support.microsoft.com/kb/321822 for replication between HOW TO: Replicate Between Computers...

Filed under: sql server, security, replication, sa, transactional, impersonate, internet, different, domains

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

Published 24 August 7 3:55 AM | SSQA.net

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

Filed under: sql server, security, replication, impersonate, distributor

Simple steps to monitor Replication activities

Published 23 August 7 10:6 AM | SSQA.net

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

Filed under: sql server, integration, security, replication, monitor, troubleshoot, transactional

Replication security information you need to know with SQL Server 2008

Published 15 August 7 6:0 AM | SSQA.net

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

Filed under: sql server, security, replication, 2008, environment, 2000, 2005, enhancement

Adjust or tweak transactional replication within a high speed network environment

Published 9 July 7 4:29 AM | SSQA.net

Question: Is there anyway we can adjust the transactional replication speed according to network capacity, like speedy replication with big data packets for fast networks and replication with smaller data packets for slow networks? Answer: There isn't...

Filed under: sql server, performance, security, replication, agent, transactional

SQL Server 2005 Service pack 2 re-release & too many builds

Published 15 May 7 3:17 AM | SqlServer-QA.net (SSQA)

I feel like there is lot of confusion ( new users ) in deciding which build to apply after the re-release of SQL Server 2005 Service Pack2 during the month of March 2007. So here is the list of references I would like to share in explaining what is what...

Filed under: sql server, security, server, search, replication, sp2, i/o