Hi Susan
Please take a read of my articles at:
http://www.sqlservercentral.com/columnists/ckempster/
There are three covering security issues in general on SQL Server. Give the
site a further check for other articles though, its a big topic.
Cheers
Ck
MS Sql Server LazyDBA home page