Hello there,

Does anybody knows how to delete a SQL Server 7.0 or MSDE database using VB. Pls show me some codes..

actually i do have d codes but it only works on SQL 2000
heres d code. (pls try to debug what is wrong)


Dim objRoot As Object
Set objRoot = CreateObject("SQLDMO.SQLServer")

objRoot.LoginTimeout = 60
objRoot.Connect "(local)", user, password
Call objRoot.KillDatabase("MyDatabase")

tried it on MSDE and SQL 7.0
it generates an error #2702-database do not exist

Your help is very much appreciated.