You have a simple mistake in your test:

SELECT key1, key2 FROM #tmp

EXCEPT

SELECT key1, key2 FROM #tmp2

I didn't thoroughly go through your code, but if all you are trying to do...

Okay, the error you are getting is an access denied error:

2009-12-31 12:12:51 - ! [241] Startup error: Unable to initialize error reporting system (reason: 5)

2009-12-31 12:12:52 - ? [098] SQLServerAgent...

No, I don't think a full backup will be any smaller because of backing up the...

To find the actual error for a maintenance plan, you need to look at the history on the maintenance plan instead of looking at the history of the job.

Right-click on...

I believe once you apply SP3 then you will be able to setup and use maintenance plans. It is also available in SP2, but there were a lot of...

Are you restoring the database to an instance of SQL Server on 'ServerB'? Or, are you trying to locate the database on ServerB and have it available from the...

What error are you getting that is preventing sql server from starting?

How did you change the account that SQL Server uses? If you used the services applet, then the required permissions were not assigned.

You need to use SQL Server Configuration...

You need to define what the last 10 is. A table is an unordered set - so, to get a particular order you need to use ORDER BY on...

No, you don't have to shrink. You want to shrink because that...

You are still trying to access nodes specifically - instead of using the virtual address for the resource you are accessing.

Which cluster group hosts the R:\ drive?

Let's say that your...

You best option is to restore from backups and apply all transaction logs up to the point of failure.

You can try to attach the database and let it...

In additiona to what Lowell has shown, there is a parameter available that defines the database to be used for the query: @query_database (I think - look it up to...

Another option is:

PS> Get-ChildItem $path -Recurse | % {$_.GetAccessControl()}

Or, you can use an expression:

PS> Get-ChildItem $path -Recurse | Format-Table FullName, @{Label="Owner";Expression={$_.GetAccessControl().Owner}}

For the owner:

PS> $path = 'T:\MSSQL'

PS> Get-ChildItem $path -Recurse | % {(Get-Acl $_)} | Format-Table

By default, that will get you the Path, Owner and Access. Not sure about...