Have you tried opening the sp via EM and pasting the code in then saving ???

There is a limitation and that is 8000.  Straight from BOL:

Using EXECUTE with a Character String

Use the string concatenation operator (+) to create large strings for dynamic execution. Each string...

Try adding GO between the PK re-creates and each other and the ALTER TABLE/COLUMN statements:

ALTER TABLE....

GO

RECREATE PK

GO

RECREATE PK

GO

The sp might just want some attention....

Don't know how to do it in field def.  Why not write the code to always UPPER(textbox.value)?????

Create 2 different views.  1st to provide the hours difference and the 2nd to pull the information from the 1st view

umm..  What kind of hardware are you performing this stree test on??  My computer looked at it and promptly turned itself off.  I would look at changing the TABLE variables...

try setting up the 2 servers as "Linked Servers" to each other or from just one side.  This way you could do

SELECT * FROM LinkedServerName.DatabaseName.Owner.Table

This would allow you...

Try changing the ADODB cursorlocation to be adUseClient.  Then you should be able to get a recordcount.  The problem is the recordcount uses client always and when the cursor location...

Heres another tack on how to check snapshot-style daily.  Put this in a sp and enjoy

SET NOCOUNT ON

DECLARE @DatabaseName varchar(128)

--

-- Create temp...

Are you using any dynamic SQL i.e. EXEC @SQLCommand or EXEC sp_executesql @SQLCommand type coding?

Without seeing a snippet of the code that might be a reason.  Another might be depending...

There are several different ways of doing this.  I would look at trying to create a view that would do something like:

CREATE VIEW vwInsertRecords

AS

SELECT t1.*

  FROM tmpTable t1

    LEFT...

Create either 2 different UDL connections or 2 different SQL Server OLE DB connections.

Each of these can be configured differently.  Granted with this approach you will need to write either...

bondada,

I think the problem lies with the call to the 1st sp.  Inside the 1st sp is where the problem comes in.......  I think it is because the trans...

Have you tried to reset your connection ipconfig /release_all????

and try again

I'll throw this out for fun...

1. Create a calendar table with just the RecordDate from the 1st day of the 1st year that you started this out until 2028 (why because...