Step 3 - Create Users Table
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.
Creating the Users Table
The following steps show how to create the Users table.
To create the Users table
Log on to RES-DC.fabrikam.resource.net as Administrator
Click Start, click All Programs, click Microsoft SQL Server 2008, and click SQL Server Management Studio.
On the Connect to Server dialog box, under Server Type: select Database Engine.
On the Connect to Server dialog box, under Server name: select RES-DC.
On the Connect to Server dialog box, under Authentication: select Windows Authentication.
At the top, click New Query. This will bring up a new query pane in the center of Microsoft SQL Server Management Studio.
Copy the code from Appendix B – Users Table and paste it into the center.
Click Execute! The pane will split and you will see the following message – Command(s) completed successfully.
Close Microsoft SQL Server Management Studio.