Sample Database Diagram - SQL Server 7.0 Here is a sample E-commerce application database structure. For a relational database to work properly you should have a field in each database that uniquely ...

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.