Roaming Profiles and SQL Prompt options

MikeyCMikeyC Posts: 249 Bronze 3
edited November 7, 2013 8:59AM in SQL Prompt Previous Versions
We recently purchased SQL Prompt 3, and have now noticed that we loose all of our settings every time we log off our PC. Our PCs are setup with roaming profiles, which I suspect are the problem, since the options appear to be stored under the "Local Settings" directory, which is not persistent. (So it really isn't a good place to store options.)

Is there any chance that the next version of SQL Prompt will store it's settings in a more appropriate place?

(I know it is very close to the release of 3.5, but this is really annoying to all of our developers.)

Comments

  • Bart ReadBart Read Posts: 997 Silver 1
    Hi there,


    For the new version you can define the storage folders for options etc by creating a registry key called "\\HKCU\Software\Red Gate\SQL Prompt 3" You can then define values called:

    "Options Folder"
    "Cache Folder"
    "Snippets Folder"

    These should all be strings set to the location where you'd like your settings stored.

    This should be available as a release candidate within the next week or two. The final release should be available a couple of weeks after that.

    Hope that helps.


    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • MikeyCMikeyC Posts: 249 Bronze 3
    Will those registry entries expand variables, so that something like:

    C:\Documents And Settings\%username%\Application Data\RedGate\SQLPrompt

    could be used, and would get expanded correctly for the user?

    Even better would be to have the settings first come from the Policy registry section, HKLM\Software\Policies and/or HKCU\Software\Policies, so that a GP could be deployed to control the location.
  • Bart ReadBart Read Posts: 997 Silver 1
    I dunno, give 'em an inch and they take a mile. :wink:

    Unfortunately this isn't a supported feature, it's a quick hack I put in a while back to help out our testers so I'm afraid it's fairly limited. You have to specify the fully qualified path for each folder, and note that if you want them all to be somewhere other than the local profile you need to specify locations for all of them.
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • MikeyCMikeyC Posts: 249 Bronze 3
    If you're not careful we will take two miles. :lol:

    Is there a procedure for making an official feature request? (Given what you have already, I suspect that expanding it would be fairly easy.)

    In any case, I am glad that the next version takes a step in the correct direction.

    Thanks!
  • Bart ReadBart Read Posts: 997 Silver 1
    No problem. Consider the feature request made!
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • MikeyCMikeyC Posts: 249 Bronze 3
    OK, I upgraded to SQL Prompt 3.5 and put the registry settings in, but I get an error and SQL Prompt crashes when I open a new query windows in SMSS.

    I found that if I make this directory:

    "C:\Documents and Settings\codantim\Local Settings\Application Data\Red Gate\SQL Prompt 3"

    that it will run and create a "CompletionConfiguration.xml" file in that directory.

    Is there another registry setting that I can set to move that file so that we can custom the options and not loose them every time we logoff the PC?

    Thanks,

    Michael


    Information on error:

    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: The directory name C:\Documents and Settings\codantim\Local Settings\Application Data\Red Gate\SQL Prompt 3 is invalid.
    at System.IO.FileSystemWatcher..ctor(String path, String filter)
    at System.IO.FileSystemWatcher..ctor(String path)
    at _80..ctor(Boolean isDefaultConfigCopy)
    at _80._1()
    at _77._1(String , _34 , _76 , Object )
    at _64.PopulateDefaultLists()
    at _64.FailsafePopulateCandidateLists()
    at _142.PopulateCandidateLists(_137 astMap, Element statementAst, Element ast)
    at RedGate.SqlPrompt.Engine.SqlPromptEngine.UpdateCandidateLists()
    at RedGate.SqlPrompt.Engine.SqlPromptEngine._2(Object , FitPropertyChangeEventArgs )
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
    at System.Delegate.DynamicInvokeImpl(Object[] args)
    at RedGate.Util.EventHandlerSet._1.Fire(Object eventKey, Object sender, EventArgs args)
    at _150._1(CaretPosition , CaretPosition )
    at _150.set_CaretPosition(CaretPosition value)
    at _150.ClearScript()
    at _150._1(IScriptProvider )
    at _150.SetSqlScriptProvider(IScriptProvider provider, CaretPosition caretPosition)
    at RedGate.SqlPrompt.Engine.SqlPromptEngine.SetSqlScriptProvider(IScriptProvider provider, CaretPosition caretPosition)
    at RedGate.SQLPrompt.CommonVS.Editor.VSEditorWindow..ctor(MetaDataCache metaDataCache, SqlPromptEngine engine, IVsTextView textView, Executer taskExecuter, UIThreadInvoker uiThreadInvoker, FontManager fontManager, EngineOptions engineOptions, UIOptions uiOptions, VSMainWindow vsMainWindow, SqlPromptEngineFactory spef)
    at RedGate.SQLPrompt.SSMSUI.Connect.CreateVSEditorWindow(MetaDataCache metaDataCache, SqlPromptEngine engine, IVsTextView textView, Executer taskExecuter, UIThreadInvoker uiThreadInvoker, FontManager fontManager, EngineOptions engineOptions, UIOptions uiOptions, VSMainWindow vsMainWindow, SqlPromptEngineFactory spef)
    at RedGate.SQLPrompt.CommonVS.Managers.EditorManager.OnRegisterView(IVsTextView pView)


    ************** Loaded Assemblies **************
    mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
    AppIDPackage
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
    System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    Microsoft.SqlServer.SqlTools.VSIntegration
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
    Microsoft.VisualStudio.Shell.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.0.4054
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
    Microsoft.VisualStudio.OLE.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.0.4054
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
    System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    Microsoft.SqlServer.SqlTDiagM
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
    SqlWorkbench.Interfaces
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
    Microsoft.DataWarehouse.SQM
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
    Microsoft.SqlServer.Instapi
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
    RedGate.SQLPrompt.SSMSUI
    Assembly Version: 3.5.0.333
    Win32 Version: 3.5.0.333
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.SSMSUI.dll
    RedGate.SQLPrompt.CommonVS
    Assembly Version: 3.5.0.333
    Win32 Version: 3.5.0.333
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.CommonVS.DLL
    Extensibility
    Assembly Version: 7.0.3300.0
    Win32 Version: 7.00.9466
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Extensibility/7.0.3300.0__b03f5f7f11d50a3a/Extensibility.dll
    EnvDTE
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
    Microsoft.VisualStudio.TextManager.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.0.4054
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
    RedGate.SqlPrompt.Engine
    Assembly Version: 3.5.0.333
    Win32 Version: 3.5.0.333
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.DLL
    RedGate.SQLPrompt.CommonUI
    Assembly Version: 3.5.0.333
    Win32 Version: 3.5.0.333
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.CommonUI.DLL
    log4net
    Assembly Version: 1.2.10.0
    Win32 Version: 1.2.10.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/log4net.DLL
    System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    RedGate.Licensing.Client
    Assembly Version: 1.3.3.2
    Win32 Version: 1.3.3.2
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Licensing.Client.DLL
    RedGate.SQL.Shared
    Assembly Version: 6.0.0.95
    Win32 Version: 6.0.0.95
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQL.Shared.DLL
    RedGate.Shared.Utils
    Assembly Version: 6.0.0.95
    Win32 Version: 6.0.0.95
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Shared.Utils.DLL
    Microsoft.SqlServer.Management.Reports
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Reports.DLL
    EnvDTE80
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE80/8.0.0.0__b03f5f7f11d50a3a/EnvDTE80.dll
    RedGate.SQLPrompt.vsmso
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.0.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.vsmso.DLL
    CustomMarshalers
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
    RedGate.SqlPrompt.Engine.Gatekeeper
    Assembly Version: 3.5.0.333
    Win32 Version: 3.5.0.333
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.Gatekeeper.DLL
    System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
    RedGate.SQLCompare.Engine
    Assembly Version: 5.8.1.31
    Win32 Version: 5.8.1.31
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLCompare.Engine.DLL
    RedGate.Refactoring.AddIn
    Assembly Version: 1.1.0.102
    Win32 Version: 1.1.0.102
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Refactoring.AddIn.dll
    RedGate.Licensing.Client
    Assembly Version: 1.3.1.6
    Win32 Version: 1.3.1.6
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Licensing.Client.DLL
    RedGate.Licensing.Helper
    Assembly Version: 1.3.1.0
    Win32 Version: 1.3.1.6
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Licensing.Helper.DLL
    RedGate.Refactoring.vsmso
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.0.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Refactoring.vsmso.DLL
    RedGate.SQLCompare.Rewriter
    Assembly Version: 5.9.0.19
    Win32 Version: 5.9.0.19
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.SQLCompare.Rewriter.DLL
    RedGate.SQLCompare.ASTParser
    Assembly Version: 5.9.0.19
    Win32 Version: 5.9.0.19
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.SQLCompare.ASTParser.DLL
    ActiproSoftware.Wizard.Net20
    Assembly Version: 3.0.121.0
    Win32 Version: 3.0.121.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/ActiproSoftware.Wizard.Net20.DLL
    RedGate.SQLCompare.Engine
    Assembly Version: 5.9.0.19
    Win32 Version: 5.9.0.19
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.SQLCompare.Engine.DLL
    ObjectExplorer
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
    SqlMgmt
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
    ConnectionDlg
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
    Microsoft.VisualStudio
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 built by: RTM
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
    Microsoft.VisualStudio.Shell
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
    Microsoft.VisualStudio.Shell.Interop.8.0
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
    System.Drawing.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
    Microsoft.VisualStudio.Designer.Interfaces
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.573
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll
    Microsoft.SqlServer.CustomControls
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
    Microsoft.SqlServer.Smo
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll
    Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
    Microsoft.SqlServer.RegSvrEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
    Microsoft.NetEnterpriseServers.ExceptionMessageBox
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
    Microsoft.SqlServer.ConnectionInfo
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
    Microsoft.SqlServer.SmoEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SmoEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SmoEnum.dll
    System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
    System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
    Microsoft.SqlServer.SqlEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll
    Microsoft.SqlServer.BatchParser
    Assembly Version: 9.0.242.0
    Win32 Version: 2005.090.3042.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/Microsoft.SqlServer.BatchParser/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.BatchParser.dll
    msvcm80
    Assembly Version: 8.0.50608.0
    Win32 Version: 8.00.50727.42
    CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd/msvcm80.dll
    RedGate.Refactoring.AddIn.ServicePack2
    Assembly Version: 1.1.0.102
    Win32 Version: 1.1.0.102
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Refactoring.AddIn.ServicePack2.DLL
    ObjectExplorerReplication
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorerReplication.DLL
    System.Management
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
    SQLEditors
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.3042.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL
    RedGate.SQLCompare.ASTParser
    Assembly Version: 5.8.1.31
    Win32 Version: 5.8.1.31
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLCompare.ASTParser.DLL

    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    <configuration>
    <system.windows.forms jitDebugging="true" />
    </configuration>

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.
  • Bart ReadBart Read Posts: 997 Silver 1
    Interesting. OK, thanks for reporting this. We'll look into it.
    Cheers,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Bart ReadBart Read Posts: 997 Silver 1
    Hi Michael,


    If you set it to a directory that already exists you should be fine. It looks like there's a bug in 3.5 where it doesn't try to create the directory until tries to save the settings for the first time. We'll try to get that fixed in the next release.


    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • MikeyCMikeyC Posts: 249 Bronze 3
    The directory I set it to does exist, the problem is that the location for the "CompletionConfiguration.xml" file isn't getting redirected to a spot other than default, even with me setting all three of the keys you mentioned.

    The default directory does get created if I don't redirect it, so "CompletionConfiguration.xml" gets created.

    Once I redirect the main configuration files, so that the options aren't lost every time we log off, the default directory doesn't get created, so SQL Prompt fails trying to create "CompletionConfiguration.xml" every time.

    Any idea when a version would be available that can be used with roaming profiles? (It is getting really old to loose all of our settings every time we have to log off the PC.)
  • Bart ReadBart Read Posts: 997 Silver 1
    OK thanks for letting me know. Unfortunately I can't really say for sure at this point because there's so much else on the agenda. As I say, we'll try to fix this if we can for the next release, but no promises.
    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • MikeyCMikeyC Posts: 249 Bronze 3
    OK, I installed the 3.6 EA, and things are better, SQL Prompt is working again for me, and I can keep most of my custom settings across logons. (I have found that I can never 'upgrade' I have to uninstall the old version, and then install the new version to get it to work.)

    What I have found now is that SQL Prompt still creates these files:

    CompletionConfiguration.xml
    Permissions_Sql2005.xml
    SecurableClasses_Sql2005.xml
    Permissions_Sql2000.xml
    SecurableClasses_Sql2000.xml

    in this directory: "C:\Documents and Settings\<username>\Local Settings\Application Data\Red Gate\SQL Prompt 3"

    All that means is that the files are lost every time we log off, and get re-created every time we logon and start SQL Prompt. (Of course that means we can't customize the CompletionConfiguration.xml file.)

    This is a great step in the right direction, though it would be nice if there was a registry setting that could redirect all of the files out of the "local settings" directory to one place. (Maybe an option to just remove "Local Settings\" from all option/configuration file paths?)

    Thanks!
  • Please add me to the list of people who are requesting that you allow for complete user control of the locations where prompt stores all of it's information.
    Kevin G. Boles
    SQL Server MVP 2007-2012
    Indicium Resources, Inc.
  • Hi, I am having the same problem with roaming profiles that you guys were having.

    Has this been solved already and is still not working?

    Thanks and regards.

    Abraham
Sign In or Register to comment.