SqlServer-QA.net

Another security vulnerability or rather call in the sense of security experts that ''A zero day vulnerability has been reported in SQL Server''!  Though its a not serious flaw or problematic loophole to worry but still its a security flaw in using the sp_replwriterovarbin extended stored procedure, which is an undocumented one as per ...

Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always havea primary focus in providing protection for the data assets stored in SQL Server. Protection that covers the security and data recoverability is also equally important, during this process ...

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. In this case I would suggest in referring to links ...

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 Running SQL Server in Non-Trusted Domains or Across the Internet. Also the ...

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 the publisher in the list, click ... In agent connection mode, select ''impersonate the ...

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 of publications and subscriptions, allowing you to answer common questions, such as ...

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 much I believe compared from 2005 to 2008. While going this replication security process ...

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 any such option is available within SQL Server to state. For all sorts of performance and with ...

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 in the recent releases for SQL Server 2005: Build 3161 KBA Build 3152 KBA In both the ...