Nice code! I have a very large SP and don't wont to make it a dynamic sql though. Maybe I could run the 1st SP and insert it into a...

Excellent! Thank you everyone...

Currently the database contains '&' in the company name and displays as '&' in SQL Report Builder 3.0.

I can use a simple query and the '&' displays correctly: (Select location_name...

That's exactly what I did after creating the tables on the remote.

Thanks for all your help.

Probably the best advice I've received: "Script Table as SELECT to..."

The script shows the proper syntax:

[SVR1\SQLEXPRESS].[aspnetdb].[dbo].[aspnet_Applications]

Also discovered new error trying to run my 'Select Into' statement...