Roaming Profiles and SQL Prompt options

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Roaming Profiles and SQL Prompt options

Postby CodantiM » Thu Jul 05, 2007 11:04 pm

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.)
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Postby Bart Read » Fri Jul 06, 2007 1:34 pm

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
Bart Read
 
Posts: 977
Joined: Thu Mar 31, 2005 11:17 am
Location: Cambridge, UK

Postby CodantiM » Fri Jul 06, 2007 4:31 pm

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.
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Postby Bart Read » Fri Jul 06, 2007 4:35 pm

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
Bart Read
 
Posts: 977
Joined: Thu Mar 31, 2005 11:17 am
Location: Cambridge, UK

Postby CodantiM » Fri Jul 06, 2007 4:41 pm

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!
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Postby Bart Read » Fri Jul 06, 2007 5:11 pm

No problem. Consider the feature request made!
Bart Read
Principal Consultant
bartread.com Ltd
Bart Read
 
Posts: 977
Joined: Thu Mar 31, 2005 11:17 am
Location: Cambridge, UK

Postby CodantiM » Fri Aug 31, 2007 11:58 pm

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.
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Postby Bart Read » Mon Sep 03, 2007 11:24 am

Interesting. OK, thanks for reporting this. We'll look into it.
Cheers,
Bart
Bart Read
Principal Consultant
bartread.com Ltd
Bart Read
 
Posts: 977
Joined: Thu Mar 31, 2005 11:17 am
Location: Cambridge, UK

Postby Bart Read » Mon Sep 03, 2007 4:28 pm

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
Bart Read
 
Posts: 977
Joined: Thu Mar 31, 2005 11:17 am
Location: Cambridge, UK

Postby CodantiM » Tue Sep 04, 2007 6:27 pm

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.)
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Postby Bart Read » Tue Sep 04, 2007 6:36 pm

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
Bart Read
 
Posts: 977
Joined: Thu Mar 31, 2005 11:17 am
Location: Cambridge, UK

Postby CodantiM » Tue Sep 11, 2007 11:55 pm

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!
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Configuration Paths

Postby TheSQLGuru » Fri Nov 23, 2007 4:12 pm

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.
TheSQLGuru
 
Posts: 19
Joined: Mon Mar 12, 2007 5:20 pm

has this problem solved yet?

Postby aocon » Thu Nov 07, 2013 2:59 pm

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
aocon
 
Posts: 2
Joined: Thu Sep 01, 2011 3:26 pm


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest