欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  web前端

Sample script that displays all of the users in a given SQL Server DB_javascript技巧

程序员文章站 2022-03-21 08:13:50
...
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