How can we help you today? How can we help you today?
BAlexandrov
Activity overview Badges (0) Posts (1) Comments (12)

Comments

Sort by recent activity
Similar one here. If SQL Studio is started with different account to access different database with integrated security. Maybe this is related to slowness that I complain for in different thread...?? RedGate 3.6.0.109 Every time I close an tab with query I got: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Runtime.InteropServices.InvalidComObjectException: COM object that has been separated from its underlying RCW cannot be used. at Microsoft.VisualStudio.TextManager.Interop.IVsTextView.RemoveCommandFilter(IOleCommandTarget pCmdTarg) at RedGate.SQLPrompt.CommonVS.Managers.EditorManager.OnUnregisterView(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.2047.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL Microsoft.SqlServer.SqlTools.VSIntegration Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.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.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 Microsoft.DataWarehouse.SQM Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.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.6.0.109 Win32 Version: 3.6.0.109 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.SSMSUI.dll RedGate.SQLPrompt.CommonVS Assembly Version: 3.6.0.109 Win32 Version: 3.6.0.109 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 RedGate.SqlPrompt.Engine Assembly Version: 3.6.0.109 Win32 Version: 3.6.0.109 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.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.CommonUI Assembly Version: 3.6.0.109 Win32 Version: 3.6.0.109 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 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.6.0.109 Win32 Version: 3.6.0.109 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 ObjectExplorer Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL ConnectionDlg Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.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 SqlWorkbench.Interfaces 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/SqlWorkbench.Interfaces.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 SqlMgmt Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.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.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 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.50727.762 Win32 Version: 8.00.50727.762 CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6b128700/msvcm80.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 Microsoft.ReportViewer.WinForms Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.817 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.ReportViewer.WinForms/8.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.WinForms.dll SQLEditors Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL RedGate.SQLCompare.Engine Assembly Version: 5.8.2.3 Win32 Version: 5.8.2.3 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLCompare.Engine.DLL RedGate.SQLCompare.ASTParser Assembly Version: 5.8.2.3 Win32 Version: 5.8.2.3 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLCompare.ASTParser.DLL Microsoft.VisualStudio.Shell Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.762 (SP.050727-7600) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll Microsoft.VisualStudio.Package.LanguageService Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.762 (SP.050727-7600) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Package.LanguageService/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Package.LanguageService.dll Microsoft.SqlServer.GridControl Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.GridControl/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.GridControl.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. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. v3.6 - NullReferenceException crash
Similar one here. If SQL Studio is started with different account to access different database with integrated security. Maybe this is related to slowness that I complain for in different thread......
0 votes
Some followups? / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. v3.6 - NullReferenceException crash
Some followups?
0 votes
BAlexandrov wrote: With the new 3.6.0.109 I again experience slow performance but now on execution of SQL or most probbaly on rendering results in the grid in SQL Management Studio 2005?? This problem exists only when I start SQL Studio with different account (with runas) and with it I have admin rights on the production server. Unchecking Cross database support does not help. Disabling SQL Prompt from the menu removes the problem - the query (simple select) executes for 00:00 and with enabled SQL Prompt it takes 00:01 (this is not shown in Client Statistics so only interface of SQL Studio is affected) Ive got the internal released version. Problem is still there. It seems that the problem is on the second instance of Micrsoft SQL Server Management Studio. Scenario is like that - I start with runas with different domain account a copy of the Management Studio and access production database - everything works fast. Then I start second copy with mine currently logged on account and it begins to lag. Refreshing results grid is slow, executing query is slow (Sometimes few seconds). In the first instance still everything is fast. Then I go to SQL Prompt options of this second instance and disable sql prompt availability and .. everything is Ok and fast - refreshing the grid, excution of queries and so on. I am on Windows XP, Pentium Core 2 Duo @ 2 Ghz, 2 GB RAM... There is also an exception with this version but I think is not related and will report it in another thread. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt Performance
BAlexandrov wrote: With the new 3.6.0.109 I again experience slow performance but now on execution of SQL or most probbaly on rendering results in the grid in SQL Management Studio 2005?? This p...
0 votes
Are they two months there?? / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt Performance
Are they two months there??
0 votes
With the new 3.6.0.109 I again experience slow performance but now on execution of SQL or most probbaly on rendering results in the grid in SQL Management Studio 2005?? This problem exists only when I start SQL Studio with different account (with runas) and with it I have admin rights on the production server. Unchecking Cross database support does not help. Disabling SQL Prompt from the menu removes the problem - the query (simple select) executes for 00:00 and with enabled SQL Prompt it takes 00:01 (this is not shown in Client Statistics so only interface of SQL Studio is affected) / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt Performance
With the new 3.6.0.109 I again experience slow performance but now on execution of SQL or most probbaly on rendering results in the grid in SQL Management Studio 2005?? This problem exists only whe...
0 votes
Are there some thoughts on my problem? I have rolled back to previous version that I dont have this problem. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt Performance
Are there some thoughts on my problem? I have rolled back to previous version that I dont have this problem.
0 votes
Thanks! It works 8) / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Exception when in different user context
Thanks! It works 8)
0 votes
I have found the case when this exception is thrown - When I start more than one SQL Management Studio, first with whichever account works OK, second one with another account gives these exceptions. Probably they both are trying to access some file simultaneously but...which one and why? I can see its files in Local Settings directory of these two users... / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Exception when in different user context
I have found the case when this exception is thrown - When I start more than one SQL Management Studio, first with whichever account works OK, second one with another account gives these exceptions...
0 votes
Here another variant of exception in same case: ************** Exception Text ************** _104: Exception of type '_104' was thrown. at RedGate.SqlPrompt.Engine.Snippets.SnippetManager._1&#40;&#41; at RedGate.SqlPrompt.Engine.Snippets.SnippetManager.Save&#40;String filename&#41; at RedGate.SqlPrompt.Engine.Snippets.SnippetManager._8&#40;&#41; at RedGate.SqlPrompt.Engine.Snippets.SnippetManager.AddSnippetCategory&#40;String name&#41; at RedGate.SqlPrompt.Engine.Snippets.SnippetManager._1&#40;&#41; at RedGate.SqlPrompt.Engine.Snippets.SnippetManager._1&#40;Boolean &#41; at RedGate.SqlPrompt.Engine.Snippets.SnippetManager..ctor&#40;String storageDirectory&#41; at RedGate.SqlPrompt.Engine.Snippets.SnippetManager.GetSnippetManager&#40;&#41; at _34._1&#40;Boolean &#41; at _34._1&#40;_4 , _14 &#41; at RedGate.SqlPrompt.Engine.SqlPromptEngine..ctor&#40;EngineOptions options&#41; at RedGate.SqlPrompt.Engine.SqlPromptEngineFactory.GetEngine&#40;Object owner, EngineOptions options&#41; at RedGate.SqlPrompt.Engine.SqlPromptEngineFactory.GetEngine&#40;Object owner&#41; at _19.OnRegisterView&#40;IVsTextView pView&#41; ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 &#40;RTM.050727-4200&#41; CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- AppIDPackage Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.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.42 &#40;RTM.050727-4200&#41; 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.2047.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.42 &#40;RTM.050727-4200&#41; 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.42 &#40;RTM.050727-4200&#41; 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 ---------------------------------------- Microsoft.DataWarehouse.SQM Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.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.0.0.868 Win32 Version: 3.0.0.868 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.SSMSUI.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 &#40;RTM.050727-4200&#41; CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll ---------------------------------------- RedGate.SQLPrompt.CommonUI Assembly Version: 3.0.0.868 Win32 Version: 3.0.0.868 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.CommonUI.DLL ---------------------------------------- RedGate.Licensing.Client Assembly Version: 1.3.0.25 Win32 Version: 1.3.0.25 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Licensing.Client.DLL ---------------------------------------- RedGate.SQL.Shared Assembly Version: 5.3.0.1 Win32 Version: 5.3.0.1 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQL.Shared.DLL ---------------------------------------- RedGate.Licensing.Helper Assembly Version: 1.3.0.25 Win32 Version: 1.3.0.25 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Licensing.Helper.DLL ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 &#40;RTM.050727-4200&#41; CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.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 ---------------------------------------- RedGate.SqlPrompt.Engine Assembly Version: 3.0.0.868 Win32 Version: 3.0.0.868 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.DLL ---------------------------------------- EnvDTE80 Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.42 &#40;RTM.050727-4200&#41; CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE80/8.0.0.0__b03f5f7f11d50a3a/EnvDTE80.dll ---------------------------------------- RedGate.SqlPrompt.Engine.Gatekeeper Assembly Version: 3.0.0.868 Win32 Version: 3.0.0.868 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.Gatekeeper.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 ---------------------------------------- System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 &#40;RTM.050727-4200&#41; CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- RedGate.Shared.Utils Assembly Version: 5.3.0.1 Win32 Version: 5.3.0.1 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Shared.Utils.DLL ---------------------------------------- System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 &#40;RTM.050727-4200&#41; CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- ObjectExplorer Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL ---------------------------------------- ConnectionDlg Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL ---------------------------------------- Microsoft.SqlServer.CustomControls Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll ---------------------------------------- SqlWorkbench.Interfaces 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/SqlWorkbench.Interfaces.DLL ---------------------------------------- Accessibility Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 &#40;RTM.050727-4200&#41; 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.2047.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll ---------------------------------------- SqlMgmt Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.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.762 &#40;SP.050727-7600&#41; 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 &#40;RTM.050727-4200&#41; 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 &#40;RTM.050727-4200&#41; 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 ---------------------------------------- System.Design Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 &#40;RTM.050727-4200&#41; CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll ---------------------------------------- Microsoft.NetEnterpriseServers.ExceptionMessageBox Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.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.1399.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll ---------------------------------------- System.Management Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 &#40;RTM.050727-4200&#41; CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll ---------------------------------------- Microsoft.SqlServer.SmoEnum Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.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.42 &#40;RTM.050727-4200&#41; 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.42 &#40;RTM.050727-4200&#41; CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll ---------------------------------------- Microsoft.SqlServer.Smo Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll ---------------------------------------- Microsoft.SqlServer.SqlEnum Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.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.2047.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.50727.762 Win32 Version: 8.00.50727.762 CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6b128700/msvcm80.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 ---------------------------------------- Microsoft.ReportViewer.WinForms Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.762 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.ReportViewer.WinForms/8.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.WinForms.dll ---------------------------------------- SQLEditors Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL ---------------------------------------- Microsoft.VisualStudio.Design Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.762 &#40;SP.050727-7600&#41; CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Design/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Design.dll ---------------------------------------- Microsoft.VisualStudio.Shell.Design Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 &#40;RTM.050727-4200&#41; CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell.Design/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Design.dll ---------------------------------------- Microsoft.SqlServer.GridControl Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.GridControl/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.GridControl.dll ---------------------------------------- Microsoft.SqlServerCe.Client Assembly Version: 9.0.242.0 Win32 Version: 3.0.5207.0 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServerCe.Client.DLL ---------------------------------------- Microsoft.SqlServer.DataStorage Assembly Version: 9.0.242.0 Win32 Version: 9.00.2047.00 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.DataStorage/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.DataStorage.dll ---------------------------------------- / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Exception when in different user context
Here another variant of exception in same case:************** Exception Text ************** _104: Exception of type '_104' was thrown. at RedGate.SqlPrompt.Engine.Snippets.SnippetManager._1&#40;...
0 votes
Check "Owner or schema filtering" in options / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Results not being restricted by Schema
Check "Owner or schema filtering" in options
0 votes
Total activity
17
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
4