Hi,

I moved one of my websites to a new server and all of the scheduled task are still showing the old server name checked to "Run on Servers"

Under Host settings the new server name is showing and correct. How do I clear the old server name and add the new one to my scheduled. Should I delete the task and then re-create? Under Performance I have Page persistence, Module cache set to File, Cache setting set to Heavy, Authenticated Cache set to Server and No Cache, no compression.

 Scheduler mode set to Timer and Event Log Buffer is not checked. Any help is greatly appreciated.

Thanks
Rich

Thanks Jan,

Unfortunately I cannot open that table.

I can edit it.

I renamed the table dbo.dnn490_WebServersOld and tried to recreate but got the error
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'PK_dnn490_WebServers' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

Any other suggestions?

Thanks

Hum,

Turns out I can't open any tables. I get and Unspecified error with the following details, thou I'm not sure what it means.

Unspecified error
 (MS Visual Database Tools)

------------------------------
Program Location:

   at Microsoft.VisualStudio.DataTools.Interop.IDTTableDesignerFactory.BrowseTable(Object dsRef, Object pServiceProvider)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.OpenTableNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.CreateDesigner(DocumentType editorType, DocumentOptions aeOptions, Urn parentUrn, IManagedConnection mc)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)