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