Thanks Drew. That worked!!

MAX DOP : 6

Cost Threshold for Parallelism: 15

select * from sys.dm_os_wait_stats where wait_type = 'threadpool';

wait_typewaiting_tasks_countwait_time_msmax_wait_time_mssignal_wait_time_ms

THREADPOOL303468614170

This worked for me!

Added OPTION(Recompile) at the end of query in stored procedure.

Thanks

Vishwanath

I have found the issue long back but forgot to post here.

The problematic subscriber is a named instance and the team who setup the replication used the script to add...

You can use below script by just enter the database name which you want to exclude and provide the spname as input variable.

DECLARE @SPNAME VARCHAR(100)

DECLARE @DBNAME VARCHAR(100)

DECLARE @SQLCMD VARCHAR(1000)

SET @SPNAME...

If publication already exists, Configuration distribution option is not available.So, Check if you have any publication configured and also for distribution DB under system databases list.

Thanks Gail & Steve for answering my question...

Thanks

~Vishwanath

Hi,

You can append a random number to the file. This will create files with unique names.

Select rand()

Thanks

~Vishwanath

Any one got this type of request?

Thanks for your help. It got resolved

I gave complete path of sftp2 in bat file and this made the things working

Try this.

USE [DSReports]

GO

/****** Object: StoredProcedure [dbo].[Waterfall_New] Script Date: 08/23/2011 10:56:14 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[Waterfall_New]

-- declaring the variables to be used in the procedure

(

@FieldDate...