I can think of a couple of reasons where this might be useful.

1. Move to better hardware

2. Replicating the file system to a hot site on an on-going basis

However...

So technically, if I copy all the user databases as well along with the resource db, maintaining all the file locations the same, I could move to a different default...

I would upgrade to SP3 since it includes all hotfixes up to CU 10.

and at the end will sql server, sqlagent,fulltext search will run under

1.the account we choose in Service Account page? OR

2.the account we choose in Domain Groups for clustered services?

or do...

The services will be run by the individual service accounts. However, a domain groups that contains these domain accounts that will run the various services will need to be created...

try qualifying your db name with []...for example [test.db]

What update are you trying to deploy? What version of SQL Server is this?

Do you have multiple instances on the box? If so, are you looking at the registry keys for the right instance?

Not by default. Although, based on your requirements it would be possible to script something to pull this information periodically in a database.

I had the same requirement (and more) and searched but couldn't find anything online. I created a custom solution which would store all post restore tasks in a database table...

I think you will need a linked connection setup

http://www.sqlservercentral.com/Forums/Topic695128-359-1.aspx

This should give you a good starting point

http://cwashington.netreach.net/depo/view.asp?Index=1119

You can load all the databases in a table and have an dbcc'd flag or the date time dbcc completed. You can then have you cursor load the databases using...

I would recommend put together some reports instead (especially for Production) since Access can cause a lot of locking in the database while accessing the data.

Moreover, you don't want...

Thank you Sam...

Here's what the SP3 install readme has to say about SP3 and rebuilding a node. It doesn't talk about removing SP3 from the active node, but says that...