当前位置:首页 > 数据库 > Sqlserver

SamplescriptthatdisplaysalloftheusersinagivenSQLServerDB_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

【说明】本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:254677821)!

相关教程推荐

其他课程推荐