Another thing you need to be aware of. SQL Server authentication doesn't provide the same level of UID/PWD encryption as Windows authentication. In other words, Windows Authentication is more secure.
>Thank you very much for clarifying. But I didn't even know you can create a database user before the server login. So I always create server login first and then user in the database.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer