>>A database as whole cannot be moved from higher version of SQL Server to lower. It's also a good idea to keep test server at the same version as production.
>
>Thanks
>
>I tried to script but that approach is also not up to date as per the additional clauses supported.
Faced with a similar situation, I converted all the SQL server tables to .dbf's, created a blank database on the target server and did the reverse conversion.
Awkward but that's all I knew how to do.
Maybe there's an SSRS method?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.