How To Get Rid Of Sql Log

Hi,
I have a Data base on Sql Server 2000, sp3a. Database is used to to build summary tables to show reports on web. There are many sub systems, which prepare summarized tables for faster web page serving. Every thing is working fine.

The problem is sql server log gets full. In one given day it could go up to 18 GB. I know, if I back it up it gets truncated. Is there a way, I can stop sql server not to log, as it is not needed?

Can I set up Sql server to automatically truncate it. I do have auto shrink options checked, but log file still keeps growing.

Any idea, what is going on here.
Thanks,
Mashro::Is there a way, I can stop sql server not to log, as it is not needed?

You err, it IS needed.

Read up in the documentation what the log is used for. It is needed.|||Back it up regularly to keep it from growing out of control. You can't eliminate the log. It's a pretty key piece of the puzzle. If you have the db set to simple recovery, it should truncate the log on each checkpoint. Probably no need to use a full recovery model on a 'derived' reporting database like you seem to have.

how to get optimized join

Hi Experts,
I have following doubts on join condition
Table 1 primary key (id,sub)
Name id sub marks

xxx 61 maths 45
xxx 61 science 50

another table primary key ( id,language)

id language write
61 english yes
61 Hindi no
Output:
Xxx 61 maths 45 english yes
Xxx 61 maths 45 Hindi no
Xxx 61 science 50 english yes
Xxx 61 science 50 hindi no
how to join these tables to get
every information in 2 rows will it possible

xxx 61 maths 45 English yes
xxx 61 science 50 hindi no

please suggest me to right path
thanking u
please mail to me:nallisalmon@.yahoo.co.in

I don′t see the logic which one has to be excluded from the output results ? Is it just randomly or is there a deeper logic implemented ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de