I will do the hash compare of user authentication on both sides (Client & Server) whenever the user logs in .

SC

Because i Am syncing the Client from server and sending this password to the the client machine. This garbage data will be very difficult to sync as i am...

can I store this garbage value returned by HASHBYTES() as string using the function sys.fn_varbintohexstr(@hash) ?

Thanks

SC

Can i Store this garbage value returned by HASHBYTES function as String using the function sys.fn_varbintohexstr(@hash)

Thanks

SC

Thanks CEWII for your response.

I have my password field in existing database as varchar(80). I want to join userName + password and use the HASHBYTES function to store it in...

Thanks CEWII.

Is there a way to encrypt the Stored Procedure with Password?

Thanks

Shailesh

Thanks for your reply.

But now my question is "IS there a way to break it" if i encrypt the stored procedure as you suggested.

Thanks

SC

Thanks for your response.

Database is already in production and cannot make any change in column data types.

Thanks

shailesh

Thanks to AJ and Hari narayan. Both queries are working good.

Thanks for your time.

//shailesh