How can we help you today? How can we help you today?
bauerju
Activity overview Badges (0) Posts (9) Comments (24)

Comments

Sort by recent activity
Hi Russeld D Latest Releas from yeserday (8.0.26.19750) shows same behaviour. Jürgen / comments
  1. Community
  2. Redgate Monitor
  3. Estate -> Disk Usage says "No SQL files on this disk"
Hi Russeld DLatest Releas from yeserday (8.0.26.19750) shows same behaviour.Jürgen
0 votes
Ok. Just let me know which informations you need. Jürgen / comments
  1. Community
  2. Redgate Monitor
  3. Estate -> Disk Usage says "No SQL files on this disk"
Ok. Just let me know which informations you need.Jürgen
0 votes
Hi Russel D Isn't this an initial date?  The server itself has no internet connection, so I also don't see any update messages. [image] To the clock issue. It's not a big problem. I can live with it. Jürgen / comments
  1. Community
  2. Redgate Monitor
  3. Wrong dateformat
Hi Russel DIsn't this an initial date?  The server itself has no internet connection, so I also don't see any update messages.To the clock issue. It's not a big problem. I can live with it.Jürgen
0 votes
Same bug here. Latest Release 9.1.2.4363 Here is part of the log. (Verbose Logging Enabled) 09 Mar 2018 07:20:40,473 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:20:40,474 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:20:40,474 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 688490668 09 Mar 2018 07:20:40,475 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:20:41,948 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:20:41,950 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 688490668 09 Mar 2018 07:20:42,181 [85] WARN RedGate.SqlPrompt.ScriptDomInterop.Format.FormatterV2 - Error at range (0:1): System.ArgumentNullException: Value cannot be null. Parameter name: token at Format.Engine.Formatting.RuleCollection.Rules.VerticallyLinkedTokensRuleExtensions.AlignmentPoint(VerticallyLinkedTokensRule verticallyLinkedTokensRule, TSqlParserToken token) at Format.Engine.Formatting.RuleProviders.Common.ProcedureParameterRuleProvider.AlignTo(IList`1 procedureParameters, TSqlFragment parentFragment) at Format.Engine.Formatting.RuleProviders.CreateAlterProcedureRuleProvider.FormatProcedureStatementBody(ProcedureStatementBody fragment) at Format.Engine.Formatting.RuleProviders.Visitors.TopLevelVisitor.Visit(AlterProcedureStatement fragment) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(AlterProcedureStatement node) at Microsoft.SqlServer.TransactSql.ScriptDom.AlterProcedureStatement.Accept(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlBatch.AcceptChildren(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(TSqlBatch node) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlBatch.Accept(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlScript.AcceptChildren(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(TSqlScript node) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlScript.Accept(TSqlFragmentVisitor visitor) at Format.Engine.Formatting.SqlFormatter.Format(String script, IScriptWriter scriptWriter, CancellationToken cancellationToken, IList`1& parseErrors) at RedGate.SqlPrompt.ScriptDomInterop.Format.FormatterV2.FormatScript(String script, LayoutOptions activeStyle, Int32 tabSize, IList`1& formatErrors, CancellationToken cancellationToken) at RedGate.SqlPrompt.ScriptDomInterop.Format.FormatterV2.FormatScript(String script, String activeStyleName, Int32 tabSize, ITextReplacer textWriter, Int32 startIndex) 09 Mar 2018 07:20:57,947 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:20:57,948 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:20:57,949 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 688490668 09 Mar 2018 07:20:57,949 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:03,355 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:03,356 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 688490668 09 Mar 2018 07:21:05,490 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:05,492 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:05,493 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:05,493 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 688490668 09 Mar 2018 07:21:05,494 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:11,989 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:11,990 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 688490668 09 Mar 2018 07:21:14,489 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:14,491 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:14,492 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 688490668 09 Mar 2018 07:21:14,492 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:17,358 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:17,359 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 688490668 09 Mar 2018 07:21:18,827 [74] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading EngineOptions from C:\Users\BAUERJU\AppData\Local\Red Gate\SQL Prompt 9\RedGate_SqlPrompt_Engine_EngineOptions.xml (attempt 0 of 10)... 09 Mar 2018 07:21:18,829 [74] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded EngineOptions 09 Mar 2018 07:21:18,831 [74] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading EngineOptions from C:\Users\BAUERJU\AppData\Local\Red Gate\SQL Prompt 9\RedGate_SqlPrompt_Engine_EngineOptions.xml (attempt 0 of 10)... 09 Mar 2018 07:21:18,831 [59] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading UIOptions from C:\Users\BAUERJU\AppData\Local\Red Gate\SQL Prompt 9\RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml (attempt 0 of 10)... 09 Mar 2018 07:21:18,832 [74] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded EngineOptions 09 Mar 2018 07:21:18,832 [59] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded UIOptions 09 Mar 2018 07:21:18,838 [77] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading LayoutOptions from C:\Users\BAUERJU\AppData\Local\Red Gate\SQL Prompt 9\RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml (attempt 0 of 10)... 09 Mar 2018 07:21:18,838 [78] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading TabMagicOptions from C:\Users\BAUERJU\AppData\Local\Red Gate\SQL Prompt 9\RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml (attempt 0 of 10)... 09 Mar 2018 07:21:18,839 [77] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded LayoutOptions 09 Mar 2018 07:21:18,839 [78] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded TabMagicOptions 09 Mar 2018 07:21:18,849 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:18,850 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:18,851 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 688490668 09 Mar 2018 07:21:18,851 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:26,068 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:21:26,069 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 688490668 Jürgen / comments
  1. Community
  2. SQL Prompt
  3. Error laying out SQL
Same bug here. Latest Release 9.1.2.4363 Here is part of the log. (Verbose Logging Enabled)09 Mar 2018 07:20:40,473 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, re...
0 votes
Hi Yes, update from today to 9.1.3.4467 has same problem. But there is now a nice popup with the failure. Btw I opened a support call and this is logged as SP-6865  in their bug tracking system. Jürgen / comments
  1. Community
  2. SQL Prompt
  3. Error laying out SQL
HiYes, update from today to 9.1.3.4467 has same problem. But there is now a nice popup with the failure.Btw I opened a support call and this is logged as SP-6865  in their bug tracking system.Jürgen
0 votes
Same bug here. Latest Release 9.1.2.4363 Here is part of the log. (Verbose Logging Enabled) 09 Mar 2018 07:20:40,473 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:20:40,474 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:20:40,474 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 688490668 09 Mar 2018 07:20:40,475 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:20:41,948 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 07:20:41,950 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 688490668 09 Mar 2018 07:20:42,181 [85] WARN RedGate.SqlPrompt.ScriptDomInterop.Format.FormatterV2 - Error at range (0:1): System.ArgumentNullException: Value cannot be null. Parameter name: token at Format.Engine.Formatting.RuleCollection.Rules.VerticallyLinkedTokensRuleExtensions.AlignmentPoint(VerticallyLinkedTokensRule verticallyLinkedTokensRule, TSqlParserToken token) at Format.Engine.Formatting.RuleProviders.Common.ProcedureParameterRuleProvider.AlignTo(IList`1 procedureParameters, TSqlFragment parentFragment) at Format.Engine.Formatting.RuleProviders.CreateAlterProcedureRuleProvider.FormatProcedureStatementBody(ProcedureStatementBody fragment) at Format.Engine.Formatting.RuleProviders.Visitors.TopLevelVisitor.Visit(AlterProcedureStatement fragment) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(AlterProcedureStatement node) at Microsoft.SqlServer.TransactSql.ScriptDom.AlterProcedureStatement.Accept(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlBatch.AcceptChildren(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(TSqlBatch node) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlBatch.Accept(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlScript.AcceptChildren(TSqlFragmentVisitor visitor) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(TSqlScript node) at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlScript.Accept(TSqlFragmentVisitor visitor) at Format.Engine.Formatting.SqlFormatter.Format(String script, IScriptWriter scriptWriter, CancellationToken cancellationToken, IList`1& parseErrors) at RedGate.SqlPrompt.ScriptDomInterop.Format.FormatterV2.FormatScript(String script, LayoutOptions activeStyle, Int32 tabSize, IList`1& formatErrors, CancellationToken cancellationToken) at RedGate.SqlPrompt.ScriptDomInterop.Format.FormatterV2.FormatScript(String script, String activeStyleName, Int32 tabSize, ITextReplacer textWriter, Int32 startIndex) Jürgen / comments
  1. Community
  2. SQL Prompt
  3. Error laying out SQL
Same bug here. Latest Release 9.1.2.4363 Here is part of the log. (Verbose Logging Enabled)09 Mar 2018 07:20:40,473 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, re...
0 votes
Hi I have the same problem here: Win10PRo, SSMS 17.1 (14.0.17119.) SQL Search 2.4.0.1203, SQL Prompt 8.0.1.1383 Sometimes Search Fails with one database. There are no results. I can reach the server only over vpn on a 16 Mbit line. Latencetime for a ping is over 50 MS, sometimes mor than 100. Even Reindex doesn't help. I got following error in Logfiles: 30 Jun 2017 07:43:29.673 [53] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Exception while re-indexing xxxx on yyyy: Exception: constraint failed UNIQUE constraint failed: sysobjects.id Only closing of SSMS and reopening helps sometimes. This sucks ... Jürgen / comments
  1. Community
  2. SQL Search
  3. No search results
Hi I have the same problem here: Win10PRo, SSMS 17.1 (14.0.17119.) SQL Search 2.4.0.1203, SQL Prompt 8.0.1.1383 Sometimes Search Fails with one database. There are no results. I can reach the ser...
0 votes
Hi joshcrang Where can I get it? In official Download is only 7.1.15 available. And the server, on which SQL-Monitor runs, is not allowed to go to the Internet.  So there is no  Check for Updates banner to click ... Jürgen / comments
  1. Community
  2. Redgate Monitor
  3. SQL Monitor 7 released
Hi joshcrangWhere can I get it? In official Download is only 7.1.15 available.And the server, on which SQL-Monitor runs, is not allowed to go to the Internet. So there is no  Check for Updates bann...
0 votes
Hi Russel D Ok. This means the "Webserver" connects to the Internet in order to test if it is actual? I think this is no good practice: If I have a server which connects and controls productiv SQL-Servers, then I don't want this server to be able to connect to the internet. That's like switching my firewalls off... Why don't you make an AJAX-JSON oder JSONP-Request from then browser? To prevent this check at every login or any other website action, you could save the time of the last check and the result in your in a table. And 24 hours later you could do the check again. Or may bee make it easier to find the actual download... Jürgen / comments
  1. Community
  2. Redgate Monitor
  3. SQL Monitor 7 released
Hi Russel D Ok. This means the "Webserver" connects to the Internet in order to test if it is actual? I think this is no good practice: If I have a server which connects and controls productiv SQL-...
0 votes
Valid Links in the forum would be OK. Or even a simple http://download.red-gate.com//checkforupdates/SQLMonitorWeb/SQLMonitorWeb_7.1.19 or http://download.red-gate.com//checkforupdates/SQLMonitorWeb/SQLMonitorWeb_7.latest which redirects to http://download.red-gate.com//checkforupdates/SQLMonitorWeb/SQLMonitorWeb_7.1.19.11592.exe Jürgen / comments
  1. Community
  2. Redgate Monitor
  3. SQL Monitor 7 released
Valid Links in the forum would be OK. Or even a simplehttp://download.red-gate.com//checkforupdates/SQLMonitorWeb/SQLMonitorWeb_7.1.19 orhttp://download.red-gate.com//checkforupdates/SQLMonitorWeb...
0 votes
Total activity
45
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
12