Stored Procedure in External Database

[bburn78]

Hi

I can't seem to get ACS to communicate with my external Database, MS SQL 2000, though at the config page, it says I have connected successfully. Can anybody enlighten me on how to write a proper stored procedure?

I have a database called Test. and it has a Table called Members, which has 2 columns, memberID & password. I need to authenticate against the users in this table. Can anyboy enlighten me on how to go about doing it?

[beth-martin]

To get a sample of writing a stored procedure you should look at a newsgroup or forum dealing with the MS SQL 2000's such as this one http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20136592.html

[bburn78]

Thank you for your advice