Andy's Thoughts

The following SQL statement produced an error:

set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs

ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedCustomerKey1′

The following SQL statement produced an error:

set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs

ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedPriceLevelKey1′ in the database.

The following SQL statement produced an error:

set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs

ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedSalespersonKey1′ in the database.

The following SQL statement produced an error:

set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs

ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSCustomer1′ in the database.

The following SQL statement produced an error:

set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs

ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSPriceLevel1′ in the database.

The following SQL statement produced an error:

set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs

ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSSalesperson1′ in the database.

Upgrade of database: SG failed! Microsoft Dynamics GP Utilities will now shutdown.

The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedCustomerKey1′
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedPriceLevelKey1′ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSChangedSalespersonKey1′ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSCustomer1′ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSPriceLevel1′ in the database.
The following SQL statement produced an error: set nocount on  declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for   select DOCTYPE from eConnect_Out_Setup (nolock) where MAIN = 1 and DOCTYPE not like ‘%GetList’  open taCreateRequesterProcs fetch next from taCreateRequesterProcs into @NAME while (@@fetch_status <> -1) begin  if (@@fetch_status <> -2)  begin  select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 0′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 1′  exec (@TEXT)   select @TEXT = ‘exec eConnectOutCreate ‘+ @NAME + ‘, 2′  exec (@TEXT)  end   fetch next from taCreateRequesterProcs into @NAME end  deallocate taCreateRequesterProcs
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named ‘taRequesterWSSalesperson1′ in the database.
Upgrade of database: NN failed! Microsoft Dynamics GP Utilities will now shutdown.

I have only run into one issue on my new iPhone 4S, when trying to delete email on an IMAP email account I get the “unable to move message” error. Here is how I solved this problem.

To cure your “Unable to move Message” on your iOS 5 device follow the following steps:
Settings → Mail → click on the offending email account → click on account → advanced → deleted mailbox → then touch the Trash icon “on the server”

Note that these directions are for IMAP servers. They should work for POP3 email accounts also, however instead of choosing the server based trash, chose the trash folder on your phone.