Security for Microsoft® Visual Basic® .NET

Migrating the Employee Database to SQL Server 2000

By default, the Employee management system uses a Microsoft Access 2002 database. The following steps demonstrate how to migrate the EmployeeDatabase.mdb Microsoft Access 2002 database to Microsoft SQL Server 2000. Perform these steps if you would prefer to (or have no choice but to) run the EMS sample application using SQL Server 2000 as the back-end database. In particular, if you would like to run the example presented in Chapter 6, which shows how to call a SQL Server stored procedure named IsValidUser, complete the steps shown in the "Add the IsValidUser stored procedure to the database" section. Finally, you’ll need to update the EMS code, as shown later in this section, to have the EMS ...