Installing Database

[abo el ror]

How can I install a Database on the SQL SERVER 2000 programatically using VB.Net code? With Regards Rawad Eid

[Colin Angus Mackay]

abo el ror wrote: How can I install a Database on the SQL SERVER 2000 programatically using VB.Net code? Do you mean how to add a database to the server, or actually install the server itself? If you want to attach a database to the server using VB.NET then you can just create SqlCommand objects and use ExecuteNonQuery to run the appropriate SQL commands at the SQL Server. sp_attach_db[^] is probably the Stored Procedure you need. Remember that your SqlConnection to the database must use a user that is the sysadmin or dbcreator role. Does this help?

---

Do you want to know more? WDevs.com - Member's Software Directories, Blogs, FTP, Mail and Forums

[Javier Lozano]

One thing you could do is use the SQLDMO library to encapsulate the objects in the server as types in your application. ~javier lozano (blog)