Login data information request.
I don't actually want to logon, I just want to use the logon/passwords just to
validate whether a person is part of our company and I don't want to set up a
new table with another set of logon/passwords. I would rather use the ones we
already have in our system. If someone from the outside logs on they can
either get the administration page or the client page. If they are not in our
system, they would go directly to the client page.
I can't use sp_who, as the person my not be logged on the system.
Thanks,
Tom
Quote:
> If you select from master..sysprocesses or use exec sp_who, you will get a
> list of users logged into SQL Server.
> I am not sure what you mean about sending a login name and pwd to SQL
> Server. This is how you log into the server. Without this, you cannot issue
> a query against the server. If you want to know if a name/pwd combo is
> valid, try to log in. The front end can detect if this is sucessful or not.
> > How do you check user name and password from SQL?
> > I want to be able to check if some that logged onto my website is from
> > our company. Everyone has a login name and password defined in our
> > system. I would like to send the login name and password to SQL and
> > have it just tell me if it is valid or not. Is this possible? Stored
> > Procedure maybe? I can't seem to find any in my SQL books.
> > Thanks,
> > Tom.
