Thank you for the information.

We have already migrated two of the sites successfully by copying over the system databases. What we did was prepare the new server to look like the old server by...

I realize your advice is the safest way, but it also could be error prone if I miss anything. The other problem is that the server is heavily involved in...

The migration from the standalone server to the cluster is fast approaching. I was wondering if the following plan can be used. Keep in mind the cluster will be using...

Thanks for your help with this. Forgive me, but I'm not that .NET savvy. Does that mean the developers would need to replace DAAB with SPOIL in order to set...

You guessed it, that is what the sqlserver connections are showing. We are now trying to tune the SP so that it will always run under 30 seconds, but pending...

Yes, upon research I realized that and asked that they set CommandTimeout property to greater than 30 seconds. Unfortunately, the developers said that they cannot do that because they are...

My main question is why is this timing out at 30 seconds when both the database server and the connection string has a timeout of 600 seconds?

The SP code is below:

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

CREATE  PROCEDURE [dbo].[csp_Flights]

 @Loc CHAR(3) ,

 @CustCode  CHAR(2)

AS

 SET NOCOUNT ON

BEGIN 

DECLARE @LDPLSYS INTEGER

SET @LDPLSYS = 0

select @LDPLSYS = COUNT(1) FROM CAIR..System_parameters

where...

Here is the execution plan from profiler:

Execution Tree

--------------

Sort(DISTINCT ORDER BY[FLIGHT].[ActArvlDttm] ASC, [Expr1006] ASC, [Expr1007] ASC))

  |--Compute Scalar(DEFINE[Expr1006]=[FLIGHT].[FlightID]+' -...

I have started profiler and am capturing the execution plan. Yes, the optimization job runs weekly against the database in question and I verified it has been running successfully. I...

Thanks for the reply. Actually, working with the SOX auditor I found a sqltsp.log, sqlsp.log and a SQL2000-KB9997618.00.2040-x86-ENU.log file in the C:\WINDOWS directory that showed when the software was installed.

I think I have resolved the issue. I changed the distribution agent profile to have a lower batch size and a longer query timeout setting and the subscription is starting...

I have a correction to make, the table has not been recreated at the subscriber.

I agree but evaluating for @OUT <> '' also returned true, which it shouldn't since it was set to ''.