Hello:

I'm using SQLServer 6.5 sp3. Right now I need to increase the size of tempdb but I dont know
how.
By default this db is localized in the master db with 2Mb, but I want to resize the tempdb with
300Mb of data and 200Mb of log, this 'cause somebody says that his application needs that
size in tempdb.

How can I expand my tempdb without all the expansion goes to the logs, I mention this 'cause
each time I expand tempdb all the increase goes to log part and the data remains with 2Mb.
Is correct to have this sizes(300Mb data- 200Mb log) ?

Thanks