The GUI will run the SPROC sp_refreshsubscriptions after adding articles. This SPROC updates the subscription metadata to include the newly added table.

To run this manually, it's a simple...

We did have an instance or two that we were waiting for a fix coming in a CU, and that can be painful.

I'm definitely not advocating doing away with the...

I just voted for the service packs.

For about 2 years we were mired down in deploying the CUs as they were released. We tried to keep versions consistent...

I really like the new look, but I wish it was wider.

I miss the highlights at the top, but I think I would miss it less if the articles were...

I know this is an old post, but it helped me to generate the following script that works against a SQL 2000 linked server (Update DBServerName, DBName, and TableName appropriately):

SELECT...

Thank you ArloUSA. I had the same issue and the script on the blog post you reference worked perfectly.

I know I'm reviving an old thread, but I just ran into this issue the other day and I decided to take the time to blog on the topic of...

We are also experiencing this issue on SQL 2008 R2 x64. The same SPROCs and processes that are hanging on SQL 2008 R2 ran successfully on SQL 2005 x64.

One...

Try this on for size:

DECLARE @ServerName varchar(32)

DECLARE @sql varchar(1024)

SET @ServerName = 'server-a\testdb'

SET @sql = 'SELECT Drive, [MB Free] FROM OPENQUERY([' + @ServerName + '],

''SET FMTONLY...

It's funny how you find the answer to something when you stop looking for it. I was looking into another replication issue when I found it.

Thanks for all your...

FYI, I found this in the SQL Server 2005 BOL (note bolded statement):

-UseInprocLoader

Improves the performance of the initial snapshot by causing the Distribution Agent to use the BULK INSERT...

After applying SQL 2005 CU8 to our Distributor, the Distribution Agent now recovers from failures during the initial snapshot push . It will still "start over" but it now...

noeld (8/15/2008)

---

The BCP files are created by the "SNAPSHOT" agent that runs on From that same machine. Please verify that the "DISTRIBUTION" agent is actually using the *same* account that...

noeld (8/15/2008)

---

When databases are...

I have run into the same situation and most of the time the sp_removedbreplication command takes care of it.

However, on rare occasions the SPROC is not able to...