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

2014-10-21 21:04:13 分类：JavaScript技术阅读()

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

JavaScript技术：Sample script that displays all of the users in a given SQL Server DB，转载需保留来源！

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。

标签：

相关文章阅读