I have used DMO and T-SQL to backup my database objects only in SQL server 2005 working fine. I know DMO script would not work in SQL server 2008 R2. Do you have any equivalent script in SQL server 2008 R2. Can we achieve the same using SMOs
in SQL server 2008 R2.
If you want I can post the working 2005 SQL script.
Appreciate your help .
View Complete Post