SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server.
We can integrate SMO into any .NET based applications.
SMO is also compatible with SQL Server version 7.0, SQL Server 2000, and SQL Server 2005, which makes it easy to manage a multi-version environment.
Following code is used to run the Microsoft SQL Server Query files(script files) kept in
applications bin\Debug folder, with SMO.SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server.
http://www.mindfiresolutions.com/Run-the-existing-SQL-Script-programmatically-with-SMO-526.php[
^]
I am in the marketing team at Mindfire Solution.It is an offshore-software development company based in India.It is apple premier and microsoft gold certified partner.it is as ISO 9001:2000 certified company.It specializes in coldfusion, python,PHP,sharepoint, iphone,java,servoy,mysql, database and other such related technologies.I am very keen in learning and sharing technology.