Windows authentication is more secure. We are going to have everyone in the company accessing our data sources so there would be dual maintenance for users. We would...

Thanks for the reply but we are using Windows authentication. It makes more sense to do it this way versus sql logins.

Can I do this with the system databases? Will SQL Server let me detach the master database then attach a different one?

OK, based on what both of you, Steve and Andy, said, I went back and ran some simple queries like you ran and I got the same results you got....

Yes, I have logged in as the SQL Server account and sent mail from there. There is one thing you said that is making me think I may not...

I don't have any real reason for doing this. I am definitely not set on doing this. Are there any benefits to using one over the other?