当前位置:编程学习 > JS >>

Sample script that displays all of the users in a given SQL Server DB

答案:Sample script that displays all of the users in a given SQL Server DB.

Supported Platforms

SQL Server 2000
Yes


Script Code

复制代码 代码如下:

strDBServerName = "."
strDBName = "ScriptingGuysTestDB"

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

Set objDB = objSQLServer.Databases(strDBName)
Set colUsers = objDB.Users
For Each objUser In colUsers
WScript.Echo "User: " & objUser.Name
WScript.Echo "Login: " & objUser.Login
Next

上一个:List the Codec Files on a Computer
下一个:Save a File Using a File Save Dialog Box

CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,