"When you talk size you do not mean the datafile size?"

- Yes, I do mean the data file size. The size that's allocated when (in Enterprise manager) you right click...

Yep - you're right - ntext is twice the size as text.

However!! If the whole database were text columns, and they were all changed to ntext, then I would expect...

Hi,

The allocated space for the files are as follows;

On the oversized database;

Data file: 1801

Trans log: 3

On the small database;

Data file: 872

Trans log: 4

Thanks,

Ollie.

Hi mia,

Thanks for the response. What you've said would work perfectly.

Unfortunately though, my example was a bit over simplistic.

It’s not possible for me to use a consistent character...

Yeh - these have been a great deal of help. Thanks people.

The complexity is due to the fact that the sql statements that are executed in the stored procedure are...