Hi Everyone

I know This in not the first time i am asking this but i need some help asap!

Problem 1
---------

I Have a vfp7 application with an Sql Server Database.

On The Sql Server Enterprise Manager i add new logins and then add users to my database.


What i want is to have a login screen(in VFP7) to validate the user name and password as enetered on the SQL Server before a uses starts using my application.

How can i do This?

Does any one have any examples to help me?


Any Help Would Be Appreciated.


Problem 2
---------

Is it possible to 'Copy' users from one Database to another programatically ?



Tnx in Advance
Anthi