Try stopping and starting the agent. If that fails, reboot the SQL Server. If it still doesn't work, drop and recreate replication.

Add an Execute SQL task and put the Truncate Table statements in that task. Then add an On Success or On Complete precedence from it to the next step you...

I'm currently evaluating Quest's new product Capacity Manager. In addition to tracking these statistics, it forecasts your future performance needs so that you know well in advance when you will...

Well, whatever value you are passing in for @sHMC and @RowCounter are already in the table.

I would love to help, but it turns out that the Psyche class I took wasn't about mind reading after all.

In all seriousness,...

On the contrary, this is a much simpler way to handle this than creating a full backup. When making a change on a single table, I've often done a simple...

I don't think the creator of this question understands what a "narrow table" is. A narrow table is a table with very few columns not rows. If...

If you want to script it without using EM, you'll have to create your own process to script it out.

Here's the secret to how I automated mine: I have a (non-replicated) table in the publisher called ReplicatedTables. If a table is listed in that table, it gets replicated; if...

You probably passed the wrong value for one of the parameters of sp_addarticle. Can you post the query you used?

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10946

Well, Call is not a T-SQL command, it is an ODBC/SQL Native Client command. So it would appear that the change is not with SQL Server itslef, but rather with...

1. Heather knows about the "script view as" (read the rest of her post).

2. The keyboard shortcuts doesn't apply here as there is nothing you can add to the shortcuts...

Explain "doesn't work". Does it give you an error? If so, what is it? Does it say completed successfully yet nothing was done by the procedure?

And post the code please.

Help...

Well, either you typed in the name of the server wrong or it is inaccessible or the login credentials are wrong or the login does not have permission to access...