Display SQL Server Login Mode
摘要：DisplaySQLServerLoginMode.SupportedPlatformsSQLServer2000YesScriptCode...
DisplaySQLServerLoginMode.
SupportedPlatforms
SQLServer2000
Yes
ScriptCode
SQLDMOSecurity_Integrated=1
SQLDMOSecurity_Mixed=2
SQLDMOSecurity_Normal=0
SQLDMOSecurity_Unknown=9
strDBServerName="."
SetobjSQLServer=CreateObject("SQLDMO.SQLServer")
SelectCaseobjSQLServer.ServerLoginMode(strDBServerName)
CaseSQLDMOSecurity_Integrated
WScript.Echo"LoginMode:AllowWindowsAuthenticationonly."
CaseSQLDMOSecurity_Mixed
WScript.Echo"LoginMode:AllowWindowsAuthenticationorSQLServerAuthentication."
CaseSQLDMOSecurity_Normal
WScript.Echo"LoginMode:AllowSQLServerAuthenticationonly."
CaseSQLDMOSecurity_Unknown
WScript.Echo"LoginMode:Securitytypeunknown."
EndSelect
【Display SQL Server Login Mode】相关文章：