|
 |
Joined: 1/19/2012
Posts: 109
|
|
|
Hi,
I have downloaded the AuthXP package and have tried to install it via Extensions/Manage/InstallExtensionWizard.
I get the following
| StartJob |
Starting Installation |
| Info |
Starting Installation - ICPC-TE-AuthXP |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Creating backup of previous version - Providers\DataProviders\SqlDataProvider\11.04.01.SqlDataProvider |
| Info |
Created - Providers\DataProviders\SqlDataProvider\11.04.01.SqlDataProvider |
| Info |
Executing 11.04.01.SqlDataProvider |
| Info |
Start Sql execution: 11.04.01.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'pTE_AuthXP_WSAuthenReturnToken'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: StoredProcedure dbo.dnn_[pTE_AuthXP_WSAuthenReturnToken] Script Date: 12/21/2011 13:42:37 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[pTE_AuthXP_WSAuthenReturnToken]') AND type in (N'P', N'PC')) DROP PROCEDURE dbo.dnn_[pTE_AuthXP_WSAuthenReturnToken] System.Data.SqlClient.SqlException: Incorrect syntax near 'pTE_AuthXP_WSTokenInfoDel'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: StoredProcedure dbo.dnn_[pTE_AuthXP_WSTokenInfoDel] Script Date: 12/21/2011 13:42:37 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[pTE_AuthXP_WSTokenInfoDel]') AND type in (N'P', N'PC')) DROP PROCEDURE dbo.dnn_[pTE_AuthXP_WSTokenInfoDel] System.Data.SqlClient.SqlException: Incorrect syntax near 'pTE_AuthXP_WSTokenInfoGet'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: StoredProcedure dbo.dnn_[pTE_AuthXP_WSTokenInfoGet] Script Date: 12/21/2011 13:42:37 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[pTE_AuthXP_WSTokenInfoGet]') AND type in (N'P', N'PC')) DROP PROCEDURE dbo.dnn_[pTE_AuthXP_WSTokenInfoGet] System.Data.SqlClient.SqlException: Incorrect syntax near 'TE_AuthXP_WSAuthToken'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: Table dbo.dnn_[TE_AuthXP_WSAuthToken] Script Date: 12/21/2011 13:42:40 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_TE_AuthXP_WSAuthToken_AuthToken]') AND type = 'D') BEGIN ALTER TABLE dbo.dnn_[TE_AuthXP_WSAuthToken] DROP CONSTRAINT [DF_TE_AuthXP_WSAuthToken_AuthToken] END System.Data.SqlClient.SqlException: Incorrect syntax near 'TE_AuthXP_WSAuthToken'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_TE_AuthXP_WSAuthToken_DateCreated]') AND type = 'D') BEGIN ALTER TABLE dbo.dnn_[TE_AuthXP_WSAuthToken] DROP CONSTRAINT [DF_TE_AuthXP_WSAuthToken_DateCreated] END System.Data.SqlClient.SqlException: Incorrect syntax near 'TE_AuthXP_WSAuthToken'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[TE_AuthXP_WSAuthToken]') AND type in (N'U')) DROP TABLE dbo.dnn_[TE_AuthXP_WSAuthToken] System.Data.SqlClient.SqlException: Incorrect syntax near 'TE_AuthXP_SSO_User'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: Table dbo.dnn_[TE_AuthXP_SSO_User] Script Date: 12/21/2011 13:42:40 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_TE_AuthXP_SSO_User_Approved]') AND type = 'D') BEGIN ALTER TABLE dbo.dnn_[TE_AuthXP_SSO_User] DROP CONSTRAINT [DF_TE_AuthXP_SSO_User_Approved] END System.Data.SqlClient.SqlException: Incorrect syntax near 'TE_AuthXP_SSO_User'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[TE_AuthXP_SSO_User]') AND type in (N'U')) DROP TABLE dbo.dnn_[TE_AuthXP_SSO_User] System.Data.SqlClient.SqlException: Incorrect syntax near 'TE_AuthXP_WSAuthTokenLog'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: Table dbo.dnn_[TE_AuthXP_WSAuthTokenLog] Script Date: 12/21/2011 13:42:40 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_TE_AuthXP_WSAuthTokenLog_ActionDate]') AND type = 'D') BEGIN ALTER TABLE dbo.dnn_[TE_AuthXP_WSAuthTokenLog] DROP CONSTRAINT [DF_TE_AuthXP_WSAuthTokenLog_ActionDate] END System.Data.SqlClient.SqlException: Incorrect syntax near 'TE_AuthXP_WSAuthTokenLog'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[TE_AuthXP_WSAuthTokenLog]') AND type in (N'U')) DROP TABLE dbo.dnn_[TE_AuthXP_WSAuthTokenLog] System.Data.SqlClient.SqlException: Incorrect syntax near 'TE_AuthXP_WSAuthTokenLog'. Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[TE_AuthXP_WSAuthTokenLog]') AND type in (N'U')) BEGIN CREATE TABLE dbo.dnn_[TE_AuthXP_WSAuthTokenLog]( [AppKey] [uniqueidentifier] NULL, [AuthToken] [uniqueidentifier] NULL, [DateCreated] [datetime] NULL, [Username] [nvarchar](150) NULL, [RecordID] [int] IDENTITY(1,1) NOT NULL, [Action] [nvarchar](2) NULL, [ActionDate] [datetime] NULL CONSTRAINT [DF_TE_AuthXP_WSAuthTokenLog_ActionDate] DEFAULT (getdate()), CONSTRAINT [PK_TE_AuthXP_WSAuthTokenLog] PRIMARY KEY CLUSTERED ( [RecordID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END System.Data.SqlClient.SqlException: Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[TE_AuthXP_SSO_User]') AND type in (N'U')) BEGIN CREATE TABLE dbo.dnn_[TE_AuthXP_SSO_User]( [UserName] [nvarchar](256) NOT NULL, [RoleName] [nvarchar](50) NOT NULL, [Password] [nvarchar](50) NOT NULL, [Email] [nvarchar](50) NOT NULL, [LastName] [nvarchar](50) NOT NULL, [FirstName] [nvarchar](50) NOT NULL, [Unit] [nvarchar](60) NULL, [Street] [nvarchar](60) NULL, [City] [nvarchar](30) NULL, [Region] [nvarchar](50) NULL, [PostalCode] [nvarchar](15) NULL, [Country] [nvarchar](3) NULL, [Telephone] [nvarchar](50) NULL, [Cell] [int] NULL, [Fax] [int] NULL, [Website] [int] NULL, [IM] [int] NULL, [Approved] [bit] NULL CONSTRAINT [DF_TE_AuthXP_SSO_User_Approved] DEFAULT ((1)), [DisplayName] [int] NULL, [RecID] [int] IDENTITY(1,1) NOT NULL, CONSTRAINT [PK_TE_AuthXP_SSO_User] PRIMARY KEY CLUSTERED ( [UserName] ASC, [RoleName] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END System.Data.SqlClient.SqlException: Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. Incorrect syntax near 'TE_AuthXP_SSO_User'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) SET IDENTITY_INSERT dbo.dnn_[TE_AuthXP_SSO_User] ON INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'alan0', N'Production Control', N'470689086', N'alan0@adventure-works.com', N'Brewer', N'Alan', NULL, N'25 95th Ave NE', N'Kenmore', N'WA', N'98028', N'US', N'438-555-0172', NULL, NULL, NULL, NULL, 1, NULL, 1) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'alejandro0', N'Production', N'761597760', N'alejandro0@adventure-works.com', N'McGuel', N'Alejandro', NULL, N'7127 Los Gatos Court', N'Seattle', N'WA', N'98104', N'US', N'668-555-0130', NULL, NULL, NULL, NULL, 1, NULL, 2) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'alex0', N'Production', N'377784364', N'alex0@adventure-works.com', N'Nayberg', N'Alex', NULL, N'1400 Gate Drive', N'Newport Hills', N'WA', N'98006', N'US', N'819-555-0198', NULL, NULL, NULL, NULL, 1, NULL, 3) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'alice0', N'Production', N'113695504', N'alice0@adventure-works.com', N'Ciccu', N'Alice', NULL, N'3280 Pheasant Circle', N'Snohomish', N'WA', N'98296', N'US', N'333-555-0173', NULL, NULL, NULL, NULL, 1, NULL, 4) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'amy0', N'Sales', N'982310417', N'amy0@adventure-works.com', N'Alberts', N'Amy', NULL, N'5009 Orange Street', N'Renton', N'WA', N'98055', N'US', N'775-555-0164', NULL, NULL, NULL, NULL, 1, NULL, 5) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'andreas0', N'Quality Assurance', N'131471224', N'andreas0@adventure-works.com', N'Berglund', N'Andreas', NULL, N'1803 Olive Hill', N'Renton', N'WA', N'98055', N'US', N'181-555-0124', NULL, NULL, NULL, NULL, 1, NULL, 6) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'andrew0', N'Production', N'33237992', N'andrew0@adventure-works.com', N'Hill', N'Andrew', NULL, N'6629 Polson Circle', N'Everett', N'WA', N'98201', N'US', N'908-555-0159', NULL, NULL, NULL, NULL, 1, NULL, 7) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'andrew1', N'Production', N'65848458', N'andrew1@adventure-works.com', N'Cencini', N'Andrew', NULL, N'4444 Pepper Way', N'Sammamish', N'WA', N'98074', N'US', N'207-555-0192', NULL, NULL, NULL, NULL, 1, NULL, 8) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'andy0', N'Production', N'764853868', N'andy0@adventure-works.com', N'Ruth', N'Andy', NULL, N'4777 Rockne Drive', N'Bellevue', N'WA', N'98004', N'US', N'118-555-0110', NULL, NULL, NULL, NULL, 1, NULL, 9) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'angela0', N'Production', N'563680513', N'angela0@adventure-works.com', N'Barbariol', N'Angela', NULL, N'2687 Ridge Road', N'Edmonds', N'WA', N'98020', N'US', N'150-555-0194', NULL, NULL, NULL, NULL, 1, NULL, 10) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'anibal0', N'Production', N'63761469', N'anibal0@adventure-works.com', N'Sousa', N'Anibal', NULL, N'6891 Ham Drive', N'Redmond', N'WA', N'98052', N'US', N'106-555-0120', NULL, NULL, NULL, NULL, 1, NULL, 11) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'annette0', N'Purchasing', N'437296311', N'annette0@adventure-works.com', N'Hill', N'Annette', NULL, N'6369 Ellis Street', N'Redmond', N'WA', N'98052', N'US', N'125-555-0196', NULL, NULL, NULL, NULL, 1, NULL, 12) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'annik0', N'Production', N'801758002', N'annik0@adventure-works.com', N'Stahl', N'Annik', NULL, N'7842 Ygnacio Valley Road', N'Seattle', N'WA', N'98104', N'US', N'499-555-0125', NULL, NULL, NULL, NULL, 1, NULL, 13) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'arvind0', N'Purchasing', N'792847334', N'arvind0@adventure-works.com', N'Rao', N'Arvind', NULL, N'9495 Limewood Place', N'Renton', N'WA', N'98055', N'US', N'848-555-0163', NULL, NULL, NULL, NULL, 1, NULL, 14) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ascott0', N'Production Control', N'685233686', N'ascott0@adventure-works.com', N'Wright', N'A. Scott', NULL, N'9297 Kenston Dr.', N'Newport Hills', N'WA', N'98006', N'US', N'992-555-0194', NULL, NULL, NULL, NULL, 1, NULL, 15) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ashvini0', N'Information Services', N'749389530', N'ashvini0@adventure-works.com', N'Sharma', N'Ashvini', NULL, N'6580 Poor Ridge Court', N'Issaquah', N'WA', N'98027', N'US', N'656-555-0119', NULL, NULL, NULL, NULL, 1, NULL, 16) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'barbara0', N'Production', N'969985265', N'barbara0@adventure-works.com', N'Decker', N'Barbara', NULL, N'7145 Matchstick Drive', N'Sammamish', N'WA', N'98074', N'US', N'119-555-0192', NULL, NULL, NULL, NULL, 1, NULL, 17) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'barbara1', N'Finance', N'363910111', N'barbara1@adventure-works.com', N'Moreland', N'Barbara', NULL, N'137 Mazatlan', N'Seattle', N'WA', N'98104', N'US', N'822-555-0145', NULL, NULL, NULL, NULL, 1, NULL, 18) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'baris0', N'Production', N'273260055', N'baris0@adventure-works.com', N'Cetinok', N'Baris', NULL, N'426 San Rafael', N'Seattle', N'WA', N'98104', N'US', N'164-555-0114', NULL, NULL, NULL, NULL, 1, NULL, 19) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'barry0', N'Production', N'912265825', N'barry0@adventure-works.com', N'Johnson', N'Barry', NULL, N'3114 Notre Dame Ave.', N'Snohomish', N'WA', N'98296', N'US', N'206-555-0180', NULL, NULL, NULL, NULL, 1, NULL, 20) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'belinda0', N'Production', N'20244403', N'belinda0@adventure-works.com', N'Newman', N'Belinda', NULL, N'1399 Firestone Drive', N'Bothell', N'WA', N'98011', N'US', N'319-555-0126', NULL, NULL, NULL, NULL, 1, NULL, 21) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ben0', N'Purchasing', N'20269531', N'ben0@adventure-works.com', N'Miller', N'Ben', NULL, N'101 Candy Rd.', N'Redmond', N'WA', N'98052', N'US', N'151-555-0113', NULL, NULL, NULL, NULL, 1, NULL, 22) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'benjamin0', N'Production', N'585408256', N'benjamin0@adventure-works.com', N'Martin', N'Benjamin', NULL, N'4231 Spar Court', N'Snohomish', N'WA', N'98296', N'US', N'533-555-0111', NULL, NULL, NULL, NULL, 1, NULL, 23) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'betsy0', N'Production', N'294148271', N'betsy0@adventure-works.com', N'Stadick', N'Betsy', NULL, N'5672 Hale Dr.', N'Bothell', N'WA', N'98011', N'US', N'405-555-0171', NULL, NULL, NULL, NULL, 1, NULL, 24) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'bjorn0', N'Production', N'420023788', N'bjorn0@adventure-works.com', N'Rettig', N'Bjorn', NULL, N'5802 Ampersand Drive', N'Seattle', N'WA', N'98104', N'US', N'199-555-0117', NULL, NULL, NULL, NULL, 1, NULL, 25) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'bob0', N'Production', N'843479922', N'bob0@adventure-works.com', N'Hohman', N'Bob', NULL, N'6387 Scenic Avenue', N'Bothell', N'WA', N'98011', N'US', N'611-555-0116', NULL, NULL, NULL, NULL, 1, NULL, 26) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'bonnie0', N'Production', N'109272464', N'bonnie0@adventure-works.com', N'Kearney', N'Bonnie', NULL, N'4852 Chaparral Court', N'Snohomish', N'WA', N'98296', N'US', N'264-555-0150', NULL, NULL, NULL, NULL, 1, NULL, 27) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'brandon0', N'Production', N'999440576', N'brandon0@adventure-works.com', N'Heidepriem', N'Brandon', NULL, N'8000 Crane Court', N'Redmond', N'WA', N'98052', N'US', N'429-555-0137', NULL, NULL, NULL, NULL, 1, NULL, 28) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'brenda0', N'Production', N'634335025', N'brenda0@adventure-works.com', N'Diaz', N'Brenda', NULL, N'1349 Steven Way', N'Seattle', N'WA', N'98104', N'US', N'142-555-0139', NULL, NULL, NULL, NULL, 1, NULL, 29) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'brian0', N'Production', N'746201340', N'brian0@adventure-works.com', N'Lloyd', N'Brian', NULL, N'7230 Vine Maple Street', N'Snohomish', N'WA', N'98296', N'US', N'110-555-0182', NULL, NULL, NULL, NULL, 1, NULL, 30) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'brian1', N'Production Control', N'368691270', N'brian1@adventure-works.com', N'LaMee', N'Brian', NULL, N'2294 West 39th St.', N'Everett', N'WA', N'98201', N'US', N'313-555-0196', NULL, NULL, NULL, NULL, 1, NULL, 31) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'brian2', N'Production', N'1662732', N'brian2@adventure-works.com', N'Goldstein', N'Brian', NULL, N'8157 W. Book', N'Bothell', N'WA', N'98011', N'US', N'730-555-0117', NULL, NULL, NULL, NULL, 1, NULL, 32) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'brian3', N'Sales', N'112432117', N'brian3@adventure-works.com', N'Welcker', N'Brian', NULL, N'7772 Golden Meadow', N'Issaquah', N'WA', N'98027', N'US', N'716-555-0127', NULL, NULL, NULL, NULL, 1, NULL, 33) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'britta0', N'Production', N'410742000', N'britta0@adventure-works.com', N'Simon', N'Britta', NULL, N'2046 Las Palmas', N'Edmonds', N'WA', N'98020', N'US', N'955-555-0169', NULL, NULL, NULL, NULL, 1, NULL, 34) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'bryan0', N'Production', N'458159238', N'bryan0@adventure-works.com', N'Baker', N'Bryan', NULL, N'2275 Valley Blvd.', N'Monroe', N'WA', N'98272', N'US', N'712-555-0113', NULL, NULL, NULL, NULL, 1, NULL, 35) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'bryan1', N'Finance', N'931190412', N'bryan1@adventure-works.com', N'Walton', N'Bryan', NULL, N'1397 Paradise Ct.', N'Newport Hills', N'WA', N'98006', N'US', N'935-555-0199', NULL, NULL, NULL, NULL, 1, NULL, 36) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'candy0', N'Finance', N'60517918', N'candy0@adventure-works.com', N'Spoon', N'Candy', NULL, N'310 Winter Lane', N'Index', N'WA', N'98256', N'US', N'920-555-0177', NULL, NULL, NULL, NULL, 1, NULL, 37) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'carol0', N'Production', N'227319668', N'carol0@adventure-works.com', N'Philips', N'Carol', NULL, N'6872 Thornwood Dr.', N'Bothell', N'WA', N'98011', N'US', N'609-555-0153', NULL, NULL, NULL, NULL, 1, NULL, 38) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'carole0', N'Production', N'138280935', N'carole0@adventure-works.com', N'Poland', N'Carole', NULL, N'8411 Mt. Orange Place', N'Edmonds', N'WA', N'98020', N'US', N'688-555-0192', NULL, NULL, NULL, NULL, 1, NULL, 39) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'chad0', N'Production', N'599942664', N'chad0@adventure-works.com', N'Niswonger', N'Chad', NULL, N'5747 Shirley Drive', N'Bothell', N'WA', N'98011', N'US', N'559-555-0175', NULL, NULL, NULL, NULL, 1, NULL, 40) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'charles0', N'Production', N'537092325', N'charles0@adventure-works.com', N'Fitzgerald', N'Charles', NULL, N'5263 Etcheverry Dr', N'Sammamish', N'WA', N'98074', N'US', N'931-555-0118', NULL, NULL, NULL, NULL, 1, NULL, 41) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'chris0', N'Production', N'539490372', N'chris0@adventure-works.com', N'Preston', N'Chris', NULL, N'6657 Sand Pointe Lane', N'Seattle', N'WA', N'98104', N'US', N'200-555-0112', NULL, NULL, NULL, NULL, 1, NULL, 42) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'chris1', N'Document Control', N'260805477', N'chris1@adventure-works.com', N'Norred', N'Chris', NULL, N'989 Crown Ct', N'Issaquah', N'WA', N'98027', N'US', N'575-555-0126', NULL, NULL, NULL, NULL, 1, NULL, 43) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'chris2', N'Production', N'442121106', N'chris2@adventure-works.com', N'Okelberry', N'Chris', NULL, N'8467 Clifford Court', N'Redmond', N'WA', N'98052', N'US', N'315-555-0144', NULL, NULL, NULL, NULL, 1, NULL, 44) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'christian0', N'Facilities and Maintenance', N'553069203', N'christian0@adventure-works.com', N'Kleinerman', N'Christian', NULL, N'8036 Summit View Dr.', N'Gold Bar', N'WA', N'98251', N'US', N'846-555-0157', NULL, NULL, NULL, NULL, 1, NULL, 45) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'christopher0', N'Production', N'393421437', N'christopher0@adventure-works.com', N'Hill', N'Christopher', NULL, N'1902 Santa Cruz', N'Bothell', N'WA', N'98011', N'US', N'153-555-0166', NULL, NULL, NULL, NULL, 1, NULL, 46) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'cristian0', N'Production', N'7201901', N'cristian0@adventure-works.com', N'Petculescu', N'Cristian', NULL, N'7166 Brock Lane', N'Seattle', N'WA', N'98104', N'US', N'434-555-0133', NULL, NULL, NULL, NULL, 1, NULL, 47) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'cynthia0', N'Production', N'386315192', N'cynthia0@adventure-works.com', N'Randall', N'Cynthia', NULL, N'463 H Stagecoach Rd.', N'Kenmore', N'WA', N'98028', N'US', N'352-555-0138', NULL, NULL, NULL, NULL, 1, NULL, 48) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'dan0', N'Information Services', N'671089628', N'dan0@adventure-works.com', N'Bacon', N'Dan', NULL, N'1921 Ranch Road', N'Issaquah', N'WA', N'98027', N'US', N'166-555-0159', NULL, NULL, NULL, NULL, 1, NULL, 49) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'dan1', N'Information Services', N'929666391', N'dan1@adventure-works.com', N'Wilson', N'Dan', NULL, N'5863 Sierra', N'Bellevue', N'WA', N'98004', N'US', N'653-555-0144', NULL, NULL, NULL, NULL, 1, NULL, 50) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'danielle0', N'Production', N'82638150', N'danielle0@adventure-works.com', N'Tiedt', N'Danielle', NULL, N'5203 Virginia Lane', N'Kenmore', N'WA', N'98028', N'US', N'500-555-0172', NULL, NULL, NULL, NULL, 1, NULL, 51) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'david0', N'Marketing', N'24756624', N'david0@adventure-works.com', N'Bradley', N'David', NULL, N'3768 Door Way', N'Redmond', N'WA', N'98052', N'US', N'913-555-0172', NULL, NULL, NULL, NULL, 1, NULL, 52) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'david0', N'Purchasing', N'24756624', N'david0@adventure-works.com', N'Bradley', N'David', NULL, N'3768 Door Way', N'Redmond', N'WA', N'98052', N'US', N'913-555-0172', NULL, NULL, NULL, NULL, 1, NULL, 53) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'david1', N'Production', N'498138869', N'david1@adventure-works.com', N'Johnson', N'David', NULL, N'6697 Ridge Park Drive', N'Kenmore', N'WA', N'98028', N'US', N'166-555-0162', NULL, NULL, NULL, NULL, 1, NULL, 54) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'david2', N'Production', N'36151748', N'david2@adventure-works.com', N'Ortiz', N'David', NULL, N'931 Corte De Luna', N'Seattle', N'WA', N'98104', N'US', N'712-555-0119', NULL, NULL, NULL, NULL, 1, NULL, 55) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'david3', N'Production', N'746373306', N'david3@adventure-works.com', N'Yalovsky', N'David', NULL, N'5025 Holiday Hills', N'Seattle', N'WA', N'98104', N'US', N'373-555-0142', NULL, NULL, NULL, NULL, 1, NULL, 56) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'david4', N'Production', N'750905084', N'david4@adventure-works.com', N'Hamilton', N'David', NULL, N'4095 Cooper Dr.', N'Kenmore', N'WA', N'98028', N'US', N'986-555-0177', NULL, NULL, NULL, NULL, 1, NULL, 57) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'david5', N'Finance', N'231203233', N'david5@adventure-works.com', N'Barber', N'David', NULL, N'8967 Hamilton Ave.', N'Newport Hills', N'WA', N'98006', N'US', N'477-555-0132', NULL, NULL, NULL, NULL, 1, NULL, 58) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'david6', N'Finance', N'30845', N'david6@adventure-works.com', N'Liu', N'David', NULL, N'9605 Pheasant Circle', N'Gold Bar', N'WA', N'98251', N'US', N'646-555-0185', NULL, NULL, NULL, NULL, 1, NULL, 59) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'david7', N'Production', N'860123571', N'david7@adventure-works.com', N'Lawrence', N'David', NULL, N'158 Walnut Ave', N'Monroe', N'WA', N'98272', N'US', N'118-555-0177', NULL, NULL, NULL, NULL, 1, NULL, 60) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'david8', N'Sales', N'987554265', N'david8@adventure-works.com', N'Campbell', N'David', NULL, N'2284 Azalea Avenue', N'Bellevue', N'WA', N'98004', N'US', N'740-555-0182', NULL, NULL, NULL, NULL, 1, NULL, 61) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'deborah0', N'Finance', N'363923697', N'deborah0@adventure-works.com', N'Poe', N'Deborah', NULL, N'7640 First Ave.', N'Everett', N'WA', N'98201', N'US', N'602-555-0194', NULL, NULL, NULL, NULL, 1, NULL, 62) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'denise0', N'Production', N'652535724', N'denise0@adventure-works.com', N'Smith', N'Denise', NULL, N'5669 Ironwood Way', N'Kenmore', N'WA', N'98028', N'US', N'869-555-0119', NULL, NULL, NULL, NULL, 1, NULL, 63) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'diane0', N'Production', N'9659517', N'diane0@adventure-works.com', N'Glimp', N'Diane', NULL, N'9006 Woodside Way', N'Redmond', N'WA', N'98052', N'US', N'202-555-0151', NULL, NULL, NULL, NULL, 1, NULL, 64) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'diane1', N'Research and Development', N'811994146', N'diane1@adventure-works.com', N'Margheim', N'Diane', NULL, N'475 Santa Maria', N'Everett', N'WA', N'98201', N'US', N'815-555-0138', NULL, NULL, NULL, NULL, 1, NULL, 65) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'diane2', N'Production', N'92096924', N'diane2@adventure-works.com', N'Tibbott', N'Diane', NULL, N'8192 Seagull Court', N'Kenmore', N'WA', N'98028', N'US', N'361-555-0180', NULL, NULL, NULL, NULL, 1, NULL, 66) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'don0', N'Production', N'222400012', N'don0@adventure-works.com', N'Hall', N'Don', NULL, N'1411 Ranch Drive', N'Carnation', N'WA', N'98014', N'US', N'100-555-0174', NULL, NULL, NULL, NULL, 1, NULL, 67) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'doris0', N'Production', N'565090917', N'doris0@adventure-works.com', N'Hartwig', N'Doris', NULL, N'5553 Cash Avenue', N'Kenmore', N'WA', N'98028', N'US', N'328-555-0150', NULL, NULL, NULL, NULL, 1, NULL, 68) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'douglas0', N'Production', N'435234965', N'douglas0@adventure-works.com', N'Hite', N'Douglas', NULL, N'390 Ridgewood Ct.', N'Carnation', N'WA', N'98014', N'US', N'808-555-0172', NULL, NULL, NULL, NULL, 1, NULL, 69) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'dragan0', N'Finance', N'663843431', N'dragan0@adventure-works.com', N'Tomic', N'Dragan', N'# 14', N'3884 Beauty Street', N'Gold Bar', N'WA', N'98251', N'US', N'117-555-0185', NULL, NULL, NULL, NULL, 1, NULL, 70) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'dylan0', N'Research and Development', N'134969118', N'dylan0@adventure-works.com', N'Miller', N'Dylan', NULL, N'7048 Laurel', N'Kenmore', N'WA', N'98028', N'US', N'181-555-0156', NULL, NULL, NULL, NULL, 1, NULL, 71) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ebru0', N'Production', N'455563743', N'ebru0@adventure-works.com', N'Ersan', N'Ebru', NULL, N'8316 La Salle St.', N'Sammamish', N'WA', N'98074', N'US', N'202-555-0187', NULL, NULL, NULL, NULL, 1, NULL, 72) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ed0', N'Production', N'461786517', N'ed0@adventure-works.com', N'Dudenhoefer', N'Ed', NULL, N'4598 Manila Avenue', N'Seattle', N'WA', N'98104', N'US', N'919-555-0140', NULL, NULL, NULL, NULL, 1, NULL, 73) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'elizabeth0', N'Production', N'912141525', N'elizabeth0@adventure-works.com', N'Keyser', N'Elizabeth', NULL, N'350 Pastel Drive', N'Kent', N'WA', N'98031', N'US', N'318-555-0137', NULL, NULL, NULL, NULL, 1, NULL, 74) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'eric0', N'Production', N'45615666', N'eric0@adventure-works.com', N'Gubbels', N'Eric', NULL, N'371 Apple Dr.', N'Edmonds', N'WA', N'98020', N'US', N'260-555-0119', NULL, NULL, NULL, NULL, 1, NULL, 75) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'eric1', N'Production', N'697712387', N'eric1@adventure-works.com', N'Brown', N'Eric', NULL, N'5086 Nottingham Place', N'Duvall', N'WA', N'98019', N'US', N'680-555-0118', NULL, NULL, NULL, NULL, 1, NULL, 76) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'eric2', N'Purchasing', N'381073001', N'eric2@adventure-works.com', N'Kurjan', N'Eric', NULL, N'1378 String Dr', N'Renton', N'WA', N'98055', N'US', N'265-555-0195', NULL, NULL, NULL, NULL, 1, NULL, 77) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'erin0', N'Purchasing', N'785853949', N'erin0@adventure-works.com', N'Hagens', N'Erin', NULL, N'2947 Vine Lane', N'Bellevue', N'WA', N'98004', N'US', N'842-555-0158', NULL, NULL, NULL, NULL, 1, NULL, 78) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'eugene0', N'Production', N'87268837', N'eugene0@adventure-works.com', N'Zabokritski', N'Eugene', NULL, N'7939 Bayview Court', N'Sammamish', N'WA', N'98074', N'US', N'241-555-0191', NULL, NULL, NULL, NULL, 1, NULL, 79) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'eugene1', N'Production', N'66073987', N'eugene1@adventure-works.com', N'Kogan', N'Eugene', NULL, N'991 Vista Verde', N'Duvall', N'WA', N'98019', N'US', N'173-555-0179', NULL, NULL, NULL, NULL, 1, NULL, 80) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'fadi0', N'Production', N'212801092', N'fadi0@adventure-works.com', N'Fakhouri', N'Fadi', NULL, N'1285 Greenbrier Street', N'Snohomish', N'WA', N'98296', N'US', N'935-555-0116', NULL, NULL, NULL, NULL, 1, NULL, 81) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'fran?ois0', N'Information Services', N'643805155', N'fran?ois0@adventure-works.com', N'Ajenstat', N'Fran?ois', NULL, N'1144 Paradise Ct.', N'Issaquah', N'WA', N'98027', N'US', N'785-555-0110', NULL, NULL, NULL, NULL, 1, NULL, 82) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'frank0', N'Production', N'749211824', N'frank0@adventure-works.com', N'Lee', N'Frank', NULL, N'8290 Margaret Ct.', N'Seattle', N'WA', N'98104', N'US', N'158-555-0191', NULL, NULL, NULL, NULL, 1, NULL, 83) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'frank1', N'Production', N'10708100', N'frank1@adventure-works.com', N'Miller', N'Frank', NULL, N'591 Merriewood Drive', N'Snohomish', N'WA', N'98296', N'US', N'167-555-0139', NULL, NULL, NULL, NULL, 1, NULL, 84) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'frank2', N'Purchasing', N'367453993', N'frank2@adventure-works.com', N'Pellow', N'Frank', N'Unit H', N'5980 Icicle Circle', N'Renton', N'WA', N'98055', N'US', N'163-555-0147', NULL, NULL, NULL, NULL, 1, NULL, 85) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'frank3', N'Production', N'947029962', N'frank3@adventure-works.com', N'Martinez', N'Frank', NULL, N'5724 Victory Lane', N'Snohomish', N'WA', N'98296', N'US', N'203-555-0196', NULL, NULL, NULL, NULL, 1, NULL, 86) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'fred0', N'Production', N'295971920', N'fred0@adventure-works.com', N'Northup', N'Fred', NULL, N'2601 Cambridge Drive', N'Snohomish', N'WA', N'98296', N'US', N'818-555-0192', NULL, NULL, NULL, NULL, 1, NULL, 87) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'fukiko0', N'Purchasing', N'482810518', N'fukiko0@adventure-works.com', N'Ogisu', N'Fukiko', NULL, N'8751 Norse Drive', N'Bellevue', N'WA', N'98004', N'US', N'520-555-0177', NULL, NULL, NULL, NULL, 1, NULL, 88) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'gabe0', N'Production', N'440379437', N'gabe0@adventure-works.com', N'Mares', N'Gabe', NULL, N'1061 Buskrik Avenue', N'Edmonds', N'WA', N'98020', N'US', N'310-555-0117', NULL, NULL, NULL, NULL, 1, NULL, 89) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'gail0', N'Engineering', N'695256908', N'gail0@adventure-works.com', N'Erickson', N'Gail', NULL, N'9435 Breck Court', N'Bellevue', N'WA', N'98004', N'US', N'849-555-0139', NULL, NULL, NULL, NULL, 1, NULL, 90) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'garrett0', N'Production', N'271438431', N'garrett0@adventure-works.com', N'Young', N'Garrett', NULL, N'2115 Passing', N'Snohomish', N'WA', N'98296', N'US', N'609-555-0179', NULL, NULL, NULL, NULL, 1, NULL, 91) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'garrett1', N'Sales', N'234474252', N'garrett1@adventure-works.com', N'Vargas', N'Garrett', NULL, N'10203 Acorn Avenue', N'Calgary', N'AB ', N'T2P 2G8', N'CA', N'922-555-0165', NULL, NULL, NULL, NULL, 1, NULL, 92) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'gary0', N'Production', N'502058701', N'gary0@adventure-works.com', N'Yukish', N'Gary', NULL, N'6057 Hill Street', N'Edmonds', N'WA', N'98020', N'US', N'901-555-0125', NULL, NULL, NULL, NULL, 1, NULL, 93) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'gary1', N'Facilities and Maintenance', N'141165819', N'gary1@adventure-works.com', N'Altman', N'Gary', NULL, N'2598 Breck Court', N'Renton', N'WA', N'98055', N'US', N'110-555-0112', NULL, NULL, NULL, NULL, 1, NULL, 94) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'george0', N'Production', N'476115505', N'george0@adventure-works.com', N'Li', N'George', NULL, N'3074 Arbor Drive', N'Carnation', N'WA', N'98014', N'US', N'518-555-0199', NULL, NULL, NULL, NULL, 1, NULL, 95) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'gigi0', N'Research and Development', N'658797903', N'gigi0@adventure-works.com', N'Matthew', N'Gigi', NULL, N'7808 Brown St.', N'Bellevue', N'WA', N'98004', N'US', N'185-555-0186', NULL, NULL, NULL, NULL, 1, NULL, 96) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'gordon0', N'Purchasing', N'466142721', N'gordon0@adventure-works.com', N'Hee', N'Gordon', NULL, N'108 Lakeside Court', N'Bellevue', N'WA', N'98004', N'US', N'230-555-0144', NULL, NULL, NULL, NULL, 1, NULL, 97) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'grant0', N'Human Resources', N'476980013', N'grant0@adventure-works.com', N'Culbertson', N'Grant', NULL, N'213 Stonewood Drive', N'Gold Bar', N'WA', N'98251', N'US', N'955-555-0131', NULL, NULL, NULL, NULL, 1, NULL, 98) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'greg0', N'Production', N'687685941', N'greg0@adventure-works.com', N'Alderson', N'Greg', NULL, N'8684 Military East', N'Bellevue', N'WA', N'98004', N'US', N'332-555-0150', NULL, NULL, NULL, NULL, 1, NULL, 99) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'guy1', N'Production', N'14417807', N'guy1@adventure-works.com', N'Gilbert', N'Guy', NULL, N'7726 Driftwood Drive', N'Monroe', N'WA', N'98272', N'US', N'320-555-0195', NULL, NULL, NULL, NULL, 1, NULL, 100) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'hanying0', N'Production', N'568596888', N'hanying0@adventure-works.com', N'Feng', N'Hanying', NULL, N'7297 RisingView', N'Redmond', N'WA', N'98052', N'US', N'319-555-0139', NULL, NULL, NULL, NULL, 1, NULL, 101) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'hao0', N'Human Resources', N'416679555', N'hao0@adventure-works.com', N'Chen', N'Hao', N'# 141', N'7691 Benedict Ct.', N'Issaquah', N'WA', N'98027', N'US', N'806-555-0136', NULL, NULL, NULL, NULL, 1, NULL, 102) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'hazem0', N'Quality Assurance', N'398223854', N'hazem0@adventure-works.com', N'Abolrous', N'Hazem', NULL, N'5050 Mt. Wilson Way', N'Kenmore', N'WA', N'98028', N'US', N'869-555-0125', NULL, NULL, NULL, NULL, 1, NULL, 103) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'houman0', N'Production', N'153288994', N'houman0@adventure-works.com', N'Pournasseh', N'Houman', NULL, N'9882 Clay Rde', N'Redmond', N'WA', N'98052', N'US', N'180-555-0136', NULL, NULL, NULL, NULL, 1, NULL, 104) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'hung-fu0', N'Production', N'113393530', N'hung-fu0@adventure-works.com', N'Ting', N'Hung-Fu', NULL, N'7086 O St.', N'Sammamish', N'WA', N'98074', N'US', N'497-555-0181', NULL, NULL, NULL, NULL, 1, NULL, 105) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ivo0', N'Production', N'964089218', N'ivo0@adventure-works.com', N'Salmre', N'Ivo', NULL, N'3841 Silver Oaks Place', N'Monroe', N'WA', N'98272', N'US', N'115-555-0179', NULL, NULL, NULL, NULL, 1, NULL, 106) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jack0', N'Production', N'60114406', N'jack0@adventure-works.com', N'Richins', N'Jack', NULL, N'1356 Grove Way', N'Monroe', N'WA', N'98272', N'US', N'552-555-0111', NULL, NULL, NULL, NULL, 1, NULL, 107) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jack1', N'Production', N'58791499', N'jack1@adventure-works.com', N'Creasey', N'Jack', NULL, N'874 Olivera Road', N'Seattle', N'WA', N'98104', N'US', N'521-555-0113', NULL, NULL, NULL, NULL, 1, NULL, 108) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jae0', N'Sales', N'668991357', N'jae0@adventure-works.com', N'Pak', N'Jae', NULL, N'Downshire Way', N'Cambridge', N'ENG ', N'BA5 3HX', N'GB', N'1 (11) 500 555-0145', NULL, NULL, NULL, NULL, 1, NULL, 109) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'james0', N'Production', N'339712426', N'james0@adventure-works.com', N'Kramer', N'James', NULL, N'4734 Sycamore Court', N'Monroe', N'WA', N'98272', N'US', N'119-555-0117', NULL, NULL, NULL, NULL, 1, NULL, 110) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'james1', N'Production', N'519899904', N'james1@adventure-works.com', N'Hamilton', N'James', NULL, N'9652 Los Angeles', N'Monroe', N'WA', N'98272', N'US', N'870-555-0122', NULL, NULL, NULL, NULL, 1, NULL, 111) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jan0', N'Production', N'587567941', N'jan0@adventure-works.com', N'Miksovsky', N'Jan', NULL, N'8624 Pepper Way', N'Everett', N'WA', N'98201', N'US', N'139-555-0131', NULL, NULL, NULL, NULL, 1, NULL, 112) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'janaina0', N'Information Services', N'525932996', N'janaina0@adventure-works.com', N'Bueno', N'Janaina', NULL, N'5979 El Pueblo', N'Issaquah', N'WA', N'98027', N'US', N'623-555-0155', NULL, NULL, NULL, NULL, 1, NULL, 113) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'janet0', N'Finance', N'519756660', N'janet0@adventure-works.com', N'Sheperdigian', N'Janet', NULL, N'6871 Thornwood Dr.', N'Sammamish', N'WA', N'98074', N'US', N'393-555-0186', NULL, NULL, NULL, NULL, 1, NULL, 114) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'janeth0', N'Production', N'187369436', N'janeth0@adventure-works.com', N'Esteves', N'Janeth', NULL, N'4566 La Jolla', N'Monroe', N'WA', N'98272', N'US', N'540-555-0191', NULL, NULL, NULL, NULL, 1, NULL, 115) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'janice0', N'Tool Design', N'486228782', N'janice0@adventure-works.com', N'Galvin', N'Janice', NULL, N'3397 Rancho View Drive', N'Redmond', N'WA', N'98052', N'US', N'473-555-0117', NULL, NULL, NULL, NULL, 1, NULL, 116) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jason0', N'Production', N'733022683', N'jason0@adventure-works.com', N'Watters', N'Jason', NULL, N'9320 Teakwood Dr.', N'Bellevue', N'WA', N'98004', N'US', N'571-555-0179', NULL, NULL, NULL, NULL, 1, NULL, 117) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jay0', N'Production', N'63179277', N'jay0@adventure-works.com', N'Adams', N'Jay', NULL, N'896 Southdale', N'Monroe', N'WA', N'98272', N'US', N'407-555-0165', NULL, NULL, NULL, NULL, 1, NULL, 118) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jean0', N'Information Services', N'441044382', N'jean0@adventure-works.com', N'Trenary', N'Jean', NULL, N'2383 Pepper Drive', N'Redmond', N'WA', N'98052', N'US', N'685-555-0120', NULL, NULL, NULL, NULL, 1, NULL, 119) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jeff0', N'Production', N'712885347', N'jeff0@adventure-works.com', N'Hay', N'Jeff', NULL, N'3385 Crestview Drive', N'Everett', N'WA', N'98201', N'US', N'350-555-0167', NULL, NULL, NULL, NULL, 1, NULL, 120) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jeffrey0', N'Production', N'132674823', N'jeffrey0@adventure-works.com', N'Ford', N'Jeffrey', NULL, N'5734 Ashford Court', N'Monroe', N'WA', N'98272', N'US', N'984-555-0185', NULL, NULL, NULL, NULL, 1, NULL, 121) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jianshuo0', N'Production', N'160739235', N'jianshuo0@adventure-works.com', N'Wang', N'Jian Shuo', NULL, N'8310 Ridge Circle', N'Monroe', N'WA', N'98272', N'US', N'952-555-0178', NULL, NULL, NULL, NULL, 1, NULL, 122) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jill0', N'Marketing', N'72636981', N'jill0@adventure-works.com', N'Williams', N'Jill', NULL, N'3238 Laguna Circle', N'Everett', N'WA', N'98201', N'US', N'510-555-0121', NULL, NULL, NULL, NULL, 1, NULL, 123) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jillian0', N'Sales', N'615389812', N'jillian0@adventure-works.com', N'Carson', N'Jillian', NULL, N'80 Sunview Terrace', N'Duluth', N'MN ', N'55802', N'US', N'517-555-0117', NULL, NULL, NULL, NULL, 1, NULL, 124) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jim0', N'Production', N'674171828', N'jim0@adventure-works.com', N'Scardelis', N'Jim', NULL, N'172 Turning Dr.', N'Edmonds', N'WA', N'98020', N'US', N'679-555-0113', NULL, NULL, NULL, NULL, 1, NULL, 125) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jimmy0', N'Shipping and Receiving', N'652779496', N'jimmy0@adventure-works.com', N'Bischoff', N'Jimmy', NULL, N'2176 Brown Street', N'Renton', N'WA', N'98055', N'US', N'927-555-0168', NULL, NULL, NULL, NULL, 1, NULL, 126) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jinghao0', N'Production', N'630184120', N'jinghao0@adventure-works.com', N'Liu', N'Jinghao', NULL, N'9666 Northridge Ct.', N'Carnation', N'WA', N'98014', N'US', N'794-555-0159', NULL, NULL, NULL, NULL, 1, NULL, 127) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jo0', N'Production', N'446466105', N'jo0@adventure-works.com', N'Brown', N'Jo', NULL, N'9693 Mellowood Street', N'Duvall', N'WA', N'98019', N'US', N'632-555-0129', NULL, NULL, NULL, NULL, 1, NULL, 128) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jo1', N'Facilities and Maintenance', N'153479919', N'jo1@adventure-works.com', N'Berry', N'Jo', NULL, N'1748 Bird Drive', N'Index', N'WA', N'98256', N'US', N'228-555-0159', NULL, NULL, NULL, NULL, 1, NULL, 129) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'john0', N'Production', N'494170342', N'john0@adventure-works.com', N'Campbell', N'John', NULL, N'2639 Anchor Court', N'Seattle', N'WA', N'98104', N'US', N'435-555-0113', NULL, NULL, NULL, NULL, 1, NULL, 130) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'john1', N'Production', N'981597097', N'john1@adventure-works.com', N'Evans', N'John', NULL, N'136 Balboa Court', N'Seattle', N'WA', N'98104', N'US', N'172-555-0130', NULL, NULL, NULL, NULL, 1, NULL, 131) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'john2', N'Production', N'305522471', N'john2@adventure-works.com', N'Chen', N'John', NULL, N'3977 Central Avenue', N'Duvall', N'WA', N'98019', N'US', N'201-555-0163', NULL, NULL, NULL, NULL, 1, NULL, 132) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'john3', N'Production', N'568626529', N'john3@adventure-works.com', N'Frum', N'John', NULL, N'3665 Oak Creek Ct.', N'Everett', N'WA', N'98201', N'US', N'663-555-0172', NULL, NULL, NULL, NULL, 1, NULL, 133) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'john4', N'Production', N'561196580', N'john4@adventure-works.com', N'Kane', N'John', NULL, N'8209 Green View Court', N'Duvall', N'WA', N'98019', N'US', N'254-555-0114', NULL, NULL, NULL, NULL, 1, NULL, 134) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'john5', N'Marketing', N'222969461', N'john5@adventure-works.com', N'Wood', N'John', NULL, N'9906 Oak Grove Road', N'Redmond', N'WA', N'98052', N'US', N'486-555-0150', NULL, NULL, NULL, NULL, 1, NULL, 135) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jolynn0', N'Production', N'309738752', N'jolynn0@adventure-works.com', N'Dobney', N'JoLynn', NULL, N'7126 Ending Ct.', N'Seattle', N'WA', N'98104', N'US', N'903-555-0145', NULL, NULL, NULL, NULL, 1, NULL, 136) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jos?1', N'Sales', N'399771412', N'jos?1@adventure-works.com', N'Saraiva', N'Jos?', NULL, N'9100 Sheppard Avenue North', N'Ottawa', N'ON ', N'K4B 1T7', N'CA', N'185-555-0169', NULL, NULL, NULL, NULL, 1, NULL, 137) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jose0', N'Production', N'788456780', N'jose0@adventure-works.com', N'Lugo', N'Jose', NULL, N'5125 Cotton Ct.', N'Seattle', N'WA', N'98104', N'US', N'587-555-0115', NULL, NULL, NULL, NULL, 1, NULL, 138) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jossef0', N'Engineering', N'998320692', N'jossef0@adventure-works.com', N'Goldberg', N'Jossef', NULL, N'5670 Bel Air Dr.', N'Renton', N'WA', N'98055', N'US', N'122-555-0189', NULL, NULL, NULL, NULL, 1, NULL, 139) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'jun0', N'Production', N'857651804', N'jun0@adventure-works.com', N'Cao', N'Jun', NULL, N'4909 Poco Lane', N'Redmond', N'WA', N'98052', N'US', N'299-555-0113', NULL, NULL, NULL, NULL, 1, NULL, 140) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'karan0', N'Production', N'834186596', N'karan0@adventure-works.com', N'Khanna', N'Karan', NULL, N'1102 Ravenwood', N'Seattle', N'WA', N'98104', N'US', N'447-555-0186', NULL, NULL, NULL, NULL, 1, NULL, 141) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'karen0', N'Document Control', N'260770918', N'karen0@adventure-works.com', N'Berge', N'Karen', NULL, N'3127 El Camino Drive', N'Index', N'WA', N'98256', N'US', N'746-555-0164', NULL, NULL, NULL, NULL, 1, NULL, 142) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'karen1', N'Information Services', N'58317344', N'karen1@adventure-works.com', N'Berg', N'Karen', NULL, N'5256 Chickpea Ct.', N'Issaquah', N'WA', N'98027', N'US', N'654-555-0177', NULL, NULL, NULL, NULL, 1, NULL, 143) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'kathie0', N'Production', N'167554340', N'kathie0@adventure-works.com', N'Flood', N'Kathie', NULL, N'9241 St George Dr.', N'Everett', N'WA', N'98201', N'US', N'446-555-0118', NULL, NULL, NULL, NULL, 1, NULL, 144) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'katie0', N'Production', N'862951447', N'katie0@adventure-works.com', N'McAskill-White', N'Katie', NULL, N'4948 West 4th St', N'Seattle', N'WA', N'98104', N'US', N'809-555-0133', NULL, NULL, NULL, NULL, 1, NULL, 145) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ken0', N'Executive', N'295847284', N'ken0@adventure-works.com', N'S?nchez', N'Ken', NULL, N'4350 Minute Dr.', N'Newport Hills', N'WA', N'98006', N'US', N'697-555-0142', NULL, NULL, NULL, NULL, 1, NULL, 146) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ken1', N'Production', N'693168613', N'ken1@adventure-works.com', N'Myer', N'Ken', NULL, N'1362 Somerset Place', N'Everett', N'WA', N'98201', N'US', N'949-555-0174', NULL, NULL, NULL, NULL, 1, NULL, 147) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'kendall0', N'Production', N'571658797', N'kendall0@adventure-works.com', N'Keil', N'Kendall', NULL, N'7439 Laguna Niguel', N'Seattle', N'WA', N'98104', N'US', N'138-555-0128', NULL, NULL, NULL, NULL, 1, NULL, 148) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'kevin0', N'Marketing', N'253022876', N'kevin0@adventure-works.com', N'Brown', N'Kevin', NULL, N'7883 Missing Canyon Court', N'Everett', N'WA', N'98201', N'US', N'150-555-0189', NULL, NULL, NULL, NULL, 1, NULL, 149) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'kevin1', N'Production', N'918737118', N'kevin1@adventure-works.com', N'Liu', N'Kevin', NULL, N'7594 Alexander Pl.', N'Seattle', N'WA', N'98104', N'US', N'714-555-0138', NULL, NULL, NULL, NULL, 1, NULL, 150) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'kevin2', N'Production', N'801365500', N'kevin2@adventure-works.com', N'Homer', N'Kevin', N'# 4', N'6058 Hill Street', N'Bellevue', N'WA', N'98004', N'US', N'555-555-0113', NULL, NULL, NULL, NULL, 1, NULL, 151) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'kim0', N'Shipping and Receiving', N'420776180', N'kim0@adventure-works.com', N'Ralls', N'Kim', NULL, N'1226 Shoe St.', N'Bothell', N'WA', N'98011', N'US', N'309-555-0129', NULL, NULL, NULL, NULL, 1, NULL, 152) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'kim1', N'Production', N'6298838', N'kim1@adventure-works.com', N'Abercrombie', N'Kim', NULL, N'9752 Jeanne Circle', N'Carnation', N'WA', N'98014', N'US', N'208-555-0114', NULL, NULL, NULL, NULL, 1, NULL, 153) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'kimberly0', N'Production', N'390124815', N'kimberly0@adventure-works.com', N'Zimmerman', N'Kimberly', NULL, N'8656 Lakespring Place', N'Seattle', N'WA', N'98104', N'US', N'123-555-0167', NULL, NULL, NULL, NULL, 1, NULL, 154) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'kirk0', N'Production', N'275962311', N'kirk0@adventure-works.com', N'Koenigsbauer', N'Kirk', NULL, N'1220 Bradford Way', N'Seattle', N'WA', N'98104', N'US', N'669-555-0150', NULL, NULL, NULL, NULL, 1, NULL, 155) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'kitti0', N'Production', N'211789056', N'kitti0@adventure-works.com', N'Lertpiriyasuwat', N'Kitti', NULL, N'5376 Catanzaro Way', N'Seattle', N'WA', N'98104', N'US', N'785-555-0132', NULL, NULL, NULL, NULL, 1, NULL, 156) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'kok-ho0', N'Production', N'778552911', N'kok-ho0@adventure-works.com', N'Loh', N'Kok-Ho', NULL, N'3708 Montana', N'Bellevue', N'WA', N'98004', N'US', N'999-555-0155', NULL, NULL, NULL, NULL, 1, NULL, 157) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'krishna0', N'Production', N'56772045', N'krishna0@adventure-works.com', N'Sunkammurali', N'Krishna', NULL, N'6870 D Bel Air Drive', N'Edmonds', N'WA', N'98020', N'US', N'491-555-0183', NULL, NULL, NULL, NULL, 1, NULL, 158) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'lane0', N'Production', N'322160340', N'lane0@adventure-works.com', N'Sacksteder', N'Lane', N'# 2', N'3029 Pastime Dr', N'Seattle', N'WA', N'98104', N'US', N'200-555-0117', NULL, NULL, NULL, NULL, 1, NULL, 159) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'laura0', N'Production', N'514829225', N'laura0@adventure-works.com', N'Steele', N'Laura', NULL, N'1825 Corte Del Prado', N'Duvall', N'WA', N'98019', N'US', N'777-555-0141', NULL, NULL, NULL, NULL, 1, NULL, 160) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'laura1', N'Executive', N'184188301', N'laura1@adventure-works.com', N'Norman', N'Laura', NULL, N'6937 E. 42nd Street', N'Renton', N'WA', N'98055', N'US', N'615-555-0110', NULL, NULL, NULL, NULL, 1, NULL, 161) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'laura1', N'Finance', N'184188301', N'laura1@adventure-works.com', N'Norman', N'Laura', NULL, N'6937 E. 42nd Street', N'Renton', N'WA', N'98055', N'US', N'615-555-0110', NULL, NULL, NULL, NULL, 1, NULL, 162) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'linda0', N'Production', N'54759846', N'linda0@adventure-works.com', N'Moschell', N'Linda', NULL, N'3284 S. Blank Avenue', N'Bellevue', N'WA', N'98004', N'US', N'612-555-0171', NULL, NULL, NULL, NULL, 1, NULL, 163) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'linda1', N'Production', N'812797414', N'linda1@adventure-works.com', N'Randall', N'Linda', NULL, N'77 Birchwood', N'Seattle', N'WA', N'98104', N'US', N'696-555-0157', NULL, NULL, NULL, NULL, 1, NULL, 164) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'linda2', N'Purchasing', N'407505660', N'linda2@adventure-works.com', N'Meisner', N'Linda', NULL, N'6118 Grasswood Circle', N'Bellevue', N'WA', N'98004', N'US', N'916-555-0165', NULL, NULL, NULL, NULL, 1, NULL, 165) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'linda3', N'Sales', N'191644724', N'linda3@adventure-works.com', N'Mitchell', N'Linda', NULL, N'2487 Riverside Drive', N'Nevada', N'UT ', N'84407', N'US', N'883-555-0116', NULL, NULL, NULL, NULL, 1, NULL, 166) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'lionel0', N'Production', N'399658727', N'lionel0@adventure-works.com', N'Penuchot', N'Lionel', NULL, N'7765 Sunsine Drive', N'Seattle', N'WA', N'98104', N'US', N'450-555-0152', NULL, NULL, NULL, NULL, 1, NULL, 167) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'lolan0', N'Production', N'204035155', N'lolan0@adventure-works.com', N'Song', N'Lolan', NULL, N'8152 Claudia Dr.', N'Edmonds', N'WA', N'98020', N'US', N'582-555-0178', NULL, NULL, NULL, NULL, 1, NULL, 168) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'lori0', N'Production', N'332349500', N'lori0@adventure-works.com', N'Kane', N'Lori', NULL, N'3066 Wallace Dr.', N'Redmond', N'WA', N'98052', N'US', N'289-555-0196', NULL, NULL, NULL, NULL, 1, NULL, 169) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'lori1', N'Facilities and Maintenance', N'879334904', N'lori1@adventure-works.com', N'Penor', N'Lori', NULL, N'3514 Sunshine', N'Index', N'WA', N'98256', N'US', N'295-555-0161', NULL, NULL, NULL, NULL, 1, NULL, 170) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'lorraine0', N'Production', N'19312190', N'lorraine0@adventure-works.com', N'Nay', N'Lorraine', NULL, N'2059 Clay Rd', N'Edmonds', N'WA', N'98020', N'US', N'845-555-0184', NULL, NULL, NULL, NULL, 1, NULL, 171) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'lynn0', N'Sales', N'758596752', N'lynn0@adventure-works.com', N'Tsoflias', N'Lynn', NULL, N'34 Waterloo Road', N'Melbourne', N'VIC ', N'3000', N'AU', N'1 (11) 500 555-0190', NULL, NULL, NULL, NULL, 1, NULL, 172) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'maciej0', N'Production', N'414476027', N'maciej0@adventure-works.com', N'Dusza', N'Maciej', NULL, N'3026 Anchor Drive', N'Edmonds', N'WA', N'98020', N'US', N'237-555-0128', NULL, NULL, NULL, NULL, 1, NULL, 173) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'magnus0', N'Facilities and Maintenance', N'552560652', N'magnus0@adventure-works.com', N'Hedlund', N'Magnus', NULL, N'9533 Working Drive', N'Renton', N'WA', N'98055', N'US', N'583-555-0182', NULL, NULL, NULL, NULL, 1, NULL, 174) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'mandar0', N'Production', N'370581729', N'mandar0@adventure-works.com', N'Samant', N'Mandar', NULL, N'2598 La Vista Circle', N'Duvall', N'WA', N'98019', N'US', N'140-555-0132', NULL, NULL, NULL, NULL, 1, NULL, 175) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'marc0', N'Production', N'364818297', N'marc0@adventure-works.com', N'Ingle', N'Marc', NULL, N'2473 Orchard Way', N'Sammamish', N'WA', N'98074', N'US', N'234-555-0169', NULL, NULL, NULL, NULL, 1, NULL, 176) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'margie0', N'Production', N'750246141', N'margie0@adventure-works.com', N'Shoop', N'Margie', NULL, N'2080 Sycamore Drive', N'Edmonds', N'WA', N'98020', N'US', N'818-555-0128', NULL, NULL, NULL, NULL, 1, NULL, 177) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'mark0', N'Quality Assurance', N'381772114', N'mark0@adventure-works.com', N'Harrington', N'Mark', NULL, N'8585 Los Gatos Ct.', N'Issaquah', N'WA', N'98027', N'US', N'147-555-0179', NULL, NULL, NULL, NULL, 1, NULL, 178) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'mark1', N'Production', N'948320468', N'mark1@adventure-works.com', N'McArthur', N'Mark', NULL, N'9863 Ridge Place', N'Redmond', N'WA', N'98052', N'US', N'417-555-0154', NULL, NULL, NULL, NULL, 1, NULL, 179) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'mary0', N'Marketing', N'767955365', N'mary0@adventure-works.com', N'Gibson', N'Mary', NULL, N'3928 San Francisco', N'Everett', N'WA', N'98201', N'US', N'531-555-0183', NULL, NULL, NULL, NULL, 1, NULL, 180) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'mary1', N'Production', N'717889520', N'mary1@adventure-works.com', N'Baker', N'Mary', NULL, N'2354 Frame Ln.', N'Seattle', N'WA', N'98104', N'US', N'283-555-0185', NULL, NULL, NULL, NULL, 1, NULL, 181) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'mary2', N'Marketing', N'52541318', N'mary2@adventure-works.com', N'Dempsey', N'Mary', NULL, N'6307 Greenbelt Way', N'Bellevue', N'WA', N'98004', N'US', N'124-555-0114', NULL, NULL, NULL, NULL, 1, NULL, 182) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'matthias0', N'Shipping and Receiving', N'584205124', N'matthias0@adventure-works.com', N'Berndt', N'Matthias', NULL, N'4312 Cambridge Drive', N'Renton', N'WA', N'98055', N'US', N'139-555-0120', NULL, NULL, NULL, NULL, 1, NULL, 183) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'merav0', N'Production', N'301435199', N'merav0@adventure-works.com', N'Netz', N'Merav', NULL, N'5666 Hazelnut Lane', N'Seattle', N'WA', N'98104', N'US', N'224-555-0187', NULL, NULL, NULL, NULL, 1, NULL, 184) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'michael0', N'Production', N'545337468', N'michael0@adventure-works.com', N'Hines', N'Michael', NULL, N'1792 Belmont Rd.', N'Monroe', N'WA', N'98272', N'US', N'218-555-0126', NULL, NULL, NULL, NULL, 1, NULL, 185) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'michael1', N'Production', N'830150469', N'michael1@adventure-works.com', N'Rothkugel', N'Michael', NULL, N'207 Berry Court', N'Edmonds', N'WA', N'98020', N'US', N'454-555-0119', NULL, NULL, NULL, NULL, 1, NULL, 186) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'michael2', N'Production', N'398737566', N'michael2@adventure-works.com', N'Patten', N'Michael', NULL, N'2038 Encino Drive', N'Edmonds', N'WA', N'98020', N'US', N'441-555-0195', NULL, NULL, NULL, NULL, 1, NULL, 187) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'michael3', N'Production', N'578935259', N'michael3@adventure-works.com', N'Ray', N'Michael', NULL, N'6498 Mining Rd.', N'Seattle', N'WA', N'98104', N'US', N'156-555-0199', NULL, NULL, NULL, NULL, 1, NULL, 188) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'michael4', N'Production', N'334834274', N'michael4@adventure-works.com', N'Entin', N'Michael', NULL, N'2482 Buckingham Dr.', N'Redmond', N'WA', N'98052', N'US', N'817-555-0186', NULL, NULL, NULL, NULL, 1, NULL, 189) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'michael5', N'Production', N'878395493', N'michael5@adventure-works.com', N'Vanderhyde', N'Michael', NULL, N'2812 Mazatlan', N'Edmonds', N'WA', N'98020', N'US', N'296-555-0121', NULL, NULL, NULL, NULL, 1, NULL, 190) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'michael6', N'Research and Development', N'879342154', N'michael6@adventure-works.com', N'Raheem', N'Michael', NULL, N'1234 Seaside Way', N'San Francisco', N'CA ', N'94109', N'US', N'330-555-2568', NULL, NULL, NULL, NULL, 1, NULL, 191) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'michael7', N'Production', N'582347317', N'michael7@adventure-works.com', N'Zwilling', N'Michael', NULL, N'7511 Cooper Dr.', N'Edmonds', N'WA', N'98020', N'US', N'582-555-0148', NULL, NULL, NULL, NULL, 1, NULL, 192) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'michael8', N'Engineering', N'42487730', N'michael8@adventure-works.com', N'Sullivan', N'Michael', NULL, N'6510 Hacienda Drive', N'Renton', N'WA', N'98055', N'US', N'465-555-0156', NULL, NULL, NULL, NULL, 1, NULL, 193) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'michael9', N'Sales', N'841560125', N'michael9@adventure-works.com', N'Blythe', N'Michael', NULL, N'8154 Via Mexico', N'Detroit', N'MI ', N'48226', N'US', N'257-555-0154', NULL, NULL, NULL, NULL, 1, NULL, 194) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'michiko0', N'Production', N'363996959', N'michiko0@adventure-works.com', N'Osada', N'Michiko', NULL, N'1962 Ferndale Lane', N'Sammamish', N'WA', N'98074', N'US', N'984-555-0148', NULL, NULL, NULL, NULL, 1, NULL, 195) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'mihail0', N'Production', N'413787783', N'mihail0@adventure-works.com', N'Frintu', N'Mihail', NULL, N'2466 Clearland Circle', N'Edmonds', N'WA', N'98020', N'US', N'733-555-0128', NULL, NULL, NULL, NULL, 1, NULL, 196) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'mikael0', N'Purchasing', N'603686790', N'mikael0@adventure-works.com', N'Sandberg', N'Mikael', NULL, N'9539 Glenside Dr', N'Bothell', N'WA', N'98011', N'US', N'309-555-0170', NULL, NULL, NULL, NULL, 1, NULL, 197) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'mike0', N'Finance', N'480951955', N'mike0@adventure-works.com', N'Seamans', N'Mike', NULL, N'1245 Clay Road', N'Index', N'WA', N'98256', N'US', N'927-555-0150', NULL, NULL, NULL, NULL, 1, NULL, 198) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'min0', N'Production', N'872923042', N'min0@adventure-works.com', N'Su', N'Min', NULL, N'7396 Stratton Circle', N'Bellevue', N'WA', N'98004', N'US', N'590-555-0152', NULL, NULL, NULL, NULL, 1, NULL, 199) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'mindaugas0', N'Production', N'342607223', N'mindaugas0@adventure-works.com', N'Krapauskas', N'Mindaugas', NULL, N'9825 Coralie Drive', N'Edmonds', N'WA', N'98020', N'US', N'637-555-0120', NULL, NULL, NULL, NULL, 1, NULL, 200) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'mindy0', N'Human Resources', N'619308550', N'mindy0@adventure-works.com', N'Martin', N'Mindy', NULL, N'9687 Shakespeare Drive', N'Newport Hills', N'WA', N'98006', N'US', N'522-555-0147', NULL, NULL, NULL, NULL, 1, NULL, 201) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'nancy0', N'Production', N'693325305', N'nancy0@adventure-works.com', N'Anderson', N'Nancy', NULL, N'7820 Bird Drive', N'Sammamish', N'WA', N'98074', N'US', N'970-555-0118', NULL, NULL, NULL, NULL, 1, NULL, 202) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'nicole0', N'Production', N'1300049', N'nicole0@adventure-works.com', N'Holliday', N'Nicole', N'# 207', N'3243 Buckingham Dr.', N'Seattle', N'WA', N'98104', N'US', N'508-555-0129', NULL, NULL, NULL, NULL, 1, NULL, 203) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'nitin0', N'Production', N'368920189', N'nitin0@adventure-works.com', N'Mirchandani', N'Nitin', NULL, N'4096 San Remo', N'Sammamish', N'WA', N'98074', N'US', N'143-555-0173', NULL, NULL, NULL, NULL, 1, NULL, 204) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'nuan0', N'Production', N'431859843', N'nuan0@adventure-works.com', N'Yu', N'Nuan', NULL, N'3454 Bel Air Drive', N'Bellevue', N'WA', N'98004', N'US', N'913-555-0184', NULL, NULL, NULL, NULL, 1, NULL, 205) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'olinda0', N'Production', N'163347032', N'olinda0@adventure-works.com', N'Turner', N'Olinda', NULL, N'7221 Peachwillow Street', N'Bellevue', N'WA', N'98004', N'US', N'306-555-0186', NULL, NULL, NULL, NULL, 1, NULL, 206) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ovidiu0', N'Tool Design', N'974026903', N'ovidiu0@adventure-works.com', N'Cracium', N'Ovidiu', NULL, N'5458 Gladstone Drive', N'Kenmore', N'WA', N'98028', N'US', N'719-555-0181', NULL, NULL, NULL, NULL, 1, NULL, 207) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'pamela0', N'Sales', N'61161660', N'pamela0@adventure-works.com', N'Ansman-Wolfe', N'Pamela', NULL, N'636 Vine Hill Way', N'Portland', N'OR ', N'97205', N'US', N'340-555-0193', NULL, NULL, NULL, NULL, 1, NULL, 208) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'pat0', N'Facilities and Maintenance', N'646304055', N'pat0@adventure-works.com', N'Coleman', N'Pat', NULL, N'2425 Notre Dame Ave', N'Gold Bar', N'WA', N'98251', N'US', N'720-555-0158', NULL, NULL, NULL, NULL, 1, NULL, 209) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'patrick0', N'Production', N'90888098', N'patrick0@adventure-works.com', N'Wedge', N'Patrick', NULL, N'3067 Maya', N'Bellevue', N'WA', N'98004', N'US', N'413-555-0124', NULL, NULL, NULL, NULL, 1, NULL, 210) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'patrick1', N'Production', N'988315686', N'patrick1@adventure-works.com', N'Cook', N'Patrick', NULL, N'9537 Ridgewood Drive', N'Seattle', N'WA', N'98104', N'US', N'425-555-0117', NULL, NULL, NULL, NULL, 1, NULL, 211) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'paul0', N'Production', N'384162788', N'paul0@adventure-works.com', N'Komosinski', N'Paul', NULL, N'7270 Pepper Way', N'Bellevue', N'WA', N'98004', N'US', N'147-555-0160', NULL, NULL, NULL, NULL, 1, NULL, 212) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'paul1', N'Production', N'886023130', N'paul1@adventure-works.com', N'Singh', N'Paul', NULL, N'1343 Prospect St', N'Bellevue', N'WA', N'98004', N'US', N'727-555-0112', NULL, NULL, NULL, NULL, 1, NULL, 213) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'paula0', N'Human Resources', N'535145551', N'paula0@adventure-works.com', N'Barreto de Mattos', N'Paula', NULL, N'4311 Clay Rd', N'Bellevue', N'WA', N'98004', N'US', N'523-555-0175', NULL, NULL, NULL, NULL, 1, NULL, 214) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'paula1', N'Production', N'992874797', N'paula1@adventure-works.com', N'Nartker', N'Paula', NULL, N'2144 San Rafael', N'Seattle', N'WA', N'98104', N'US', N'476-555-0119', NULL, NULL, NULL, NULL, 1, NULL, 215) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'peng0', N'Quality Assurance', N'885055826', N'peng0@adventure-works.com', N'Wu', N'Peng', NULL, N'250 Race Court', N'Bothell', N'WA', N'98011', N'US', N'164-555-0164', NULL, NULL, NULL, NULL, 1, NULL, 216) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'pete0', N'Production', N'827686041', N'pete0@adventure-works.com', N'Male', N'Pete', NULL, N'5375 Clearland Circle', N'Seattle', N'WA', N'98104', N'US', N'768-555-0123', NULL, NULL, NULL, NULL, 1, NULL, 217) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'peter0', N'Production Control', N'277173473', N'peter0@adventure-works.com', N'Krebs', N'Peter', NULL, N'3670 All Ways Drive', N'Bellevue', N'WA', N'98004', N'US', N'913-555-0196', NULL, NULL, NULL, NULL, 1, NULL, 218) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'peter1', N'Information Services', N'672243793', N'peter1@adventure-works.com', N'Connelly', N'Peter', NULL, N'9530 Vine Lane', N'Issaquah', N'WA', N'98027', N'US', N'310-555-0133', NULL, NULL, NULL, NULL, 1, NULL, 219) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'pilar0', N'Shipping and Receiving', N'521265716', N'pilar0@adventure-works.com', N'Ackerman', N'Pilar', NULL, N'5407 Cougar Way', N'Seattle', N'WA', N'98104', N'US', N'577-555-0185', NULL, NULL, NULL, NULL, 1, NULL, 220) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'prasanna0', N'Production', N'339233463', N'prasanna0@adventure-works.com', N'Samarawickrama', N'Prasanna', NULL, N'9322 Driving Drive', N'Redmond', N'WA', N'98052', N'US', N'129-555-0199', NULL, NULL, NULL, NULL, 1, NULL, 221) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'rachel0', N'Sales', N'954276278', N'rachel0@adventure-works.com', N'Valdez', N'Rachel', NULL, N'Pascalstr 951', N'Berlin', N'HH ', N'14111', N'DE', N'1 (11) 500 555-0140', NULL, NULL, NULL, NULL, 1, NULL, 222) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'rajesh0', N'Production', N'632092621', N'rajesh0@adventure-works.com', N'Patel', N'Rajesh', NULL, N'5423 Champion Rd.', N'Edmonds', N'WA', N'98020', N'US', N'373-555-0137', NULL, NULL, NULL, NULL, 1, NULL, 223) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ramesh0', N'Information Services', N'314747499', N'ramesh0@adventure-works.com', N'Meyyappan', N'Ramesh', NULL, N'3848 East 39th Street', N'Issaquah', N'WA', N'98027', N'US', N'182-555-0134', NULL, NULL, NULL, NULL, 1, NULL, 224) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'randy0', N'Production', N'8066363', N'randy0@adventure-works.com', N'Reeves', N'Randy', NULL, N'3632 Bank Way', N'Edmonds', N'WA', N'98020', N'US', N'961-555-0122', NULL, NULL, NULL, NULL, 1, NULL, 225) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ranjit0', N'Sales', N'134219713', N'ranjit0@adventure-works.com', N'Varkey Chudukatil', N'Ranjit', NULL, N'94, rue Descartes', N'Bordeaux', N'33 ', N'33000', N'FR', N'1 (11) 500 555-0117', NULL, NULL, NULL, NULL, 1, NULL, 226) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'raymond0', N'Production', N'97728960', N'raymond0@adventure-works.com', N'Sam', N'Raymond', NULL, N'9784 Mt Etna Drive', N'Edmonds', N'WA', N'98020', N'US', N'226-555-0197', NULL, NULL, NULL, NULL, 1, NULL, 227) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'rebecca0', N'Production', N'330211482', N'rebecca0@adventure-works.com', N'Laszlo', N'Rebecca', NULL, N'3197 Thornhill Place', N'Bellevue', N'WA', N'98004', N'US', N'314-555-0113', NULL, NULL, NULL, NULL, 1, NULL, 228) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'reed0', N'Production', N'259388196', N'reed0@adventure-works.com', N'Koch', N'Reed', NULL, N'1275 West Street', N'Redmond', N'WA', N'98052', N'US', N'678-555-0110', NULL, NULL, NULL, NULL, 1, NULL, 229) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'reinout0', N'Purchasing', N'280633567', N'reinout0@adventure-works.com', N'Hillmann', N'Reinout', NULL, N'620 Woodside Ct.', N'Bellevue', N'WA', N'98004', N'US', N'370-555-0163', NULL, NULL, NULL, NULL, 1, NULL, 230) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'reuben0', N'Production', N'370989364', N'reuben0@adventure-works.com', N'D''sa', N'Reuben', NULL, N'1064 Slow Creek Road', N'Seattle', N'WA', N'98104', N'US', N'191-555-0112', NULL, NULL, NULL, NULL, 1, NULL, 231) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'rob0', N'Engineering', N'112457891', N'rob0@adventure-works.com', N'Walters', N'Rob', NULL, N'5678 Lakeview Blvd.', N'Minneapolis', N'MN ', N'55402', N'US', N'612-555-0100', NULL, NULL, NULL, NULL, 1, NULL, 232) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'rob0', N'Tool Design', N'112457891', N'rob0@adventure-works.com', N'Walters', N'Rob', NULL, N'5678 Lakeview Blvd.', N'Minneapolis', N'MN ', N'55402', N'US', N'612-555-0100', NULL, NULL, NULL, NULL, 1, NULL, 233) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'rob1', N'Production', N'578953538', N'rob1@adventure-works.com', N'Caron', N'Rob', NULL, N'5030 Blue Ridge Dr.', N'Monroe', N'WA', N'98272', N'US', N'238-555-0116', NULL, NULL, NULL, NULL, 1, NULL, 234) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'robert0', N'Production', N'456839592', N'robert0@adventure-works.com', N'Rounthwaite', N'Robert', NULL, N'6843 San Simeon Dr.', N'Seattle', N'WA', N'98104', N'US', N'589-555-0147', NULL, NULL, NULL, NULL, 1, NULL, 235) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'roberto0', N'Engineering', N'509647174', N'roberto0@adventure-works.com', N'Tamburello', N'Roberto', NULL, N'2137 Birchwood Dr', N'Redmond', N'WA', N'98052', N'US', N'212-555-0187', NULL, NULL, NULL, NULL, 1, NULL, 236) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'rostislav0', N'Production', N'993310268', N'rostislav0@adventure-works.com', N'Shabalin', N'Rostislav', NULL, N'3711 Rollingwood Dr', N'Bellevue', N'WA', N'98004', N'US', N'751-555-0134', NULL, NULL, NULL, NULL, 1, NULL, 237) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'russell0', N'Production', N'718299860', N'russell0@adventure-works.com', N'Hunter', N'Russell', NULL, N'7616 Honey Court', N'Seattle', N'WA', N'98104', N'US', N'786-555-0144', NULL, NULL, NULL, NULL, 1, NULL, 238) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'russell1', N'Production', N'551346974', N'russell1@adventure-works.com', N'King', N'Russell', NULL, N'3919 Pinto Road', N'Bellevue', N'WA', N'98004', N'US', N'517-555-0122', NULL, NULL, NULL, NULL, 1, NULL, 239) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ruth0', N'Production', N'690627818', N'ruth0@adventure-works.com', N'Ellerbrock', N'Ruth', NULL, N'2176 Apollo Way', N'Everett', N'WA', N'98201', N'US', N'145-555-0130', NULL, NULL, NULL, NULL, 1, NULL, 240) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'ryan0', N'Production', N'769680433', N'ryan0@adventure-works.com', N'Cornelsen', N'Ryan', NULL, N'177 11th Ave', N'Sammamish', N'WA', N'98074', N'US', N'208-555-0114', NULL, NULL, NULL, NULL, 1, NULL, 241) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sairaj0', N'Production Control', N'981495526', N'sairaj0@adventure-works.com', N'Uddin', N'Sairaj', NULL, N'8040 Hill Ct', N'Redmond', N'WA', N'98052', N'US', N'500-555-0159', NULL, NULL, NULL, NULL, 1, NULL, 242) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'samantha0', N'Production', N'25011600', N'samantha0@adventure-works.com', N'Smith', N'Samantha', NULL, N'1648 Eastgate Lane', N'Bellevue', N'WA', N'98004', N'US', N'587-555-0114', NULL, NULL, NULL, NULL, 1, NULL, 243) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sameer0', N'Production', N'152085091', N'sameer0@adventure-works.com', N'Tejani', N'Sameer', N'# 14', N'5379 Treasure Island Way', N'Duvall', N'WA', N'98019', N'US', N'990-555-0172', NULL, NULL, NULL, NULL, 1, NULL, 244) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sandeep0', N'Production', N'943170460', N'sandeep0@adventure-works.com', N'Kaliyath', N'Sandeep', NULL, N'4310 Kenston Dr.', N'Sammamish', N'WA', N'98074', N'US', N'166-555-0156', NULL, NULL, NULL, NULL, 1, NULL, 245) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sandra0', N'Production', N'604664374', N'sandra0@adventure-works.com', N'Re?tegui Alayo', N'Sandra', NULL, N'1619 Stillman Court', N'Seattle', N'WA', N'98104', N'US', N'896-555-0168', NULL, NULL, NULL, NULL, 1, NULL, 246) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sariya0', N'Marketing', N'95958330', N'sariya0@adventure-works.com', N'Harnpadoungsataya', N'Sariya', NULL, N'1185 Dallas Drive', N'Everett', N'WA', N'98201', N'US', N'399-555-0176', NULL, NULL, NULL, NULL, 1, NULL, 247) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'scott0', N'Production', N'199546871', N'scott0@adventure-works.com', N'Gode', N'Scott', NULL, N'7403 N. Broadway', N'Seattle', N'WA', N'98104', N'US', N'391-555-0138', NULL, NULL, NULL, NULL, 1, NULL, 248) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sean0', N'Quality Assurance', N'403414852', N'sean0@adventure-works.com', N'Alexander', N'Sean', NULL, N'7985 Center Street', N'Renton', N'WA', N'98055', N'US', N'420-555-0173', NULL, NULL, NULL, NULL, 1, NULL, 249) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sean1', N'Document Control', N'242381745', N'sean1@adventure-works.com', N'Chai', N'Sean', NULL, N'9314 Icicle Way', N'Issaquah', N'WA', N'98027', N'US', N'205-555-0132', NULL, NULL, NULL, NULL, 1, NULL, 250) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'shammi0', N'Production', N'370487086', N'shammi0@adventure-works.com', N'Mohamed', N'Shammi', NULL, N'332 Laguna Niguel', N'Bellevue', N'WA', N'98004', N'US', N'793-555-0179', NULL, NULL, NULL, NULL, 1, NULL, 251) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'shane0', N'Production', N'551834634', N'shane0@adventure-works.com', N'Kim', N'Shane', NULL, N'9745 Bonita Ct.', N'Bellevue', N'WA', N'98004', N'US', N'810-555-0178', NULL, NULL, NULL, NULL, 1, NULL, 252) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sharon0', N'Engineering', N'56920285', N'sharon0@adventure-works.com', N'Salavaria', N'Sharon', NULL, N'7165 Brock Lane', N'Renton', N'WA', N'98055', N'US', N'970-555-0138', NULL, NULL, NULL, NULL, 1, NULL, 253) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sheela0', N'Marketing', N'895209680', N'sheela0@adventure-works.com', N'Word', N'Sheela', NULL, N'535 Greendell Pl', N'Sammamish', N'WA', N'98074', N'US', N'210-555-0193', NULL, NULL, NULL, NULL, 1, NULL, 254) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sheela0', N'Purchasing', N'895209680', N'sheela0@adventure-works.com', N'Word', N'Sheela', NULL, N'535 Greendell Pl', N'Sammamish', N'WA', N'98074', N'US', N'210-555-0193', NULL, NULL, NULL, NULL, 1, NULL, 255) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sheela0', N'Quality Assurance', N'895209680', N'sheela0@adventure-works.com', N'Word', N'Sheela', NULL, N'535 Greendell Pl', N'Sammamish', N'WA', N'98074', N'US', N'210-555-0193', NULL, NULL, NULL, NULL, 1, NULL, 256) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'shelley0', N'Production', N'300946911', N'shelley0@adventure-works.com', N'Dyck', N'Shelley', NULL, N'3747 W. Landing Avenue', N'Monroe', N'WA', N'98272', N'US', N'991-555-0184', NULL, NULL, NULL, NULL, 1, NULL, 257) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'shu0', N'Sales', N'139397894', N'shu0@adventure-works.com', N'Ito', N'Shu', NULL, N'5725 Glaze Drive', N'San Francisco', N'CA ', N'94109', N'US', N'330-555-0120', NULL, NULL, NULL, NULL, 1, NULL, 258) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sidney0', N'Production', N'844973625', N'sidney0@adventure-works.com', N'Higa', N'Sidney', NULL, N'9277 Country View Lane', N'Edmonds', N'WA', N'98020', N'US', N'424-555-0189', NULL, NULL, NULL, NULL, 1, NULL, 259) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'simon0', N'Production', N'276751903', N'simon0@adventure-works.com', N'Rapier', N'Simon', NULL, N'3421 Bouncing Road', N'Duvall', N'WA', N'98019', N'US', N'963-555-0134', NULL, NULL, NULL, NULL, 1, NULL, 260) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sootha0', N'Quality Assurance', N'343861179', N'sootha0@adventure-works.com', N'Charncherngkha', N'Sootha', NULL, N'4155 Working Drive', N'Kenmore', N'WA', N'98028', N'US', N'325-555-0137', NULL, NULL, NULL, NULL, 1, NULL, 261) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'stefen0', N'Production', N'621932914', N'stefen0@adventure-works.com', N'Hesse', N'Stefen', NULL, N'8463 Vista Avenue', N'Duvall', N'WA', N'98019', N'US', N'165-555-0113', NULL, NULL, NULL, NULL, 1, NULL, 262) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'stephanie0', N'Information Services', N'858323870', N'stephanie0@adventure-works.com', N'Conroy', N'Stephanie', NULL, N'7435 Ricardo', N'Issaquah', N'WA', N'98027', N'US', N'594-555-0110', NULL, NULL, NULL, NULL, 1, NULL, 263) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'stephen0', N'Sales', N'502097814', N'stephen0@adventure-works.com', N'Jiang', N'Stephen', NULL, N'2427 Notre Dame Ave.', N'Redmond', N'WA', N'98052', N'US', N'238-555-0197', NULL, NULL, NULL, NULL, 1, NULL, 264) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'steve0', N'Production', N'752513276', N'steve0@adventure-works.com', N'Masters', N'Steve', NULL, N'1398 Yorba Linda', N'Seattle', N'WA', N'98104', N'US', N'712-555-0170', NULL, NULL, NULL, NULL, 1, NULL, 265) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'steven0', N'Production', N'443968955', N'steven0@adventure-works.com', N'Selikoff', N'Steven', NULL, N'181 Gaining Drive', N'Everett', N'WA', N'98201', N'US', N'925-555-0114', NULL, NULL, NULL, NULL, 1, NULL, 266) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'stuart0', N'Production', N'835460180', N'stuart0@adventure-works.com', N'Munson', N'Stuart', NULL, N'6448 Castle Court', N'Bellevue', N'WA', N'98004', N'US', N'413-555-0136', NULL, NULL, NULL, NULL, 1, NULL, 267) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'stuart1', N'Facilities and Maintenance', N'28414965', N'stuart1@adventure-works.com', N'Macrae', N'Stuart', NULL, N'2266 Greenwood Circle', N'Renton', N'WA', N'98055', N'US', N'539-555-0149', NULL, NULL, NULL, NULL, 1, NULL, 268) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'suchitra0', N'Production', N'754372876', N'suchitra0@adventure-works.com', N'Mohan', N'Suchitra', NULL, N'5678 Clear Court', N'Bellevue', N'WA', N'98004', N'US', N'753-555-0129', NULL, NULL, NULL, NULL, 1, NULL, 269) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'suroor0', N'Production', N'415823523', N'suroor0@adventure-works.com', N'Fatima', N'Suroor', NULL, N'3281 Hillview Dr.', N'Edmonds', N'WA', N'98020', N'US', N'932-555-0161', NULL, NULL, NULL, NULL, 1, NULL, 270) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'susan0', N'Shipping and Receiving', N'586486572', N'susan0@adventure-works.com', N'Eaton', N'Susan', NULL, N'2736 Scramble Rd', N'Renton', N'WA', N'98055', N'US', N'943-555-0196', NULL, NULL, NULL, NULL, 1, NULL, 271) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'susan1', N'Production', N'351069889', N'susan1@adventure-works.com', N'Metters', N'Susan', NULL, N'9104 Mt. Sequoia Ct.', N'Sammamish', N'WA', N'98074', N'US', N'639-555-0164', NULL, NULL, NULL, NULL, 1, NULL, 272) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'syed0', N'Sales', N'481044938', N'syed0@adventure-works.com', N'Abbas', N'Syed', NULL, N'7484 Roundtree Drive', N'Bothell', N'WA', N'98011', N'US', N'926-555-0182', NULL, NULL, NULL, NULL, 1, NULL, 273) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'sylvester0', N'Production', N'701156975', N'sylvester0@adventure-works.com', N'Valdez', N'Sylvester', N'Unit A', N'7902 Grammercy Lane', N'Bellevue', N'WA', N'98004', N'US', N'492-555-0174', NULL, NULL, NULL, NULL, 1, NULL, 274) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'tawana0', N'Production', N'436757988', N'tawana0@adventure-works.com', N'Nusbaum', N'Tawana', NULL, N'9964 North Ridge Drive', N'Seattle', N'WA', N'98104', N'US', N'368-555-0113', NULL, NULL, NULL, NULL, 1, NULL, 275) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'taylor0', N'Production', N'233069302', N'taylor0@adventure-works.com', N'Maxwell', N'Taylor', NULL, N'504 O St.', N'Edmonds', N'WA', N'98020', N'US', N'508-555-0165', NULL, NULL, NULL, NULL, 1, NULL, 276) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'tengiz0', N'Document Control', N'540688287', N'tengiz0@adventure-works.com', N'Kharatishvili', N'Tengiz', NULL, N'3333 Madhatter Circle', N'Issaquah', N'WA', N'98027', N'US', N'910-555-0116', NULL, NULL, NULL, NULL, 1, NULL, 277) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'terrence0', N'Production', N'404159499', N'terrence0@adventure-works.com', N'Earls', N'Terrence', NULL, N'6968 Wren Ave.', N'Bellevue', N'WA', N'98004', N'US', N'110-555-0115', NULL, NULL, NULL, NULL, 1, NULL, 278) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'terri0', N'Engineering', N'245797967', N'terri0@adventure-works.com', N'Duffy', N'Terri', NULL, N'7559 Worth Ct.', N'Renton', N'WA', N'98055', N'US', N'819-555-0175', NULL, NULL, NULL, NULL, 1, NULL, 279) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'terry0', N'Marketing', N'243322160', N'terry0@adventure-works.com', N'Eminhizer', N'Terry', NULL, N'8668 Via Neruda', N'Bellevue', N'WA', N'98004', N'US', N'138-555-0118', NULL, NULL, NULL, NULL, 1, NULL, 280) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'tester', N'Production Control', N'tester123', N'tester@adventure-works.com', N'Guy', N'Tester', NULL, N'2555 95th Ave NE', N'Kenmore', N'WA', N'98028', N'US', N'438-555-1111', NULL, NULL, NULL, NULL, 1, NULL, 296) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'tete0', N'Sales', N'90836195', N'tete0@adventure-works.com', N'Mensa-Annan', N'Tete', NULL, N'3997 Via De Luna', N'Cambridge', N'MA ', N'02139', N'US', N'615-555-0153', NULL, NULL, NULL, NULL, 1, NULL, 281) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'thierry0', N'Tool Design', N'480168528', N'thierry0@adventure-works.com', N'D''Hers', N'Thierry', NULL, N'1970 Napa Ct.', N'Bothell', N'WA', N'98011', N'US', N'168-555-0183', NULL, NULL, NULL, NULL, 1, NULL, 282) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'thomas0', N'Production', N'500412746', N'thomas0@adventure-works.com', N'Michaels', N'Thomas', NULL, N'7338 Green St.', N'Edmonds', N'WA', N'98020', N'US', N'278-555-0118', NULL, NULL, NULL, NULL, 1, NULL, 283) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'tom0', N'Production', N'826454897', N'tom0@adventure-works.com', N'Vande Velde', N'Tom', NULL, N'5242 Marvelle Ln.', N'Everett', N'WA', N'98201', N'US', N'295-555-0161', NULL, NULL, NULL, NULL, 1, NULL, 284) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'tsvi0', N'Sales', N'716374314', N'tsvi0@adventure-works.com', N'Reiter', N'Tsvi', NULL, N'8291 Crossbow Way', N'Memphis', N'TN ', N'38103', N'US', N'664-555-0112', NULL, NULL, NULL, NULL, 1, NULL, 285) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'vamsi0', N'Shipping and Receiving', N'337752649', N'vamsi0@adventure-works.com', N'Kuppa', N'Vamsi', NULL, N'9833 Mt. Dias Blv.', N'Bothell', N'WA', N'98011', N'US', N'937-555-0137', NULL, NULL, NULL, NULL, 1, NULL, 286) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'vidur0', N'Human Resources', N'264306399', N'vidur0@adventure-works.com', N'Luthra', N'Vidur', NULL, N'3030 Blackburn Ct.', N'Newport Hills', N'WA', N'98006', N'US', N'153-555-0186', NULL, NULL, NULL, NULL, 1, NULL, 287) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'wanida0', N'Marketing', N'323403273', N'wanida0@adventure-works.com', N'Benshoof', N'Wanida', NULL, N'6951 Harmony Way', N'Sammamish', N'WA', N'98074', N'US', N'708-555-0141', NULL, NULL, NULL, NULL, 1, NULL, 288) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'wendy0', N'Finance', N'121491555', N'wendy0@adventure-works.com', N'Kahn', N'Wendy', NULL, N'4525 Benedict Ct.', N'Sammamish', N'WA', N'98074', N'US', N'248-555-0134', NULL, NULL, NULL, NULL, 1, NULL, 289) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'william0', N'Production', N'621209647', N'william0@adventure-works.com', N'Vong', N'William', NULL, N'6774 Bonanza', N'Bellevue', N'WA', N'98004', N'US', N'148-555-0145', NULL, NULL, NULL, NULL, 1, NULL, 290) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'willis0', N'Human Resources', N'332040978', N'willis0@adventure-works.com', N'Johnson', N'Willis', NULL, N'5452 Corte Gilberto', N'Everett', N'WA', N'98201', N'US', N'778-555-0141', NULL, NULL, NULL, NULL, 1, NULL, 291) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'yuhong0', N'Production', N'319472946', N'yuhong0@adventure-works.com', N'Li', N'Yuhong', NULL, N'502 Alexander Pl.', N'Seattle', N'WA', N'98104', N'US', N'965-555-0155', NULL, NULL, NULL, NULL, 1, NULL, 292) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'yvonne0', N'Production', N'713403643', N'yvonne0@adventure-works.com', N'McKay', N'Yvonne', NULL, N'1962 Cotton Ct.', N'Everett', N'WA', N'98201', N'US', N'286-555-0189', NULL, NULL, NULL, NULL, 1, NULL, 293) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'zainal0', N'Document Control', N'345106466', N'zainal0@adventure-works.com', N'Arifin', N'Zainal', NULL, N'342 San Simeon', N'Issaquah', N'WA', N'98027', N'US', N'204-555-0115', NULL, NULL, NULL, NULL, 1, NULL, 294) INSERT dbo.dnn_[TE_AuthXP_SSO_User] ([UserName], [RoleName], [Password], [Email], [LastName], [FirstName], [Unit], [Street], [City], [Region], [PostalCode], [Country], [Telephone], [Cell], [Fax], [Website], [IM], [Approved], [DisplayName], [RecID]) VALUES (N'zheng0', N'Production', N'360868122', N'zheng0@adventure-works.com', N'Mu', N'Zheng', NULL, N'6578 Woodhaven Ln.', N'Seattle', N'WA', N'98104', N'US', N'113-555-0173', NULL, NULL, NULL, NULL, 1, NULL, 295) SET IDENTITY_INSERT dbo.dnn_[TE_AuthXP_SSO_User] OFF /****** Object: Table dbo.dnn_[TE_AuthXP_WSAuthToken] Script Date: 12/21/2011 13:42:40 ******/ SET ANSI_NULLS ON System.Data.SqlClient.SqlException: Incorrect syntax near 'TE_AuthXP_WSAuthToken'. Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[TE_AuthXP_WSAuthToken]') AND type in (N'U')) BEGIN CREATE TABLE dbo.dnn_[TE_AuthXP_WSAuthToken]( [AppKey] [uniqueidentifier] NULL, [AuthToken] [uniqueidentifier] NULL CONSTRAINT [DF_TE_AuthXP_WSAuthToken_AuthToken] DEFAULT (newid()), [DateCreated] [datetime] NULL CONSTRAINT [DF_TE_AuthXP_WSAuthToken_DateCreated] DEFAULT (getdate()), [Username] [nvarchar](150) NOT NULL, [AppName] [nvarchar](250) NULL, CONSTRAINT [PK_TE_AuthXP_WSAuthToken] PRIMARY KEY CLUSTERED ( [Username] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.dnn_sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'dbo.dnn_[TE_AuthXP_WSAuthToken_Write_to_Log]')) EXEC dbo.dnn_sp_executesql @statement = N' CREATE TRIGGER dbo.dnn_[TE_AuthXP_WSAuthToken_Write_to_Log] ON dbo.dnn_[TE_AuthXP_WSAuthToken] FOR INSERT, UPDATE, DELETE AS SET NOCOUNT ON BEGIN DECLARE @Action char(1) -- Determine Action Type IF EXISTS (SELECT * FROM inserted) IF EXISTS (SELECT * FROM deleted) SET @Action = ''U'' ELSE SET @Action = ''A'' ELSE SET @Action = ''D'' -- Update dnn_ioms database IF @Action = ''A'' INSERT INTO dbo.dnn_TE_AuthXP_WSAuthTokenLog (AppKey,AuthToken,DateCreated,Username,[Action]) SELECT AppKey,AuthToken,DateCreated,Username,@Action FROM Inserted ELSE IF @Action = ''U'' INSERT INTO dbo.dnn_TE_AuthXP_WSAuthTokenLog (AppKey,AuthToken,DateCreated,Username,[Action]) SELECT AppKey,AuthToken,DateCreated,Username,@Action FROM Inserted ELSE IF @Action = ''D'' INSERT INTO dbo.dnn_TE_AuthXP_WSAuthTokenLog (AppKey,AuthToken,DateCreated,Username,[Action]) SELECT AppKey,AuthToken,DateCreated,Username,@Action FROM deleted END RETURN ' System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.dnn_sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[pTE_AuthXP_WSTokenInfoGet]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.dnn_sp_executesql @statement = N' CREATE PROCEDURE dbo.dnn_[pTE_AuthXP_WSTokenInfoGet] @authtoken nvarchar(250) AS -- **************************************************************** -- ** Using for table TE_AuthXP_SSO_User -- *************************************************************** SELECT e.UserName, e.DisplayName, e.Email, e.LastName, e.FirstName, e.Telephone, a.AuthToken, Approved AS IsAuthenticated, e.PostalCode, e.Telephone, e.Cell, e.Fax, e.IM, e.Website, e.RoleName, e.Unit, e.Street, e.City, e.Region, e.Country, e.Approved FROM dbo.dnn_TE_AuthXP_SSO_User AS e INNER JOIN dbo.dnn_TE_AuthXP_WSAuthToken AS a ON e.UserName = a.Username WHERE a.AuthToken = @authtoken AND DATEDIFF(s,a.DateCreated,getdate()) < 60 ' END System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.dnn_sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[pTE_AuthXP_WSTokenInfoDel]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.dnn_sp_executesql @statement = N' CREATE PROCEDURE dbo.dnn_[pTE_AuthXP_WSTokenInfoDel] @authtoken nvarchar(250) AS DELETE FROM dbo.dnn_[TE_AuthXP_WSAuthToken] WHERE AuthToken = @authtoken ' END System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.dnn_sp_executesql'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.dnn_[pTE_AuthXP_WSAuthenReturnToken]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.dnn_sp_executesql @statement = N' CREATE PROCEDURE dbo.dnn_[pTE_AuthXP_WSAuthenReturnToken] @Username varchar(250), @Password varchar(250) AS DECLARE @retValue nvarChar(250), @AppName nvarchar(255) SET @AppName = ''AuthXP'' /****************** verify authentication ************************/ -- **************************************************************** -- ** Using for table TE_AuthXP_SSO_User -- *************************************************************** IF Exists( SELECT UserName FROM vTE_AuthXP_WSAuth WHERE UserName = @Username ) BEGIN DELETE FROM dbo.dnn_[TE_AuthXP_WSAuthToken] WHERE Username=@Username AND AppName=@AppName INSERT INTO dbo.dnn_[TE_AuthXP_WSAuthToken] ([Username],[AuthToken],[DateCreated],[AppName]) VALUES ( @Username,newid(),getdate(), @AppName ) SELECT @retValue = CAST(AuthToken as varchar(250)) FROM dbo.dnn_TE_AuthXP_WSAuthToken WHERE (AppName = @AppName) AND (Username = @Username) END ELSE BEGIN SELECT @retValue = ''Login Fail'' END SELECT @retValue AS AuthToken ' END |
| Info |
End Sql execution: 11.04.01.SqlDataProvider file |
| Info |
Finished Sql execution |
| Failure |
Installation Failed - Script |
| Info |
Installation Failed - ICPC-TE-AuthXP |
| Info |
Deleted temporary install folder |
| EndJob |
Installation Failed |
Can anybody tell me what I am doing wrong please ?
Regards
JHF
|
| |
|
|