Command #: 1
Timestamp: 2007-01-24 10:08:52.713
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Password=eti911pc;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: SELECT TOP 1000 [SQLGUID], [Dept], [EventNo], [DescText], [PathOf], [HeaderDetail], [ExcludeCaseMgt], [SymbolName], [FName], [FSize], [FColor], [FStyle], [FCharSet], [FIndex], [SOP], [SQLRegionID], [SQLLastUpdated], [SQLIPAddress], [SQLEmployeeID] FROM [dbo].[IncdType] WHERE [Dept] = @PARAM0;
Command Parameters
@PARAM0: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: | SourceVersion: Current]
Command #: 2
Timestamp: 2007-01-24 10:12:02.931
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK AND (([SQLGUID] = @SQLGUID_ORG) OR ((@SQLGUID_ORG IS NULL) AND ([SQLGUID] IS NULL))) AND (([Dept] = @Dept_ORG) OR ((@Dept_ORG IS NULL) AND ([Dept] IS NULL))) AND (([EventNo] = @EventNo_ORG) OR ((@EventNo_ORG IS NULL) AND ([EventNo] IS NULL))) AND (([DescText] = @DescText_ORG) OR ((@DescText_ORG IS NULL) AND ([DescText] IS NULL))) AND (([PathOf] = @PathOf_ORG) OR ((@PathOf_ORG IS NULL) AND ([PathOf] IS NULL))) AND (([HeaderDetail] = @HeaderDetail_ORG) OR ((@HeaderDetail_ORG IS NULL) AND ([HeaderDetail] IS NULL))) AND (([ExcludeCaseMgt] = @ExcludeCaseMgt_ORG) OR ((@ExcludeCaseMgt_ORG IS NULL) AND ([ExcludeCaseMgt] IS NULL))) AND (([SymbolName] = @SymbolName_ORG) OR ((@SymbolName_ORG IS NULL) AND ([SymbolName] IS NULL))) AND (([FName] = @FName_ORG) OR ((@FName_ORG IS NULL) AND ([FName] IS NULL))) AND (([FSize] = @FSize_ORG) OR ((@FSize_ORG IS NULL) AND ([FSize] IS NULL))) AND (([FColor] = @FColor_ORG) OR ((@FColor_ORG IS NULL) AND ([FColor] IS NULL))) AND (([FStyle] = @FStyle_ORG) OR ((@FStyle_ORG IS NULL) AND ([FStyle] IS NULL))) AND (([FCharSet] = @FCharSet_ORG) OR ((@FCharSet_ORG IS NULL) AND ([FCharSet] IS NULL))) AND (([FIndex] = @FIndex_ORG) OR ((@FIndex_ORG IS NULL) AND ([FIndex] IS NULL))) AND (([SOP] LIKE @SOP_ORG) OR ((@SOP_ORG IS NULL) AND ([SOP] IS NULL))) AND (([SQLRegionID] = @SQLRegionID_ORG) OR ((@SQLRegionID_ORG IS NULL) AND ([SQLRegionID] IS NULL))) AND (([SQLLastUpdated] = @SQLLastUpdated_ORG) OR ((@SQLLastUpdated_ORG IS NULL) AND ([SQLLastUpdated] IS NULL))) AND (([SQLIPAddress] = @SQLIPAddress_ORG) OR ((@SQLIPAddress_ORG IS NULL) AND ([SQLIPAddress] IS NULL))) AND (([SQLEmployeeID] = @SQLEmployeeID_ORG) OR ((@SQLEmployeeID_ORG IS NULL) AND ([SQLEmployeeID] IS NULL)));
Command Parameters
@SQLGUID: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 9:31:51 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@SQLGUID_ORG: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@Dept_ORG: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Original]
@EventNo_ORG: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Original]
@DescText_ORG: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Original]
@PathOf_ORG: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Original]
@HeaderDetail_ORG: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Original]
@ExcludeCaseMgt_ORG: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Original]
@SymbolName_ORG: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Original]
@FName_ORG: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Original]
@FSize_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Original]
@FColor_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Original]
@FStyle_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Original]
@FCharSet_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Original]
@FIndex_ORG: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Original]
@SOP_ORG: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Original]
@SQLRegionID_ORG: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Original]
@SQLLastUpdated_ORG: '1/24/2007 9:31:51 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Original]
@SQLIPAddress_ORG: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Original]
@SQLEmployeeID_ORG: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Original]
Command #: 3
Timestamp: 2007-01-24 10:12:07.181
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK AND (([SQLGUID] = @SQLGUID_ORG) OR ((@SQLGUID_ORG IS NULL) AND ([SQLGUID] IS NULL))) AND (([Dept] = @Dept_ORG) OR ((@Dept_ORG IS NULL) AND ([Dept] IS NULL))) AND (([EventNo] = @EventNo_ORG) OR ((@EventNo_ORG IS NULL) AND ([EventNo] IS NULL))) AND (([DescText] = @DescText_ORG) OR ((@DescText_ORG IS NULL) AND ([DescText] IS NULL))) AND (([PathOf] = @PathOf_ORG) OR ((@PathOf_ORG IS NULL) AND ([PathOf] IS NULL))) AND (([HeaderDetail] = @HeaderDetail_ORG) OR ((@HeaderDetail_ORG IS NULL) AND ([HeaderDetail] IS NULL))) AND (([ExcludeCaseMgt] = @ExcludeCaseMgt_ORG) OR ((@ExcludeCaseMgt_ORG IS NULL) AND ([ExcludeCaseMgt] IS NULL))) AND (([SymbolName] = @SymbolName_ORG) OR ((@SymbolName_ORG IS NULL) AND ([SymbolName] IS NULL))) AND (([FName] = @FName_ORG) OR ((@FName_ORG IS NULL) AND ([FName] IS NULL))) AND (([FSize] = @FSize_ORG) OR ((@FSize_ORG IS NULL) AND ([FSize] IS NULL))) AND (([FColor] = @FColor_ORG) OR ((@FColor_ORG IS NULL) AND ([FColor] IS NULL))) AND (([FStyle] = @FStyle_ORG) OR ((@FStyle_ORG IS NULL) AND ([FStyle] IS NULL))) AND (([FCharSet] = @FCharSet_ORG) OR ((@FCharSet_ORG IS NULL) AND ([FCharSet] IS NULL))) AND (([FIndex] = @FIndex_ORG) OR ((@FIndex_ORG IS NULL) AND ([FIndex] IS NULL))) AND (([SOP] LIKE @SOP_ORG) OR ((@SOP_ORG IS NULL) AND ([SOP] IS NULL))) AND (([SQLRegionID] = @SQLRegionID_ORG) OR ((@SQLRegionID_ORG IS NULL) AND ([SQLRegionID] IS NULL))) AND (([SQLLastUpdated] = @SQLLastUpdated_ORG) OR ((@SQLLastUpdated_ORG IS NULL) AND ([SQLLastUpdated] IS NULL))) AND (([SQLIPAddress] = @SQLIPAddress_ORG) OR ((@SQLIPAddress_ORG IS NULL) AND ([SQLIPAddress] IS NULL))) AND (([SQLEmployeeID] = @SQLEmployeeID_ORG) OR ((@SQLEmployeeID_ORG IS NULL) AND ([SQLEmployeeID] IS NULL)));
Command Parameters
@SQLGUID: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 9:31:51 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@SQLGUID_ORG: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@Dept_ORG: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Original]
@EventNo_ORG: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Original]
@DescText_ORG: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Original]
@PathOf_ORG: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Original]
@HeaderDetail_ORG: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Original]
@ExcludeCaseMgt_ORG: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Original]
@SymbolName_ORG: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Original]
@FName_ORG: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Original]
@FSize_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Original]
@FColor_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Original]
@FStyle_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Original]
@FCharSet_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Original]
@FIndex_ORG: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Original]
@SOP_ORG: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Original]
@SQLRegionID_ORG: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Original]
@SQLLastUpdated_ORG: '1/24/2007 9:31:51 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Original]
@SQLIPAddress_ORG: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Original]
@SQLEmployeeID_ORG: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Original]
Command #: 4
Timestamp: 2007-01-24 10:12:07.197
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Password=eti911pc;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: SELECT [SQLGUID], [Dept], [EventNo], [DescText], [PathOf], [HeaderDetail], [ExcludeCaseMgt], [SymbolName], [FName], [FSize], [FColor], [FStyle], [FCharSet], [FIndex], [SOP], [SQLRegionID], [SQLLastUpdated], [SQLIPAddress], [SQLEmployeeID] FROM [dbo].[IncdType] WHERE ((SQLGUID = @PARAM0));
Command Parameters
@PARAM0: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: | SourceVersion: Current]
Command #: 5
Timestamp: 2007-01-24 10:12:08.431
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK;
Command Parameters
@SQLGUID: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 10:12:04 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
Command #: 6
Timestamp: 2007-01-24 10:12:14.649
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK AND (([SQLGUID] = @SQLGUID_ORG) OR ((@SQLGUID_ORG IS NULL) AND ([SQLGUID] IS NULL))) AND (([Dept] = @Dept_ORG) OR ((@Dept_ORG IS NULL) AND ([Dept] IS NULL))) AND (([EventNo] = @EventNo_ORG) OR ((@EventNo_ORG IS NULL) AND ([EventNo] IS NULL))) AND (([DescText] = @DescText_ORG) OR ((@DescText_ORG IS NULL) AND ([DescText] IS NULL))) AND (([PathOf] = @PathOf_ORG) OR ((@PathOf_ORG IS NULL) AND ([PathOf] IS NULL))) AND (([HeaderDetail] = @HeaderDetail_ORG) OR ((@HeaderDetail_ORG IS NULL) AND ([HeaderDetail] IS NULL))) AND (([ExcludeCaseMgt] = @ExcludeCaseMgt_ORG) OR ((@ExcludeCaseMgt_ORG IS NULL) AND ([ExcludeCaseMgt] IS NULL))) AND (([SymbolName] = @SymbolName_ORG) OR ((@SymbolName_ORG IS NULL) AND ([SymbolName] IS NULL))) AND (([FName] = @FName_ORG) OR ((@FName_ORG IS NULL) AND ([FName] IS NULL))) AND (([FSize] = @FSize_ORG) OR ((@FSize_ORG IS NULL) AND ([FSize] IS NULL))) AND (([FColor] = @FColor_ORG) OR ((@FColor_ORG IS NULL) AND ([FColor] IS NULL))) AND (([FStyle] = @FStyle_ORG) OR ((@FStyle_ORG IS NULL) AND ([FStyle] IS NULL))) AND (([FCharSet] = @FCharSet_ORG) OR ((@FCharSet_ORG IS NULL) AND ([FCharSet] IS NULL))) AND (([FIndex] = @FIndex_ORG) OR ((@FIndex_ORG IS NULL) AND ([FIndex] IS NULL))) AND (([SOP] LIKE @SOP_ORG) OR ((@SOP_ORG IS NULL) AND ([SOP] IS NULL))) AND (([SQLRegionID] = @SQLRegionID_ORG) OR ((@SQLRegionID_ORG IS NULL) AND ([SQLRegionID] IS NULL))) AND (([SQLLastUpdated] = @SQLLastUpdated_ORG) OR ((@SQLLastUpdated_ORG IS NULL) AND ([SQLLastUpdated] IS NULL))) AND (([SQLIPAddress] = @SQLIPAddress_ORG) OR ((@SQLIPAddress_ORG IS NULL) AND ([SQLIPAddress] IS NULL))) AND (([SQLEmployeeID] = @SQLEmployeeID_ORG) OR ((@SQLEmployeeID_ORG IS NULL) AND ([SQLEmployeeID] IS NULL)));
Command Parameters
@SQLGUID: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'ACCD' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 10:12:04 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@SQLGUID_ORG: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@Dept_ORG: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Original]
@EventNo_ORG: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Original]
@DescText_ORG: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Original]
@PathOf_ORG: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Original]
@HeaderDetail_ORG: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Original]
@ExcludeCaseMgt_ORG: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Original]
@SymbolName_ORG: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Original]
@FName_ORG: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Original]
@FSize_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Original]
@FColor_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Original]
@FStyle_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Original]
@FCharSet_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Original]
@FIndex_ORG: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Original]
@SOP_ORG: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Original]
@SQLRegionID_ORG: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Original]
@SQLLastUpdated_ORG: '1/24/2007 10:12:04 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Original]
@SQLIPAddress_ORG: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Original]
@SQLEmployeeID_ORG: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Original]
Command #: 7
Timestamp: 2007-01-24 10:12:14.649
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Password=eti911pc;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: SELECT [SQLGUID], [Dept], [EventNo], [DescText], [PathOf], [HeaderDetail], [ExcludeCaseMgt], [SymbolName], [FName], [FSize], [FColor], [FStyle], [FCharSet], [FIndex], [SOP], [SQLRegionID], [SQLLastUpdated], [SQLIPAddress], [SQLEmployeeID] FROM [dbo].[IncdType] WHERE ((SQLGUID = @PARAM0));
Command Parameters
@PARAM0: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: | SourceVersion: Current]
Command #: 8
Timestamp: 2007-01-24 10:12:15.837
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK;
Command Parameters
@SQLGUID: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'ACCD' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 10:12:09 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
Command #: 9
Timestamp: 2007-01-24 10:12:22.883
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK AND (([SQLGUID] = @SQLGUID_ORG) OR ((@SQLGUID_ORG IS NULL) AND ([SQLGUID] IS NULL))) AND (([Dept] = @Dept_ORG) OR ((@Dept_ORG IS NULL) AND ([Dept] IS NULL))) AND (([EventNo] = @EventNo_ORG) OR ((@EventNo_ORG IS NULL) AND ([EventNo] IS NULL))) AND (([DescText] = @DescText_ORG) OR ((@DescText_ORG IS NULL) AND ([DescText] IS NULL))) AND (([PathOf] = @PathOf_ORG) OR ((@PathOf_ORG IS NULL) AND ([PathOf] IS NULL))) AND (([HeaderDetail] = @HeaderDetail_ORG) OR ((@HeaderDetail_ORG IS NULL) AND ([HeaderDetail] IS NULL))) AND (([ExcludeCaseMgt] = @ExcludeCaseMgt_ORG) OR ((@ExcludeCaseMgt_ORG IS NULL) AND ([ExcludeCaseMgt] IS NULL))) AND (([SymbolName] = @SymbolName_ORG) OR ((@SymbolName_ORG IS NULL) AND ([SymbolName] IS NULL))) AND (([FName] = @FName_ORG) OR ((@FName_ORG IS NULL) AND ([FName] IS NULL))) AND (([FSize] = @FSize_ORG) OR ((@FSize_ORG IS NULL) AND ([FSize] IS NULL))) AND (([FColor] = @FColor_ORG) OR ((@FColor_ORG IS NULL) AND ([FColor] IS NULL))) AND (([FStyle] = @FStyle_ORG) OR ((@FStyle_ORG IS NULL) AND ([FStyle] IS NULL))) AND (([FCharSet] = @FCharSet_ORG) OR ((@FCharSet_ORG IS NULL) AND ([FCharSet] IS NULL))) AND (([FIndex] = @FIndex_ORG) OR ((@FIndex_ORG IS NULL) AND ([FIndex] IS NULL))) AND (([SOP] LIKE @SOP_ORG) OR ((@SOP_ORG IS NULL) AND ([SOP] IS NULL))) AND (([SQLRegionID] = @SQLRegionID_ORG) OR ((@SQLRegionID_ORG IS NULL) AND ([SQLRegionID] IS NULL))) AND (([SQLLastUpdated] = @SQLLastUpdated_ORG) OR ((@SQLLastUpdated_ORG IS NULL) AND ([SQLLastUpdated] IS NULL))) AND (([SQLIPAddress] = @SQLIPAddress_ORG) OR ((@SQLIPAddress_ORG IS NULL) AND ([SQLIPAddress] IS NULL))) AND (([SQLEmployeeID] = @SQLEmployeeID_ORG) OR ((@SQLEmployeeID_ORG IS NULL) AND ([SQLEmployeeID] IS NULL)));
Command Parameters
@SQLGUID: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 10:12:09 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@SQLGUID_ORG: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@Dept_ORG: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Original]
@EventNo_ORG: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Original]
@DescText_ORG: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Original]
@PathOf_ORG: 'ACCD' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Original]
@HeaderDetail_ORG: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Original]
@ExcludeCaseMgt_ORG: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Original]
@SymbolName_ORG: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Original]
@FName_ORG: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Original]
@FSize_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Original]
@FColor_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Original]
@FStyle_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Original]
@FCharSet_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Original]
@FIndex_ORG: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Original]
@SOP_ORG: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Original]
@SQLRegionID_ORG: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Original]
@SQLLastUpdated_ORG: '1/24/2007 10:12:09 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Original]
@SQLIPAddress_ORG: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Original]
@SQLEmployeeID_ORG: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Original]
Command #: 10
Timestamp: 2007-01-24 10:12:22.898
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Password=eti911pc;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: SELECT [SQLGUID], [Dept], [EventNo], [DescText], [PathOf], [HeaderDetail], [ExcludeCaseMgt], [SymbolName], [FName], [FSize], [FColor], [FStyle], [FCharSet], [FIndex], [SOP], [SQLRegionID], [SQLLastUpdated], [SQLIPAddress], [SQLEmployeeID] FROM [dbo].[IncdType] WHERE ((SQLGUID = @PARAM0));
Command Parameters
@PARAM0: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: | SourceVersion: Current]
Command #: 11
Timestamp: 2007-01-24 10:12:24.383
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK;
Command Parameters
@SQLGUID: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 10:12:09 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
Command #: 12
Timestamp: 2007-01-24 10:12:32.773
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK AND (([SQLGUID] = @SQLGUID_ORG) OR ((@SQLGUID_ORG IS NULL) AND ([SQLGUID] IS NULL))) AND (([Dept] = @Dept_ORG) OR ((@Dept_ORG IS NULL) AND ([Dept] IS NULL))) AND (([EventNo] = @EventNo_ORG) OR ((@EventNo_ORG IS NULL) AND ([EventNo] IS NULL))) AND (([DescText] = @DescText_ORG) OR ((@DescText_ORG IS NULL) AND ([DescText] IS NULL))) AND (([PathOf] = @PathOf_ORG) OR ((@PathOf_ORG IS NULL) AND ([PathOf] IS NULL))) AND (([HeaderDetail] = @HeaderDetail_ORG) OR ((@HeaderDetail_ORG IS NULL) AND ([HeaderDetail] IS NULL))) AND (([ExcludeCaseMgt] = @ExcludeCaseMgt_ORG) OR ((@ExcludeCaseMgt_ORG IS NULL) AND ([ExcludeCaseMgt] IS NULL))) AND (([SymbolName] = @SymbolName_ORG) OR ((@SymbolName_ORG IS NULL) AND ([SymbolName] IS NULL))) AND (([FName] = @FName_ORG) OR ((@FName_ORG IS NULL) AND ([FName] IS NULL))) AND (([FSize] = @FSize_ORG) OR ((@FSize_ORG IS NULL) AND ([FSize] IS NULL))) AND (([FColor] = @FColor_ORG) OR ((@FColor_ORG IS NULL) AND ([FColor] IS NULL))) AND (([FStyle] = @FStyle_ORG) OR ((@FStyle_ORG IS NULL) AND ([FStyle] IS NULL))) AND (([FCharSet] = @FCharSet_ORG) OR ((@FCharSet_ORG IS NULL) AND ([FCharSet] IS NULL))) AND (([FIndex] = @FIndex_ORG) OR ((@FIndex_ORG IS NULL) AND ([FIndex] IS NULL))) AND (([SOP] LIKE @SOP_ORG) OR ((@SOP_ORG IS NULL) AND ([SOP] IS NULL))) AND (([SQLRegionID] = @SQLRegionID_ORG) OR ((@SQLRegionID_ORG IS NULL) AND ([SQLRegionID] IS NULL))) AND (([SQLLastUpdated] = @SQLLastUpdated_ORG) OR ((@SQLLastUpdated_ORG IS NULL) AND ([SQLLastUpdated] IS NULL))) AND (([SQLIPAddress] = @SQLIPAddress_ORG) OR ((@SQLIPAddress_ORG IS NULL) AND ([SQLIPAddress] IS NULL))) AND (([SQLEmployeeID] = @SQLEmployeeID_ORG) OR ((@SQLEmployeeID_ORG IS NULL) AND ([SQLEmployeeID] IS NULL)));
Command Parameters
@SQLGUID: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP123' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'ACCD' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 10:12:09 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@SQLGUID_ORG: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@Dept_ORG: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Original]
@EventNo_ORG: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Original]
@DescText_ORG: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Original]
@PathOf_ORG: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Original]
@HeaderDetail_ORG: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Original]
@ExcludeCaseMgt_ORG: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Original]
@SymbolName_ORG: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Original]
@FName_ORG: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Original]
@FSize_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Original]
@FColor_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Original]
@FStyle_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Original]
@FCharSet_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Original]
@FIndex_ORG: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Original]
@SOP_ORG: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Original]
@SQLRegionID_ORG: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Original]
@SQLLastUpdated_ORG: '1/24/2007 10:12:09 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Original]
@SQLIPAddress_ORG: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Original]
@SQLEmployeeID_ORG: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Original]
Command #: 13
Timestamp: 2007-01-24 10:12:32.773
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Password=eti911pc;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: SELECT [SQLGUID], [Dept], [EventNo], [DescText], [PathOf], [HeaderDetail], [ExcludeCaseMgt], [SymbolName], [FName], [FSize], [FColor], [FStyle], [FCharSet], [FIndex], [SOP], [SQLRegionID], [SQLLastUpdated], [SQLIPAddress], [SQLEmployeeID] FROM [dbo].[IncdType] WHERE ((SQLGUID = @PARAM0));
Command Parameters
@PARAM0: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: | SourceVersion: Current]
Command #: 14
Timestamp: 2007-01-24 10:12:34.241
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK;
Command Parameters
@SQLGUID: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP123' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'ACCD' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 10:12:09 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
Command #: 15
Timestamp: 2007-01-24 10:12:42.84
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK AND (([SQLGUID] = @SQLGUID_ORG) OR ((@SQLGUID_ORG IS NULL) AND ([SQLGUID] IS NULL))) AND (([Dept] = @Dept_ORG) OR ((@Dept_ORG IS NULL) AND ([Dept] IS NULL))) AND (([EventNo] = @EventNo_ORG) OR ((@EventNo_ORG IS NULL) AND ([EventNo] IS NULL))) AND (([DescText] = @DescText_ORG) OR ((@DescText_ORG IS NULL) AND ([DescText] IS NULL))) AND (([PathOf] = @PathOf_ORG) OR ((@PathOf_ORG IS NULL) AND ([PathOf] IS NULL))) AND (([HeaderDetail] = @HeaderDetail_ORG) OR ((@HeaderDetail_ORG IS NULL) AND ([HeaderDetail] IS NULL))) AND (([ExcludeCaseMgt] = @ExcludeCaseMgt_ORG) OR ((@ExcludeCaseMgt_ORG IS NULL) AND ([ExcludeCaseMgt] IS NULL))) AND (([SymbolName] = @SymbolName_ORG) OR ((@SymbolName_ORG IS NULL) AND ([SymbolName] IS NULL))) AND (([FName] = @FName_ORG) OR ((@FName_ORG IS NULL) AND ([FName] IS NULL))) AND (([FSize] = @FSize_ORG) OR ((@FSize_ORG IS NULL) AND ([FSize] IS NULL))) AND (([FColor] = @FColor_ORG) OR ((@FColor_ORG IS NULL) AND ([FColor] IS NULL))) AND (([FStyle] = @FStyle_ORG) OR ((@FStyle_ORG IS NULL) AND ([FStyle] IS NULL))) AND (([FCharSet] = @FCharSet_ORG) OR ((@FCharSet_ORG IS NULL) AND ([FCharSet] IS NULL))) AND (([FIndex] = @FIndex_ORG) OR ((@FIndex_ORG IS NULL) AND ([FIndex] IS NULL))) AND (([SOP] LIKE @SOP_ORG) OR ((@SOP_ORG IS NULL) AND ([SOP] IS NULL))) AND (([SQLRegionID] = @SQLRegionID_ORG) OR ((@SQLRegionID_ORG IS NULL) AND ([SQLRegionID] IS NULL))) AND (([SQLLastUpdated] = @SQLLastUpdated_ORG) OR ((@SQLLastUpdated_ORG IS NULL) AND ([SQLLastUpdated] IS NULL))) AND (([SQLIPAddress] = @SQLIPAddress_ORG) OR ((@SQLIPAddress_ORG IS NULL) AND ([SQLIPAddress] IS NULL))) AND (([SQLEmployeeID] = @SQLEmployeeID_ORG) OR ((@SQLEmployeeID_ORG IS NULL) AND ([SQLEmployeeID] IS NULL)));
Command Parameters
@SQLGUID: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 10:12:09 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@SQLGUID_ORG: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@Dept_ORG: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Original]
@EventNo_ORG: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Original]
@DescText_ORG: '911 HANGUP123' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Original]
@PathOf_ORG: 'ACCD' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Original]
@HeaderDetail_ORG: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Original]
@ExcludeCaseMgt_ORG: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Original]
@SymbolName_ORG: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Original]
@FName_ORG: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Original]
@FSize_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Original]
@FColor_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Original]
@FStyle_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Original]
@FCharSet_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Original]
@FIndex_ORG: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Original]
@SOP_ORG: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Original]
@SQLRegionID_ORG: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Original]
@SQLLastUpdated_ORG: '1/24/2007 10:12:09 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Original]
@SQLIPAddress_ORG: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Original]
@SQLEmployeeID_ORG: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Original]
Command #: 16
Timestamp: 2007-01-24 10:12:42.100
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Password=eti911pc;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: SELECT [SQLGUID], [Dept], [EventNo], [DescText], [PathOf], [HeaderDetail], [ExcludeCaseMgt], [SymbolName], [FName], [FSize], [FColor], [FStyle], [FCharSet], [FIndex], [SOP], [SQLRegionID], [SQLLastUpdated], [SQLIPAddress], [SQLEmployeeID] FROM [dbo].[IncdType] WHERE ((SQLGUID = @PARAM0));
Command Parameters
@PARAM0: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: | SourceVersion: Current]
Command #: 17
Timestamp: 2007-01-24 10:12:44.256
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK;
Command Parameters
@SQLGUID: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 10:12:09 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
Command #: 18
Timestamp: 2007-01-24 10:12:57.114
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK AND (([SQLGUID] = @SQLGUID_ORG) OR ((@SQLGUID_ORG IS NULL) AND ([SQLGUID] IS NULL))) AND (([Dept] = @Dept_ORG) OR ((@Dept_ORG IS NULL) AND ([Dept] IS NULL))) AND (([EventNo] = @EventNo_ORG) OR ((@EventNo_ORG IS NULL) AND ([EventNo] IS NULL))) AND (([DescText] = @DescText_ORG) OR ((@DescText_ORG IS NULL) AND ([DescText] IS NULL))) AND (([PathOf] = @PathOf_ORG) OR ((@PathOf_ORG IS NULL) AND ([PathOf] IS NULL))) AND (([HeaderDetail] = @HeaderDetail_ORG) OR ((@HeaderDetail_ORG IS NULL) AND ([HeaderDetail] IS NULL))) AND (([ExcludeCaseMgt] = @ExcludeCaseMgt_ORG) OR ((@ExcludeCaseMgt_ORG IS NULL) AND ([ExcludeCaseMgt] IS NULL))) AND (([SymbolName] = @SymbolName_ORG) OR ((@SymbolName_ORG IS NULL) AND ([SymbolName] IS NULL))) AND (([FName] = @FName_ORG) OR ((@FName_ORG IS NULL) AND ([FName] IS NULL))) AND (([FSize] = @FSize_ORG) OR ((@FSize_ORG IS NULL) AND ([FSize] IS NULL))) AND (([FColor] = @FColor_ORG) OR ((@FColor_ORG IS NULL) AND ([FColor] IS NULL))) AND (([FStyle] = @FStyle_ORG) OR ((@FStyle_ORG IS NULL) AND ([FStyle] IS NULL))) AND (([FCharSet] = @FCharSet_ORG) OR ((@FCharSet_ORG IS NULL) AND ([FCharSet] IS NULL))) AND (([FIndex] = @FIndex_ORG) OR ((@FIndex_ORG IS NULL) AND ([FIndex] IS NULL))) AND (([SOP] LIKE @SOP_ORG) OR ((@SOP_ORG IS NULL) AND ([SOP] IS NULL))) AND (([SQLRegionID] = @SQLRegionID_ORG) OR ((@SQLRegionID_ORG IS NULL) AND ([SQLRegionID] IS NULL))) AND (([SQLLastUpdated] = @SQLLastUpdated_ORG) OR ((@SQLLastUpdated_ORG IS NULL) AND ([SQLLastUpdated] IS NULL))) AND (([SQLIPAddress] = @SQLIPAddress_ORG) OR ((@SQLIPAddress_ORG IS NULL) AND ([SQLIPAddress] IS NULL))) AND (([SQLEmployeeID] = @SQLEmployeeID_ORG) OR ((@SQLEmployeeID_ORG IS NULL) AND ([SQLEmployeeID] IS NULL)));
Command Parameters
@SQLGUID: '00000000-0000-0000-0000-000000000000' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/24/2007 10:12:46 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: 'Ben' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@SQLGUID_ORG: 'caad2ad4-b8fc-444a-b432-77e2c444a783' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@Dept_ORG: '1' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Original]
@EventNo_ORG: '911' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Original]
@DescText_ORG: '911 HANGUP' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Original]
@PathOf_ORG: 'FULL' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Original]
@HeaderDetail_ORG: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Original]
@ExcludeCaseMgt_ORG: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Original]
@SymbolName_ORG: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Original]
@FName_ORG: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Original]
@FSize_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Original]
@FColor_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Original]
@FStyle_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Original]
@FCharSet_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Original]
@FIndex_ORG: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Original]
@SOP_ORG: ' Attempt a callback to the number. If contact is established:        Determine whether assistance is needed.        Take appropritate action. If there is a busy signal, call back . If you make contact, state that you are calling for the 911 Center and you recevied a hang up call from this residence.   Determine whether assistance is needed. Take appropriate action. If the line continues to be busy or there is no answer, dispatch two officers to the location. When receiving a call where the line remains open, stay on the line until officers arrive or the phone is hung up.  Listen for any sounds that may help determine thee is a problem and what it might be.' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Original]
@SQLRegionID_ORG: '' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Original]
@SQLLastUpdated_ORG: '1/24/2007 10:12:09 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Original]
@SQLIPAddress_ORG: '000BDBBF5CD2' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Original]
@SQLEmployeeID_ORG: 'BEN       ' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Original]
Command #: 19
Timestamp: 2007-01-24 10:12:57.114
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Password=eti911pc;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: SELECT [SQLGUID], [Dept], [EventNo], [DescText], [PathOf], [HeaderDetail], [ExcludeCaseMgt], [SymbolName], [FName], [FSize], [FColor], [FStyle], [FCharSet], [FIndex], [SOP], [SQLRegionID], [SQLLastUpdated], [SQLIPAddress], [SQLEmployeeID] FROM [dbo].[IncdType] WHERE ((SQLGUID = @PARAM0));
Command Parameters
@PARAM0: '00000000-0000-0000-0000-000000000000' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: | SourceVersion: Current]