Have you tested your assumption that the silly proc1 would time out if run in a loop?

Marco

To help you out, we'll need to see the code in the stored procedure, and probably also table DDL and sample data.  Then we may even be able to help...

I would say you can't do it in that timeframe.  But then you knew that anyway.  Management is going to have to decide whether the postpone the live date or...

No need to ask the same question more than once.  Answered here.

Irene

You can set the max server memory and the min server memory on SQL Server, and SQL Server will allocate itself memory dynamically based on those constraints.  The min server...

When I've had servers restarting for no apparent reason in the past, it has often been traced to the network card.  Are your NICs teamed, by any chance?

John

I noticed after I posted my reply that you're on SQL 2005, so I may not be the best person to help.  However, if replication on 2005 is anything like...

Meena

Look at the differences between the two servers - memory, disk, processor.  Does the log file continually grow during the import on the second server?  Do you have the same...

Look at the properties of the MSSQLSERVER service in the Services applet.  You can also find the same information in Enterprise Manager by right-clicking on the server name, choosing Properties...

Dave

I think the biggest risk is in terms of performance.  Both SQL Server and IIS like to grab as much memory as they can.  If you are short on resources...

If you're asking will the query optimiser use the index on PK_TAB_B, the answer is no, not if the PK is defined with the columns in the order you specify. ...

I think you will be able to achieve what you want with replication.  You can use the replication stored procedures to transform the data using code similar to what you...

Luis

It shouldn't be a problem.  If you try to create a stored procedure that calls another that doesn't exist, you'll get a warning message but the stored procedure will be...

Brian

Have a look at the topic SET IDENTITY_INSERT ON in Books Online.  You will want to pay particular attention to the following line:

If the value inserted is larger than...

Jef

Please will you post the DDL and some sample data for the four tables (or three if, as I suspect, table_lines and table_orderline are actually the same table).

Thanks

John