How can i copy and replace Tables from a source database to another target database.
The issue that i have is that we just started to use reporting services and it points to a database on another server (our reporting server) to distribute reports. In the past we just did a MS SQL database restore to the server and manually ran reports. This solution will not work now because we have created custom stored procedures on the report database and the restore will overwrite the stored procedures
Thank you for all of your help in advance