Red Gate forums :: View topic - Roaming Profiles and SQL Prompt options
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

Roaming Profiles and SQL Prompt options

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
CodantiM



Joined: 29 Jun 2007
Posts: 180

PostPosted: Thu Jul 05, 2007 11:04 pm    Post subject: Roaming Profiles and SQL Prompt options Reply with quote

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.)
Back to top
View user's profile Send private message
Bart Read



Joined: 31 Mar 2005
Posts: 978
Location: Cambridge, UK

PostPosted: Fri Jul 06, 2007 1:34 pm    Post subject: Reply with quote

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
w: www.bartread.com
b: www.bartread.com/blog
Back to top
View user's profile Send private message
CodantiM



Joined: 29 Jun 2007
Posts: 180

PostPosted: Fri Jul 06, 2007 4:31 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Bart Read



Joined: 31 Mar 2005
Posts: 978
Location: Cambridge, UK

PostPosted: Fri Jul 06, 2007 4:35 pm    Post subject: Reply with quote

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
w: www.bartread.com
b: www.bartread.com/blog
Back to top
View user's profile Send private message
CodantiM



Joined: 29 Jun 2007
Posts: 180

PostPosted: Fri Jul 06, 2007 4:41 pm    Post subject: Reply with quote

If you're not careful we will take two miles. Laughing

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!
Back to top
View user's profile Send private message
Bart Read



Joined: 31 Mar 2005
Posts: 978
Location: Cambridge, UK

PostPosted: Fri Jul 06, 2007 5:11 pm    Post subject: Reply with quote

No problem. Consider the feature request made!
_________________
Bart Read
Principal Consultant
bartread.com Ltd
w: www.bartread.com
b: www.bartread.com/blog
Back to top
View user's profile Send private message
CodantiM



Joined: 29 Jun 2007
Posts: 180

PostPosted: Fri Aug 31, 2007 11:58 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Bart Read



Joined: 31 Mar 2005
Posts: 978
Location: Cambridge, UK

PostPosted: Mon Sep 03, 2007 11:24 am    Post subject: Reply with quote

Interesting. OK, thanks for reporting this. We'll look into it.
Cheers,
Bart
_________________
Bart Read
Principal Consultant
bartread.com Ltd
w: www.bartread.com
b: www.bartread.com/blog
Back to top
View user's profile Send private message
Bart Read



Joined: 31 Mar 2005
Posts: 978
Location: Cambridge, UK

PostPosted: Mon Sep 03, 2007 4:28 pm    Post subject: Reply with quote

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
w: www.bartread.com
b: www.bartread.com/blog
Back to top
View user's profile Send private message
CodantiM



Joined: 29 Jun 2007
Posts: 180

PostPosted: Tue Sep 04, 2007 6:27 pm    Post subject: Reply with quote

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.)
Back to top
View user's profile Send private message
Bart Read



Joined: 31 Mar 2005
Posts: 978
Location: Cambridge, UK

PostPosted: Tue Sep 04, 2007 6:36 pm    Post subject: Reply with quote

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
w: www.bartread.com
b: www.bartread.com/blog
Back to top
View user's profile Send private message
CodantiM



Joined: 29 Jun 2007
Posts: 180

PostPosted: Tue Sep 11, 2007 11:55 pm    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
TheSQLGuru



Joined: 12 Mar 2007
Posts: 14

PostPosted: Fri Nov 23, 2007 4:12 pm    Post subject: Configuration Paths Reply with quote

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
Indicium Resources, Inc.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
aocon



Joined: 01 Sep 2011
Posts: 2

PostPosted: Thu Nov 07, 2013 2:59 pm    Post subject: has this problem solved yet? Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group