Interesting. Thanks for testing it...

I only tested against a few rows and noticed that logical I/Os were lower than the other two options. I suspect the performance hit...

My problem with the quirky update solution is the requirement to add a column to the original table, which may not be practical in reality.

I've got an alternative that does...

Redgate SQLCompare. You can download a 14-day trial from their website.

Read this:

http://technet.microsoft.com/en-gb/library/cc966412.aspx

Also discussed here:

http://weblogs.sqlteam.com/tarad/archive/2008/08/05/How-to-get-physical-CPU-count-on-a-server.aspx

I also run predeployment tests with SQLIO, and later tests for comparison are always a good idea. But what if you use a SAN? An hour's downtime would...

Don't drop BUILTIN\Administrators on a clustered instance without explicitly adding the cluster service account first.

Have you looked at sp_MSforeachdb?

2000 version is what I posted above

The message you have listed is not an error. It is the normal informational output from CHECKDB and that is why is suggested specifying WITH NO_INFOMSGS, so you can...

Could you run the DBCC CHECKDB commands WITH NO_INFOMSGS?

It looks like you want to apply each function to every row in PropData.

I guess there is a column in PropData to pass as a parameter??

If you only have a...

Start->Run secpol.msc

Expand Local Policies->User Rights Assignment

Double Click "Lock Pages in Memory" and add your service account in there.

...is not a valid setting.

Use "max server memory"

Why so complicated?

Just use this:

select [db]=name, [model]=databasepropertyex(name, 'Recovery')

from master..sysdatabases

where name not in ('master','model','tempdb','msdb')

order by 2, 1