>
> Dear Professionals
>
> I want to ask one thing like my database recovery model is Simple and I am
> using
>
> Insert into table
> select * from table (3226303 records)
>
> Its filled up the log and my harddisk gone full, can any one let me know
> the
> solution like I don't want Log to be saved.
>
>
>

> You cannot turn off the transaction log completely. However you can try
> inserting into the table using minimally logged operations like BCP,
> Bulk Insert, SELECT INTO etc.
>
> You can use BuldCopy (BCP) which is included within SQL Server.
>
> There are many examples out there and in BOL.
>
>
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>
> "Joh" <joh@mailcity.com> schrieb im Newsbeitrag
> news:OhksrPcSFHA.1348@TK2MSFTNGP15.phx.gbl...
> >
> > Dear Professionals
> >
> > I want to ask one thing like my database recovery model is Simple and I
am
> > using
> >
> > Insert into table
> > select * from table (3226303 records)
> >
> > Its filled up the log and my harddisk gone full, can any one let me know
> > the
> > solution like I don't want Log to be saved.
> >
> >
> >
>
>