After posting some snaps to configure transactional replication in sql server having publication server as distributor, i want to share some of the issue which i got during working with it. You may also faced the same issue and got resolved as well. You can comment if you faced any other replication...
Posted to
sqlideas
by
Paresh Prajapati
on
11-05-2011
Filed under:
Filed under: sql, tsql, sql server, ms sql, ms sql server, t-sql, #SQL Server, #sql, database, sql server general, Maintenance, SQL Scripts, sql errors, SQL Server Problems, JustLearned, query, Replication
Because this was a problem that Google was zero help on and I did find a couple other people afflicted with it, I figured I’d write a post about it. The issue was this. I add a table to replication (SQL Server 2005). The option to replicate DDL changes is set to true, vertical_partition...
Problem Description One of the biggest challenges any production DBA has is ongoing monitoring of existing processes and ensuring pro active action/minimal downtime. Monitoring replication has gotten easier with new versions of SQL Server – and the Replication Monitor put in with 2005 makes it very easy...
Microsoft.com Engineering Operations (MSCOM Ops), the team responsible for architecting and managing many of the most heavily trafficked Microsoft Web sites, recently documented substantial replication performance improvements for both push and pull subscriptions in Microsoft® SQL Server® 2008 running...
My friend and SQL Server MVP, Pinal has wrote a wonderful post warning people who rename their stored procedures, functions, views and triggers. You can find his post here . The problem is that, when you rename a stored procedure, function, view or trigger, the name in [sys].[syscomments] table is not...
I came across a very strange problem recently while creating a publication. I had objects with the same name but in different schemas. For example, "dbo.Invoices", "Billing.Invoices", "AR.Invoices" and "AP.Invoices". In my case, the first object was a TABLE and...