SQL Passwords

  • Please Show me how to set passwords using SQL Codings(With few samples)

  • Try sp_password

  • Here's a sample of one I use from vb6:

    gsSql = "EXEC sp_password '" + txtPassword.Text + "', '" + txtPWNew.Text + "', '" + txtUser.Text + "'"

    gconGIMS.Execute gsSql

    straight SQL:

    EXEC sp_password 'old-password', 'new-password', 'user'

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply