Trying to get an MSDE going with the SQL gui. These are my personal notes.

osql -U sa -S SERVER\INSTANCE
Password: ******

1. Give the group the ability to login to the MSDE Instance

use master
go
EXEC sp_addlogin 'DOMAIN\domainGroup'
go

2. Grant Access to DB (still won't be able to edit tables / data)
use dbname
go
exec sp_grantdbaccess 'DOMAIN\domainGroup
go
Granted database access to 'DOMAIN\domainGroup'

3. Give the group admin access to the db to allow editing etc.
EXEC sp_addrolemember 'db_owner' , 'DOMAIN\domainGroup'
go
'DOMAIN\domainGroup' added to role 'db_owner'.