Apart from individual DDL and test data, your logic seems incomplete. I would revisit this and better explain what the process is for computation.

You can use CASE for some of...

There's no GUI support right now.

Make sure you've created the filestream filegroup first, then you can set this in the T-SQL for the table.

For subscribers, MSubscriber_Info seems to be what you want: http://msdn.microsoft.com/en-us/library/ms179868.aspx

No idea on the distributor.

SQL Server instances take the name of the windows host. That could be a real host, or the Windows cluster.

A 2 node cluster has 3 names. SQL Server responds to...

If the data and logs aren't separated physically, then you could have an issue. I haven't worked with virtual drives. Typically you would have two arrays from one controller (or...

Confused. Why do you not insert the values into TableB first?

Developer Edition has all the Enterprise features. Use that on workstations.

I believe the EULA prohibits running a production system on Developer, so please don't plan on that. If you have...

Make sure you have backups, test lots as Grant noted (run your application against an upgraded database ), and follow the Upgrade Advisor.

I'd agree with Lowell. There isn't a way to do this on a field, you'd have to build a UDF or code that would check to see if the next...

It's possible there is a delay in the space getting released from inside the table. Is this table the size of your tempdb database?

Tempdb needs what it needs. Any...

How would you not be able to access the cluster? If you're setting it up, then you pick a non-used name for the cluster. Not an existing Windows host.

For the...

You could join with the information_schema.columns to get those names, but it might be easier to do it manually if you know the columns and are writing the code:

select name...

Dont' forget heartbeats, which you usually want on a separate network.

We have a three part series on building a 2 node cluster that should help you: http://www.sqlservercentral.com/articles/Clustering/73994/

You haven't explained what you issue is, nor what the conditions mean for the logic. You need to stop and go over the functionality you need, build an algorithm in...

Did you upgrade to R2? are you sure the TF is still enabled?