What error are you getting?  Are there referential integrity constraints or update triggers on either of these tables?

Length of the connection or until you explicitly drop it.

Also, if you want to move objects off these excess groups later, here a good article from this site on how to do it efficiently.

http://www.sqlservercentral.com/columnists/cmiller/gettingridofexcessfilesandfilegroups_printversion.asp

I don't know.  I've been at this for 20 years and I still just use 2 fingers.  It seems I can't type any faster than I think.

Here are a couple of links you might check out:

http://www.sql-server-performance.com/filegroups.asp

and

http://www.sql-server-performance.com/ac_filegroup_performance.asp

There probably aren't any large penalties from so many filegroups until you run out of available threads to read...

I have to learn to type faster so I can get there first next time.

If you know the data types of the data being returned from the dynamic sql you can insert the results of the exec in a temp table.  Create the temp table first...

Yes, it sounds like an issue (where 'issue' really means 'bug').  I'm a little surprised this hasn't popped up on the forum before.  Maybe everyone else has a newer CTP...

I actually get an error message back telling me I have to set the compatibility mode down to 8.0 or lower and that I shouldn't use the '*=' or '=*'...

I had the same experience.  A couple of tools I have from 3rd party vendors don't work anymore because they use the *= join syntax.  It looks like the last...

I think you have to use Dynamic sql to do this, building the entire sql statement in a varchar variable and then using EXEC (@variable).

Could you post the text that comes along with the error?  How are you staring the service?

Checking permissions on the account under which SQL Server runs is a good idea. ...

If this question is about capacity, the answer would have to be:  that depends.

The number of concurrent users a server can support at acceptable levels of response depends on hardware,...

an example from 'Books Online':

INSERT author_sales

   SELECT 'SELECT', authors.au_id, authors.au_lname, SUM(titles.price * sales.qty)

   FROM authors INNER JOIN titleauthor

      ON authors.au_id = titleauthor.au_id INNER JOIN titles

      ON titleauthor.title_id =...

Looks like you might be running the tablename and the 'select' together.  Put a space in front ot the word 'select'.