Thanks for your response.

I am creating the tables through Generate Scripts, and I've duplicate the non clustered index as it is in the production server.

Regarding copying the data from Production,...

• This reply was modified 5 years, 1 month ago by  kpwaran.

Hi Lowell,

Thank you so much for your response.

After renaming the server (RPT-SQL-DB-CL to RPT-SQL-DB), @@servername returns RPT-SQL-DB-CL.

As long as the existing connections goes to the new machine we are fine....

Thanks for your suggestion.

If I am correct, I have to create 2 subscriptions for each report?.

If yes, then how to control the email subscription in the event of file share...

I am getting "The destination must be a SQL Server 2005 instance" when I do Copy Database through Copy Database Wizard.(RDP and launched SSMS in the source server)

Source Server: Microsoft...