Part of the extra time is taken by poor indexing of SQL Servers meta data. If you do an existence check on a table in the 1 million database it will...

Creating a new database then creating 200000 objects the transferring teh data will take longer than updating the exsisting.

Does anyone know whether you can force systems tables to always be...

Thanks for your reply, much appreciated. here are the details of teh system data.

sp_spaceused 'sys.sysschobjs'

rows = 2155329

Reserved = 899744 KB

Data = 318088 KB

Index = 574984 KB

UNused = 6672 KB

details...

The product I work on has a set of objects per business entity, Some customers have 200+ business entities. When a customer moves from one version of our product...

thanks for your replies

Can anyone get the exec sp_execute styatement above to give a truncation error?

Many thanks

Thanks for this, but is there any way to force the truncation error to occur?