Try sp_procedure_params_rowset

Article at : http://p2p.wrox.com/archive/activex_data_objects/2002-02/4.asp

Wild guess : Query Analyser -> Tools -> Options -> Results -> Max Char / Col

BOL 2000 : Every Microsoft® SQL Server™ 2000 database has a transaction log that records all transactions and the database modifications made by each transaction.

1)Recovery of individual transactions.

2)Recovery of...

Try

"Select convert(float, pm_valor) from ger_pm

where pm_id = 'PM_PRPIS' And IsNumeric(pm_valor)=0"

Try

"Select pm_valor from ger_pm

where pm_id = 'PM_PRPIS' And IsNumeric(pm_valor)=0"

BOL 2000:

Note In client applications, some display formats do not translate appropriately for all locales. If you are supporting multiple locales or a locale different than that of the...

Look at

Select GETUTCDATE(),GetDate()

BOL 2000:

GETUTCDATE

Returns the datetime value representing the current UTC time (Universal Time Coordinate or Greenwich Mean Time). The current UTC time is derived from the current local...

Did anything operationally changed that cause the 1gb log? Change in the backup procedures?

To answer the original question I think a stored procedure! May start looking at XML with a structure similar to question,answer, etc. which get passed to and parsed in a...

Sorry I miss the "check boxes" part.

I think I will still try and stick to the normalized idea, in other words insert three records for question xx, a value for...

On Error Resume Next

if Not IsNull(evdate) And IsDate(rs("press_date").value) Then

evdate=monthname(month(evdate)) & " " & day(evdate) & " " & year(evdate)

Else

evdate=""

end if

Syntax may be wrong for vbscript!

Can the asp page not pass the question number back together with the answer, then you only have to store the answer number/id and the question id?

Example: http://www.freevbcode.com/ShowCode.Asp?ID=2180

Rather than Exists and select a few columns just do a Select '1'

Secondly why a flat file, how many records in the table?

I'll go with the VB clan.

Use split to get to arrays, insert local recordset and do batch insert to SQL.

How about DTS?