All

I'm a bit new with using SQL Server and creating applications. I'm trying to figure out what would be the best method for security. Would it be better to have a table with everyone's IDs and passwords and verify it that way? Or would it be better to be associated with the application only?

Does anyone have any recommendations/suggestions?

Thanks ahead of time!

Nicky