Windows Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home Windows Server 2012 Windows Server 2008 R2 Windows Server 2003 Library Forums

TechNet Library

Windows Server 2008 R2 and Windows Server 2008

Browse Windows Server Technologies

Active Directory Services

Active Directory Rights Management Services

Deployment

AD RMS Deployment in a Resource Forest Step-by-Step Guide

Scenario Overview

Prerequisites for AD RMS Deployment in a Resource Forest

Limitations of This Deployment Design

Implementing the Procedures in this Document

Testing the Implementation

Automating the Implementation

Testing the Automation

Appendix A - UserSidTracking database T-SQL

Appeindix B - Users Table T-SQL

Appendix C - Metaverse Extension Code

Appendix D - SQL MA Extension

Appendix E - Automation Application

Appendix F - ADMT Options File

Appendix G - MA GUID Retrieval Script

Appendix H - Pre-Implementation Checklists

Minimize

This topic has not yet been rated - Rate this topic

Appeindix B - Users Table T-SQL

Published: December 23, 2009

Applies To: Windows Server 2008, Windows Server 2008 R2

The following is the T-SQL code for creating the ADMTHelper table.


USE [UserSidTracking]
GO

/****** Object:  Table [dbo].[Users]    Script Date: 07/14/2009 16:34:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Users](
[EmpID] [nchar](10) NULL,
[FirstName] [nchar](10) NULL,
[LastName] [nchar](30) NULL,
[SidHistoryPresent] [char](1) NULL
) ON [PRIMARY]

GO

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.