Sample script that deletes a SQL Server database

(编辑:jimmy 日期: 2024/10/9 浏览:2)

Sample script that deletes a SQL Server database.

Supported Platforms

SQL Server 2000
 Yes


Script Code

复制代码 代码如下:
strDBServerName = "." 
strDBToDelete       = "ScriptingGuysTestDB" 

Set objSQLServer = CreateObject("SQLDMO.SQLServer") 
objSQLServer.LoginSecure = True 
objSQLServer.Connect strDBServerName 

objSQLServer.KillDatabase strDBToDelete