Sample script that displays all of the users in a given SQL Server DB
更新時間:2007年06月16日 00:00:00 作者:
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
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
相關文章
Bootstrap 模態(tài)框多次顯示后臺提交多次BUG的解決方法
本篇文章主要介紹了Bootstrap 模態(tài)框多次顯示后臺提交多次BUG的解決方法,具有一定的參考價值,感興趣的小伙伴們可以參考一下2017-12-12
In Javascript Class, how to call the prototype method.(three
In Javascript Class, how to call the prototype method.(three method)...2007-01-01
JavaScript下通過的XMLHttpRequest發(fā)送請求的代碼
JavaScript下通過的XMLHttpRequest發(fā)送請求的代碼,需要的朋友可以參考下。2011-06-06
js與jQuery實現(xiàn)的用戶注冊協(xié)議倒計時功能實例【三種方法】
這篇文章主要介紹了js與jQuery實現(xiàn)的用戶注冊協(xié)議倒計時功能,結合實例形式分析了三種倒計時功能的相關實現(xiàn)技巧,需要的朋友可以參考下2017-11-11

