Another question though...

What would I then do about preventing people from using Windows Authentication to log in???

Thank you all for the advice. Will look into permissions option...

I am developing an application that is going to be setup on a server that is in a public area, that anyone will have access to. My thinking was that...

Hi!!!

Thanx for the reply...

I have tried that but still getting the same error. The error type mismatch occurs with the parameter @Users_RowID:

"CREATE PROCEDURE for "user_login1" failed because T-SQL and CLR...

Thanx for the reply...

This is what I have now, but it's still giving me the same error message:

Deploy error SQL01268: .Net SqlClient Data Provider: Msg 6580, Level 16, State...