sp_validatelogins

From: Alex (alim_at_rogers.com)
Date: 03/29/04


Date: Mon, 29 Mar 2004 14:08:05 -0500

Hi,

I rely on sp_validatelogins to get list of invalid logins on my SQL 2000
SP3a server but sometimes, for some strange reasons, it lists some valid
domain accounts as invalid. When I run the same procedure next day, there is
no invalid user.

Are you aware on any problem with this stored procedure? Do you know any
other method to validate domain logins in SQL Server?

Thanks



Relevant Pages

  • Re: Oracle JDBC error
    ... I know there's no invalid names in the insert because I can insert ... I'm using oracle's ojbdc14 jdbc driver and Java 1.6. ... If so, post the SQL INSERT ... Oracle, when accessed via JDBC and similar libraries, processes the ...
    (comp.databases.oracle.server)
  • RE: [Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not runni
    ... instance is either invalid or not running. ... Produced By Microsoft MimeOLE V6.00.2800.1165 ... I can connect to it using SQL ... | [SQLServer 2000 Driver for JDBC]The requested instance is ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: How do I temporarily limit values in a query field
    ... I am getting an error message: "The expression you entered has a invalid ..or! ... This is the last few lines of the 'old' sql with an attempt to limit the records to values of <500: ... works fine until I try to put limits on it value in the qryClaimDetails query. ...
    (microsoft.public.access.queries)
  • Re: Making dynamic table sortable
    ... The flip side of which results is websites filled with SQL injections ... Which is likely to be invalid SQL. ... error conditions. ... rather than the query ...
    (comp.lang.php)
  • Re: Update DataTable (from csv import) data
    ... AMDRIT wrote: ... invalid dates which won't insert into the SQL table I have. ... If the data is invalid then DBNull the value. ... Actually Date.MinValue is not a value that SQL Server will accept ... ...
    (microsoft.public.dotnet.framework.adonet)