用sql-dmo的IntegratedSecurity对象。IntegratedSecurity ObjectThe IntegratedSecurity object exposes configurable parameters that affect all logins to Microsoft® SQL Server™ 2000 regardless of the login authentication type.
PropertiesAuditLevel Property ImpersonateClient Property
DefaultDomain Property SecurityMode Property (DistributionDatabase, IntegratedSecurity)
DefaultLogin Property SetHostName Property
MethodsRefresh Method
Res
SQL Server implements two ways to control access to SQL Server data: Windows Authentication, implementing trusted connections, and SQL Server Authentication.With SQL Server, login record naming is expanded. Properties of the IntegratedSecurity object that provide default domain naming are maintained for compatibility with previous versions of SQL Server and SQL-DMO.
PropertiesAuditLevel Property ImpersonateClient Property
DefaultDomain Property SecurityMode Property (DistributionDatabase, IntegratedSecurity)
DefaultLogin Property SetHostName Property
MethodsRefresh Method
Res
SQL Server implements two ways to control access to SQL Server data: Windows Authentication, implementing trusted connections, and SQL Server Authentication.With SQL Server, login record naming is expanded. Properties of the IntegratedSecurity object that provide default domain naming are maintained for compatibility with previous versions of SQL Server and SQL-DMO.
混合模式(Windows 身份验证和 SQL Server 身份验证)。没有仅sql server身份认证。
再问一句,在SQL中可否做到