Looks like it will only install on the other named instance. Is there some command promp method to fix just carry it over to the correct named instance?

I rebooted tried again and it asks for the sqlrun_sql.msi. I pointed to the file, but it still complains that it's not a valid installation package.

Thanks, uninstalled it... but I still get the same message:

Details of that message gives more info:

Name: Microsoft SQL Server 2005

Reason: Your upgrade is blocked. For more information about upgrade support,...

Yeah, I have advanced services. I forgot to also mention that when I use "modify" from from the add/remove it will let me select FTS and then named instance,...

Thank you very much, I'll be sure to do that.

Wow, that looks pretty awesome. I'll try that. I guess it's telling me to run sp_addlinkedserver to access to those stored procedures first.

Ok, thanks! That clarifies things for this newbie. I must have been doing something else wrong when I had the temp table.

I'm also getting duplicate results, is this...