Generation Of Script | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Generation Of Script

Hi All I would like to know if there is any way by which I can generate all the sql Scripts in my DataBase to harddisk using VB or VB.Net code?
Sure, you can use SQLDMO and loop through the databases collection calling the Transfer method. Have a look at the SQLDMO section in Building SQL Server applications in BOL HTH Jasper Smith