Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 How to generate SQL Scripts using SMO..??

Author  Topic 

newuser001
Starting Member

19 Posts

Posted - 2009-06-08 : 17:29:46
Hey
I have to use SMO to generate scripts,restore database etc..
1.Script login/role-user mappings 2. Script login/object mappings 3. Script T-SQL create for DB

I have a VB script which does the similar thing thats using SQLDMO dll

How can I do it using SMO...??
I have no idea on SMO..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-09 : 14:08:36
http://www.aspfree.com/c/a/MS-SQL-Server/Retrieving-SQL-Server-2005-Database-Info-using-SMO-Scripting-Tables-Views-Stored-Procedures/5/
Go to Top of Page
   

- Advertisement -