Here it is.

USE [itiserver]

GO

DECLARE @return_value int

EXEC @return_value = [dbo].[csp_AddDMUser]

...

Yes, I just create a test account and it came back with the same thing.

Below is what I get when I try running it manually.

USE [itiserver]

GO

DECLARE@return_value int

EXEC@return_value = [dbo].[csp_AddDMUser]

@username = N'STATION1'

SELECT'Return Value' = @return_value

GO

Msg 15118, Level 16, State 1, Line 1

Password validation failed. The...

I guess its erroring out in the stored procedure somewhere. I'll have to take a look at it. I know at one point I was able to log into the...

It set for failed logins only. Since that is set, should it show up in the SQL Server Log in SSMS?

OK, this is going to be stupid question, how and where do I check that in SQL 2005? Are you talking about the log file viewer or profiler? Or, are...

I set the check policy to off for the SA account. So, I don't think that's it.

How do I go about finding what the most used indexes are?

My mistake. I meant NDF (secondary database file).

Thanks.

Not the transaction log, the data file. . Right now the data file is roughly 17 GB.

Do you delete the indexes to disable a nonclustered index? Also, do you truncate a table by shrinking the database?

The reason for the request is compare with other rows that there aren't any duplicate images.

It worked. Thanks for your guys help.

How about using BINARY_CHECKSUM?