SQL Server sample databases were always delivered with the product. Not so in SQL Server 2008. Microsoft decided to de-couple the dependency and have us download the samples for free from codepex.com.

Assigning roles Let’s use SQL Server Enterprise Manager to add a Windows group to a Pubs database (a sample database that comes with SQL Server 2000) role.