Even though this was more or less out of curiousity, I finally got my answer last week at the SQL Pass Conference in Seattle.

I sat down with an actual developer...

nplace6530 (7/29/2008)

---

Hi all

I recently decided to start to report on durations of jobs that I have scheduled on my SQL 2005 system. Rather than reinvent the wheel I thought a...

And here they are... the 5 sp's that I get for this table:

CREATE TABLE [dbo].[test_for_replication](

[id] [int] NOT NULL PRIMARY KEY,

[name] [varchar](30) NOT NULL,

[description] [varchar](255) NOT NULL)

The ones being used are:

sp_MSdel_dbotest_for_replication

sp_MSins_dbotest_for_replication

sp_MSupd_dbotest_for_replication

The...

SQL Server 2005.

Transactional (standard).

Distribution Server set up on another machine.

As straight forward a publication as you could imagine. Single table, no row filters, no column filters.

I'm fairly new to replication,...

Hi Andy,

Great Article. Very thorough and informative.

When I create a publication, I use the default settings (CALL for INSERT and DELETE and SCALL for UPDATE), and as expected I get...