How can we help you today? How can we help you today?
jgonnering
Activity overview Badges (0) Posts (6) Comments (29)

Comments

Sort by recent activity
never mind, I found the Ignore Sensitivity Classifications in the options.  [image] / comments
  1. Community
  2. SQL Compare
  3. Ignore ALL extended properties
never mind, I found the Ignore Sensitivity Classifications in the options. 
0 votes
[image] / comments
  1. Community
  2. SQL Compare
  3. Ignore ALL extended properties
0 votes
I am seeing this exact same issue after upgrading to latest version. / comments
  1. Community
  2. SQL Prompt
  3. Right-click menu options missing in 9.5.9.10716
I am seeing this exact same issue after upgrading to latest version.
0 votes
This is happening to me as well.  I used to be able to highlight the code and format and it didn't matter if other code in the window had errors.  Now, all the code has compile for the highlighted code to be reformatted.  I'm not sure what version this behavior changed.  I am currently using SQL Prompt 9.2.9.6459 / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt - Format SQL oddity
This is happening to me as well.  I used to be able to highlight the code and format and it didn't matter if other code in the window had errors.  Now, all the code has compile for the highlighted ...
0 votes
getting errors with this version formatting SQL (CTRL+K, CTRL+Y). I do not get error using default formatting style. Email me for SQL being formatted and format file. from log file with verbose logging: 09 Mar 2018 21:07:21,011 [35] 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 21:07:23,048 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 09 Mar 2018 21:07:23,049 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 21:07:23,050 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 09 Mar 2018 21:07:23,051 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 21:07:23,052 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 118660780 09 Mar 2018 21:07:23,053 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 09 Mar 2018 21:07:23,054 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 21:07:25,443 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 09 Mar 2018 21:07:25,447 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 21:07:25,450 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 118660780 / comments
  1. Community
  2. SQL Prompt
  3. The latest stable build of SQL Prompt is 9.1.4.4532 (21st March)
getting errors with this version formatting SQL (CTRL+K, CTRL+Y). I do not get error using default formatting style. Email me for SQL being formatted and format file. from log file with verbose l...
0 votes
getting errors with this version formatting SQL (CTRL+K, CTRL+Y). I do not get error using default formatting style. Email me for SQL being formatted and format file. from log file with verbose logging: 09 Mar 2018 21:07:21,011 [35] 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 21:07:23,048 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 09 Mar 2018 21:07:23,049 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 21:07:23,050 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 09 Mar 2018 21:07:23,051 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 21:07:23,052 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 118660780 09 Mar 2018 21:07:23,053 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 09 Mar 2018 21:07:23,054 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 21:07:25,443 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 09 Mar 2018 21:07:25,447 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 09 Mar 2018 21:07:25,450 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 118660780 / comments
  1. Community
  2. SQL Prompt
  3. The latest stable build of SQL Prompt is 9.1.4.4532 (21st March)
getting errors with this version formatting SQL (CTRL+K, CTRL+Y). I do not get error using default formatting style. Email me for SQL being formatted and format file. from log file with verbose l...
0 votes
still getting errors using the March 14th release trying to format using a custom style. 15 Mar 2018 16:36:19,679 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:19,680 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:19,682 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:19,683 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:19,683 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 140401580 15 Mar 2018 16:36:19,684 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:19,685 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:25,677 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:25,677 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:25,678 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 140401580 15 Mar 2018 16:36:25,708 [107] 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) 15 Mar 2018 16:36:27,345 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:27,346 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:27,348 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:27,348 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:27,349 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 140401580 15 Mar 2018 16:36:27,350 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:27,351 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:29,561 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:29,564 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:29,567 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 140401580 / comments
  1. Community
  2. SQL Prompt
  3. The latest stable build of SQL Prompt is 9.1.4.4532 (21st March)
still getting errors using the March 14th release trying to format using a custom style.15 Mar 2018 16:36:19,679 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not availab...
0 votes
still getting errors using the March 14th release trying to format using a custom style. 15 Mar 2018 16:36:19,679 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:19,680 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:19,682 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:19,683 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:19,683 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 140401580 15 Mar 2018 16:36:19,684 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:19,685 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:25,677 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:25,677 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:25,678 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 140401580 15 Mar 2018 16:36:25,708 [107] 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) 15 Mar 2018 16:36:27,345 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:27,346 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:27,348 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:27,348 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:27,349 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 140401580 15 Mar 2018 16:36:27,350 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:27,351 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:29,561 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not available, returning null 15 Mar 2018 16:36:29,564 [1] DEBUG UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection 15 Mar 2018 16:36:29,567 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 140401580 / comments
  1. Community
  2. SQL Prompt
  3. The latest stable build of SQL Prompt is 9.1.4.4532 (21st March)
still getting errors using the March 14th release trying to format using a custom style.15 Mar 2018 16:36:19,679 [1] DEBUG UniversalAuthenticationAccessTokenCache - Authentication cache not availab...
0 votes
I tried the repair option as well, and it just sat there forever.  I tried to cancel it and it just sat there.  Had to reboot PC.  SSMS was closed.  As for copying the extensions, I do not see any Redgate extensions to copy.  To my chagrin, I'm just going to uninstall and reinstall. / comments
  1. Community
  2. SQL Prompt
  3. Install on SSMS 2017
I tried the repair option as well, and it just sat there forever.  I tried to cancel it and it just sat there.  Had to reboot PC.  SSMS was closed.  As for copying the extensions, I do not see any ...
0 votes
I can confirm that the latest beta fixes the issue. Thank you! Case closed. / comments
  1. Community
  2. SQL Prompt
  3. Intellisense showing blank values for tables
I can confirm that the latest beta fixes the issue. Thank you! Case closed.
0 votes
Total activity
49
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
14