Yeah It does the job but I would like to have that process automatic to avoid someone forgetting doing it.

If it can be automated it will be less prone to...

Looks for the SKUUPGRADE option for the command line setup of SQL Server. You will be able to change the edition. You will need to reinstall all patchs though. Be...

I had the same issue as posted.

This is related to a faulty backup.

I tested it again a good one versus a corrupted copy. Both were check each time with a...

Great lmu92! Thank you!

It does work exactly how I wanted too!

Now I'll be able to benchmark it!

I've found and remember that WITH NO_INFOMSGS suppress information but it is used mostly with DBCC statements and does not apply to reconfigure.

Are you able to tell me the command name? I'm googling and still find nothing, so I presume I'm not looking for the good keywords.

I thought so that something like no error msgs existed but I didn't find it hence the post!

I'll take a look again.

I'll second Wayne. Your scenario need a processor license definitely. Even though it seems that only one connection type is being used, it's the amount of end-user / device connected...

Thanks Carl Federl !

The provided scripts clearly shows what I wanted to test out.

Thank you Carl Federl That's exactly what I wanted to know!

As soon as I can get my hand on a SQL box I'll test your scripts, curiosity simply.

Ok but the question still remain.

Does the sampling before rebuilding is done only for the column(s) used by the index which will be rebuilt or all columns used by all...

Let say we have the following case:

Rebuilding indexes are done on a case by case. (no ALL keyword)

The table contain the following indexes:

Clustered on col z

Non clustered 1 using col...

Hummm the utility from the link provided seems very interesting instead of developing one from scratch.

Thks!

Thanks Luke

We already use the rs.exe utility and we've come upon a case where it could be interesting to publish report from t-sql without using rs.exe.

I'm not very fond of...

Yes it was in the limited mode. Didn't knew that, now I do.

Thank you