Not really what I'm after, but this sort of thing is a quick way

(255 is an arbitrary value):

DECLARE @cnt INT = 32;

DECLARE @sql nvarchar(max) = ''

WHILE @cnt <...

I suppose if you change model it's potentially affecting databases on the server that aren't yours.

I like the idea of having the customer sign off a checklist to confirm it's...

As well as the performance is that fact that when a 3rd party or the customer themselves is running the trace this can go wrong.

Often we'll get a trace back...

Are the scripts created with SQL Server Profile 2012 backward compatible?

I.e. can we create them on our 2012 and run them on a customer on 2008 R2 or maybe even...

Thanks.

The idea of a utility to check the database has come up here, but has always been put off.

I think we'll have to look at that again.

There probably is something...