System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'VTemp' in the database. CREATE VIEW VTemp AS SELECT CustomerID AS ID, FNameen + ' ' + LNameen AS Full_Name, FNameen + ' ' + LNameen AS MLName, LNameen + ' ' + FNameen AS SortName, ShortDesc, (SELECT TOP 1 C.Titleen FROM map_SoldierDetails ms LEFT JOIN Category C ON ms.CatID = C.ID WHERE C.MasterID = 5953 AND ms.CustID = CustomerID ) AS ArmyTitle, (SELECT TOP 1 C.Titleen FROM map_SoldierDetails ms LEFT JOIN Category C ON ms.CatID = C.ID WHERE C.MasterID = 5962 AND ms.CustID = CustomerID ) AS ResTitle, (SELECT TOP 1 C.Titleen FROM map_SoldierDetails ms LEFT JOIN Category C ON ms.CatID = C.ID WHERE C.MasterID = 5967 AND ms.CustID = CustomerID ) AS PartTitle FROM SoldierDetails S inner join STCustomers C on S.CustomerID=C.UserID WHERE C.active=1 and (FNameen LIKE 'E%' OR LNameen LIKE 'E%' OR PreviousLNameen LIKE 'E%' ) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at warriors.searchByLetter() in c:\inetpub\vhosts\jwmww2.org\httpdocs\warriors.aspx.cs:line 450 ClientConnectionId:446ad428-f0d6-4e3c-8272-2702b6f2494b Error Number:2714,State:3,Class:16
System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at SiteFunc.debugs(Object o) in c:\inetpub\vhosts\jwmww2.org\httpdocs\App_Code\SiteFunc.cs:line 373 at warriors.searchByLetter() in c:\inetpub\vhosts\jwmww2.org\httpdocs\warriors.aspx.cs:line 464 at warriors.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\jwmww2.org\httpdocs\warriors.aspx.cs:line 101