Andrew,
I cant change this because I am not the owner of the db. All I can do is
read and write to tables, but cant change settings.
I did not write the SP and I have never seen an Insert done this way. I
would have done a tradicional Insert into table Select bla bla bla
If I change the SP would it have any impact?

George.


"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:uNvkXW94GHA.3376@TK2MSFTNGP05.phx.gbl...
> Those are recovery modes for the database and affect the amount of logging
> for operations such as a Select Into. I recommend you change the recovery
> mode to Simple when you do this operation. Just make sure you do a valid
> FULL backup after if everything went correctly. You can find more info in
> BooksOnLine. The log file can't grow fast enough to meet the needs of
> your operations so you should either leave it that large, change the
> recovery mode or change the default autogrow size to a fixed amount that
> can be achieved in 10 seconds or less.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Microsoft" <g2@bla.cl> wrote in message
> news:Op4dvL84GHA.2264@TK2MSFTNGP02.phx.gbl...
>> Its a User Database.
>> I left this and a few other queries ruuning last night and I got this
>> error
>> The transaction log for database 'mydb_Temp90' is full. To find out why
>> space in the log cannot be reused, see the log_reuse_wait_desc column in
>> sys.databases
>> Yes, Its doing the
>> Select xxx xxxx
>> into
>> table
>> From
>> bla bla bla
>>
>> I am not familiar with the Bulk logged or simple mode.
>>
>> Thanks.
>>
>>
>>
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
>> news:%23bMScB84GHA.4256@TK2MSFTNGP03.phx.gbl...
>>> Is tempdb the one growing or the user database? Is it the data file or
>>> the log file? You show that you are doing an select into
>>>> into
>>>> ETL_TBL_Charge
>>>
>>> Is this true or was the code simplified and you are really doing an
>>> Insert Into instead? If it is a Select Into have you tried settign the
>>> recovery mode to Bulk logged or Simple mode?
>>>
>>> --
>>> Andrew J. Kelly SQL MVP
>>>
>>
>>
>
>