Step 3 - Create Users Table

Published: December 23, 2009

Applies To: Windows Server 2008, Windows Server 2008 R2

In this step we will be creating the Users table in the UserSidTracking database. This table is used to track the users that have had their sIDHistory attribute successfully populated.

The following steps show how to create the Users table.

  1. Log on to RES-DC.fabrikam.resource.net as Administrator

  2. Click Start, click All Programs, click Microsoft SQL Server 2008, and click SQL Server Management Studio.

  3. On the Connect to Server dialog box, under Server Type: select Database Engine.

  4. On the Connect to Server dialog box, under Server name: select RES-DC.

  5. On the Connect to Server dialog box, under Authentication: select Windows Authentication.

  6. Click Connect.

  7. At the top, click New Query. This will bring up a new query pane in the center of Microsoft SQL Server Management Studio.

  8. Copy the code from Appendix B – Users Table and paste it into the center.

  9. Click Execute! The pane will split and you will see the following message – Command(s) completed successfully.

  10. Close Microsoft SQL Server Management Studio.

Community Additions

ADD
Show: