Database size increasing from query

[sochidog]

Hi there,
I adjusted some queries the other day - now i note that everytime i run it - the database size increases dramatically. Whats going on?

 

[mph1]

....the database size increases dramatically...

Have you tried compacting??
Do you have any pictures because that can bloat a db.
Would also be helpfull to know what kind of adjustments/changes you made to the queries.

An investment in knowledge always pays the best dividends.

by Benjamin Franklin

 

[sochidog]

I've compacted all over the place. Its a real oddity. The only changes that i've made is to expand a query - which should have no impact on the overall size of the database. Yet, everytime i run it - it jumps 500kb. The database has almost doubled in size in a week...

 

[cas20002000]

Please take a look at this:

Microsoft Knowledge Base Article - 165823
ACC: Database Grows Rapidly When You Modify SQL Statements

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q165823

Hope this helps,

Regards,
Carlos.