SamplescriptthatdisplaysalloftheusersinagivenSQLServerDB_javascript技巧

来源：懂视网责编：小采时间：2020-11-27 20:37:21

SamplescriptthatdisplaysalloftheusersinagivenSQLServerDB_javascript技巧

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) ob

推荐度：

点击下载本文 文档为doc格式

导读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) ob

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

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

SamplescriptthatdisplaysalloftheusersinagivenSQLServerDB_javascript技巧

推荐度：

点击下载本文 文档为doc格式

标签：技巧 all sina

热门焦点

SamplescriptthatdisplaysalloftheusersinagivenSQLServerDB_javascript技巧

SamplescriptthatdisplaysalloftheusersinagivenSQLServerDB_javascript技巧

SamplescriptthatdisplaysalloftheusersinagivenSQLServerDB_javascript技巧

最新推荐

猜你喜欢

热门推荐