g00ner

hi all,

I am trying to setup some stored procedures so that we can use customer tokens in our scripts.

I have created this stored procedure:

CREATE PROCEDURE sp_Password
@usname varchar(20)
AS
SELECT Password
FROM Credentials
WHERE Username = @usname

But if l then execute the following queury

EXECUTE sp_Password 'Nicholas' l get the following error

Msg 201, Level 16, State 4, Procedure sp_password, Line 0

Procedure of function 'sp_password' expects parameter '@new', which was not supplied.

I am an SQL newbie so not sure where to go from here.

TRYDL

You need to change the name of the sproc to something other than sp_Password. sp_Password is an internal stored proceedure for sql account password changing.

sp_password (Transact-SQL)

SQL will reference system functions / sprocs before going to user defined ones. That is why it is prompting you for a variable that is not defined in your script.

You can either MODIFY the sproc or delete/re-create it.

HTH

__________________
3rd Floor Garage Door Operator

g00ner

Thanks for that. All working know and can parse custom tokens to my script.

My next task is to now either encrypt the column in the d/b or encrypt the whole database. The d/b as you can probably tell will be a list of usernames and passwords. Just been looking at some examples and am getting completly lost in sql code.