Look at this time of year in the past and you will find it really is right in line for seasonal changes. Only the financial (mortgage) sector is really taking...

When it is timing out run Profiler to capture the system activity and locks to see if anything is pointed out. I still think Recordset.Open method with .AddNew is at...

Yep you are kinda tied to no options if you cannot use the tool as it is meant to be used.

No I am saying that even thou the table is a heap it really inserts the data in the last data page just as having the IDENTITY column as the...

No you cannot use ordinal position in the SELECT column list from a SQL SELECT query just in the ORDER BY which is the oridinal of the column list from...

Hey Mike it is better to use the INFORMATION_SCHEMA objects as is supported by MS

select COLUMN_NAME from information_schema.columns where TABLE_NAME = 'title' ORDER BY ORDINAL_POSITION

You have to open each packag to see, the only stored in the system is an encrypted version of the package binary.

To the best of my knowledge you cannot see exactly how much space a process uses becuase it there really is no definition of this. A connection as I recall...

You know there is a correlation between the index and the timeout. And looking at your DDL I can tell you we have tables with 5mil plus records doing 10's...

Sorry I don't have any reference material, just simple experience.

1) Install and configure the DB2 Universal client drivers the tool in the toolset I used was Configuration Assistant. You may...

No. The Account has no way to match to the NT Person or Group. You will need to record all their permissions and create the new account. Don't remove the...

I agree why?

This has only two possibilities

SELECT  distinct serial_no--, count(*)

 FROM Table1 nolock

where serial_no in (281,282)

and that is the result will only be working on 281 and 282.

RoR can work against Stored Procedures (may take som checking on Google but I found several comments on). Just give yor justification as to why they must use Stored Procedures...

That is the basis for sp_help_job which is the MS supported method.

As for know the SP is complete it depends on where you execute the Stored Procedure from, but let's say you do it in QA. When the Proc starts unless...