VS error SQL Complete

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
resten
Posts: 1
Joined: Wed 30 Jun 2021 07:50

VS error SQL Complete

Post by resten » Wed 30 Jun 2021 07:56

Hi, we just started using SQL Complete and are experiencing errors in visual studio on certain procedures where we do not have them in SSMS. It seems to be related to procedures where ##tables are used.

=========================
IDE Information
=========================
Name: Microsoft Visual Studio
Path: C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\Common7\IDE\devenv.exe
Product Version: 15.9.28307.1440
DTE Version: 15.0
Edition: IDE Standard
LocaleID: 1033
Mode: vsIDEModeDesign
Registry Root: Software\Microsoft\VisualStudio\15.0_0b405956

=========================
General
=========================
Application: dbForge SQL Complete
Product: Devart dbForge SQL Complete
Product Edition: Professional
Product Locale: English
Trial Info: Activated
HardwareID: 0EF1-3312-8EA2-BA97-090A-68C5
Assembly: Devart.DbForge.SqlComplete.Integration, Version=6.8.13.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files (x86)\Devart\dbForge SQL Complete\Devart.DbForge.SqlComplete.Integration.dll
Global cache: False
Framework: 4.6.2 or later

=========================
Exception Information
=========================
Place: 1
ExceptionId: 3d29f3bb-dca5-442f-a201-38c4a38aa1bc
Message: Object reference not set to an instance of an object.
Source: Devart.DbForge.DeclarationRepository.SqlServer.r1
TargetSite: Devart.DbForge.DeclarationRepository.ICompositeDeclaration dXC1CA0Al0()
HelpLink:
Type: System.NullReferenceException
Stack:
at PIH8k2H4u57AniNEmBV.nDkR3KH8G40RCjRKZ36.BqK3k2HdDKhWnmyEgO7.dXC1CA0Al0()
at PIH8k2H4u57AniNEmBV.nDkR3KH8G40RCjRKZ36.BqK3k2HdDKhWnmyEgO7.RLr1NdvkI0()
at PIH8k2H4u57AniNEmBV.nDkR3KH8G40RCjRKZ36.GetParentDeclaration(IList`1 , BitSet )
at Devart.DbForge.DeclarationRepository.ScriptScopeProvider.EndRootDeclaration(Object[] parameters)
at Devart.DbForge.DeclarationRepository.ScriptScopeProvider.DoActionInternal(UInt32 actionId, Object[] parameters)
at PIH8k2H4u57AniNEmBV.nDkR3KH8G40RCjRKZ36.DoActionInternal(UInt32 , Object[] parameters)
at Devart.DbForge.DeclarationRepository.ScriptScopeProvider.DoAction(UInt32 actionId, Object[] parameters)
at Devart.DbForge.DeclarationRepository.ProjectScopeProvider.DoAction(UInt32 actionId, Object[] parameters)
at Devart.DbForge.LanguageService.SqlParser.Do[T](UInt32 actionId, Object[] parameters)
at SqlServerParser.createTableStatement()
at SqlServerParser.createStatements()
at SqlServerParser.createStatement()
at SqlServerParser.ddlStatements()
at SqlServerParser.singleProgramStatement()
at SqlServerParser.programStatement()
at SqlServerParser.programStatementListItem()
at SqlServerParser.programStatementList()
at SqlServerParser.compoundBlock()
at SqlServerParser.programStatement()
at SqlServerParser.conditionalStatement()
at SqlServerParser.ifStatement()
at SqlServerParser.controlFlowStatementsCompound()
at SqlServerParser.controlFlowStatements()
at SqlServerParser.singleProgramStatement()
at SqlServerParser.programStatement()
at SqlServerParser.programStatementListItem()
at SqlServerParser.programStatementList()
at SqlServerParser.tryClause()
at SqlServerParser.safeCompoundBlock()
at SqlServerParser.singleProgramStatement()
at SqlServerParser.programStatement()
at SqlServerParser.programStatementListItem()
at SqlServerParser.programStatementList()
at SqlServerParser.queryStatements()
at SqlServerParser.procedureBody()
at SqlServerParser.procedureStatement()
at SqlServerParser.createStatements()
at SqlServerParser.createStatement()
at SqlServerParser.ddlStatements()
at SqlServerParser.scriptStatement()
at SqlServerParser.scriptItem()
at SqlServerParser.parseScript()
at Devart.DbForge.LanguageService.SqlParser.jUxgdU7x8n()
at Devart.DbForge.LanguageService.SqlParser.tuwgn7lJj4(SqlScriptState , ParseOptions )
at Devart.DbForge.LanguageService.SqlParser.Parse(ISqlScriptState scriptState, ParseOptions options)
at Devart.DbForge.LanguageService.Source.bGPurbaIPk(SqlParser , ParseOptions )
at Devart.DbForge.LanguageService.Source.Devart.DbForge.LanguageService.IParseUser.Parse(ParseOptions parseOptions, ISqlScriptState scriptState)
at Devart.DbForge.LanguageService.ParseManager.VwFGjb5Bar(ParseOptions , ISqlScriptState , xp47mg4OdOBGsW1LXi )
at Devart.DbForge.LanguageService.ParseManager.BSmGSdSNhh(ParseOptions , ISqlScriptState , xp47mg4OdOBGsW1LXi )
at Devart.DbForge.LanguageService.ParseManager.<>c__DisplayClass12_0.iGY3CCQN5l()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Devart.DbForge.LanguageService.Source.<ParseAsync>d__89.MoveNext()


=========================
Connection Information
=========================
Active Document:
Name: proc_load_stg_fct_Report_Cell_Solvency.sql
Is Connectable Document: True
Connection String: Connection Timeout=60;Data Source=(localdb)\ProjectsV13;Encrypt=False;Enlist=False;MultipleActiveResultSets=False;Initial Catalog=DM_NWB;Integrated Security=True;TrustServerCertificate=False;Transaction Scope Local=True
Connection is open: True
Server Version: 13.00.4001

=========================
Registered AddIns
=========================

=========================
Registered Extensions
=========================
Name: Microsoft Connected Services
Author: Microsoft
Description: Provides the base tools and extensibility framework for the Add Connected Service dialog.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\ZQ2OBTWO.O1J\
State: Enabled

Name: Microsoft Azure Mobile Apps Connected Service
Author: Microsoft
Description: Allows developers to create and connect to Azure Mobile Apps easily and with step-by-step guidance.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\YWQ5O2I5.RYF\
State: Enabled

Name: MSTest V2 Templates for Visual Basic
Author: Microsoft
Description: Provides Visual Studio project template for MSTest V2(Visual Basic).
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\YJREI1NC.KES\
State: Enabled

Name: Azure AD Authentication Connected Service
Author: Microsoft
Description: Provides the wizard to configure Azure AD Authentication Single Sign-On in web projects.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\X3SPXUBM.IY1\
State: Enabled

Name: Microsoft.VisualStudio.Debugger.VSCodeDebuggerHost
Author: Microsoft
Description:
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\WSIP5IUN.QNF\
State: Enabled

Name: Dotnet Extensions for Test Explorer
Author: Microsoft
Description: Discover and execute tests for .NET languages with Test Explorer
SystemComponent: False
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\TESTWINDOW.DOTNET\
State: Enabled

Name: Microsoft Visual Studio Test Platform
Author: Microsoft
Description: Extensible Test Platform that allows developers to discover, execute and analyze automated tests.
SystemComponent: False
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\TESTPLATFORM\
State: Enabled

Name: Microsoft Azure Storage Connected Service
Author: Microsoft
Description: Allows developers to create and connect to Azure Storage accounts easily and with step-by-step guidance.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\O3RKGAE4.EMS\
State: Enabled

Name: Common Azure Tools
Author: Microsoft Corporation
Description: Common tools for use by Visual Studio components for Windows Azure development, including Windows Azure Tools and Mobile Services Tools
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\WINDOWS AZURE TOOLS\COMMON\
State: Enabled

Name: Microsoft WCF Web Service Reference Provider
Author: Microsoft
Description: A Visual Studio Connected Service to add WCF Web service references to .NET Core projects in Visual Studio 2017.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\WCF CONNECTED SERVICE\
State: Enabled

Name: Visual Studio MPF 14.0
Author: Microsoft
Description: Microsoft Visual Studio MPF Assemblies
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\VISUAL STUDIO MPF\14.0\
State: Enabled

Name: Visual Studio MPF 12.0
Author: Microsoft
Description: Microsoft Visual Studio MPF Assemblies
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\VISUAL STUDIO MPF\12.0\
State: Enabled

Name: Visual Studio MPF 11.0
Author: Microsoft
Description: Microsoft Visual Studio MPF Assemblies
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\VISUAL STUDIO MPF\11.0\
State: Enabled

Name: Visual Studio MPF
Author: Microsoft
Description: Microsoft Visual Studio MPF Assemblies
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\VISUAL STUDIO MPF\10.0\
State: Enabled

Name: Associate Test Method to Work Item
Author: Microsoft
Description: Provides support for associating test method to work item from test explorer
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\UNIT TEST EXPLORER\TESTWIEXTENSION\
State: Enabled

Name: SQL Server Data Tools - Sql Editor
Author: Microsoft
Description: Microsoft SQL Server Data Tools, Sql Editor, Debugger and Language Services
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\SQLEDITOR\VSIX\
State: Enabled

Name: SQL Server Data Tools
Author: Microsoft
Description: Microsoft SQL Server Data Tools
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\SQLDB\VSIX\
State: Enabled

Name: Microsoft SQL Server Data Tools
Author: Microsoft Corporation
Description: Microsoft SQL Server Data Tools
SystemComponent: False
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\SQLDB\SSDTUPDATE\
State: Enabled

Name: Microsoft Portable Library Tools
Author: Microsoft
Description: Microsoft Portable Library Tools
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\PORTABLE LIBRARY TOOLS\
State: Enabled

Name: Microsoft Office 365 Services with Microsoft Graph
Author: Microsoft
Description: Use the Microsoft Graph API to integrate your application with Office 365 services
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\MICROSOFT OFFICE 365 CONNECTED SERVICE\
State: Enabled

Name: C#, Visual Basic and F# project systems
Author: Microsoft
Description: C#, Visual Basic and F# project systems.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\MANAGEDPROJECTSYSTEM\
State: Enabled

Name: CodeSenseFramework
Author: Microsoft
Description: Manifest for adding CodeSense Framework components common to all providers
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\MICROSOFT\CODESENSE\FRAMEWORK\
State: Enabled

Name: Microsoft.VisualStudio.Tools.Applications
Author: Microsoft Corporation
Description: Visual Studio Tools for Applications VSIX package
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\IA24KH3E.V0T\
State: Enabled

Name: SQL Complete Package
Author: Devart
Description: Devart dbForge Package for Visual Studio
SystemComponent: False
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\DEVART\SQLCOMPLETE\
State: Enabled

Name: Microsoft Azure Key Vault Connected Service
Author: Microsoft
Description: Allows developers to create and connect to Azure Key Vaults easily and with step-by-step guidance.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\CHVZXQPJ.W4Y\
State: Enabled

Name: MSTest V2 Templates
Author: Microsoft
Description: Provides Visual Studio project template for MSTest V2.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\ATFM2VVN.3HS\
State: Enabled

Name: MSTest V2 Create Unit Test Extension
Author: Microsoft
Description: Allows developers to create unit test using MSTest V2.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\EXTENSIONS\41T33M3P.XQM\
State: Enabled

Name: Visual Studio MPF 15.0
Author: Microsoft
Description: Microsoft Visual Studio MPF Assemblies
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\PLATFORM\VISUAL STUDIO MPF\15.0\
State: Enabled

Name: Microsoft Visual Studio Tree Navigation
Author: Microsoft Corporation
Description: Microsoft Visual Studio Tree Navigation
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\PLATFORM\TREENAVIGATION\
State: Enabled

Name: Tree Navigation Graph Provider
Author: Microsoft Corporation
Description: Tree Navigation Graph Provider
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\PLATFORM\TREENAVIGATION\GRAPHPROVIDER\
State: Enabled

Name: Microsoft Visual Studio Shell Components
Author: Microsoft Corporation
Description: Microsoft Visual Studio Shell Components
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\PLATFORM\SHELL\
State: Enabled

Name: Microsoft Visual Studio Parallel Debugger GUI
Author: Microsoft Corporation
Description: Debugger Parallel GUI extension components
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\PLATFORM\PARALLELDEBUGGER\
State: Enabled

Name: Quick Search
Author: Microsoft
Description: Quick Search
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\PLATFORM\NAVIGATETO\
State: Enabled

Name: Navigate To File Name Provider
Author: Microsoft
Description: Navigate To File Name Provider
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\PLATFORM\NAVIGATETO\FILEPROVIDER\
State: Enabled

Name: Microsoft Visual Studio Debugger GUI
Author: Microsoft Corporation
Description: Debugger GUI Components
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\PLATFORM\DEBUGGER\
State: Enabled

Name: Visual Studio XAML Language Service
Author: Microsoft
Description: Provides a language service for XAML files.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\XAMLLANGUAGESERVICE\
State: Enabled

Name: XamlDiagnostics Diagnostics
Author: Microsoft
Description: Xaml Diagnostic Tools.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\XAMLDIAGNOSTICS\
State: Enabled

Name: VisualStudio Editors
Author: Microsoft
Description: Microsoft VisualStudio Editors
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\VISUALSTUDIO\EDITORS\
State: Enabled

Name: Visual Studio Extension for TextMate Grammars
Author: Microsoft Corporation
Description: An extension that provides basic support for TextMate grammars
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\TEXTMATE\
State: Enabled

Name: Test Explorer Window
Author: Microsoft
Description: Test Explorer Window
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\TESTWINDOW\
State: Enabled

Name: Microsoft Visual Studio Template Providers
Author: Microsoft Corporation
Description: Microsoft Visual Studio Template Providers
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\TEMPLATEPROVIDERS\
State: Enabled

Name: Team Explorer
Author: Microsoft
Description: Team Foundation extensions for Microsoft Visual Studio
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\TEAMFOUNDATION\TEAM EXPLORER\
State: Enabled

Name: Microsoft Reporting Services Projects
Author: Microsoft
Description: The Microsoft RDL report designer, projects and wizards for creating professional reports. This package provides support for the .rptproj type and is designed for the most recent versions of Microsoft Reporting Services.
SystemComponent: False
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\SSRS\
State: Enabled

Name: Microsoft Integration Services Projects
Author: Microsoft
Description: This project may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing.
SystemComponent: False
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\SSIS\
State: Enabled

Name: Microsoft Analysis Services Projects
Author: Microsoft
Description: Microsoft Analysis Services projects provide project templates and design surfaces for building professional data models hosted in SQL Server Analysis Services on-premises, Microsoft Azure Analysis Services, and Microsoft Power BI.
SystemComponent: False
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\SSAS\
State: Enabled

Name: Microsoft Visual Studio Data Tools DAX Editor
Author: Microsoft Corporation
Description: Microsoft Visual Studio Data Tools DAX Editor
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\SSAS\EXTENSIONS\MICROSOFT\DAXEDITOR\
State: Enabled

Name: Microsoft Visual Studio Reference Manager
Author: Microsoft
Description: Microsoft Visual Studio Reference Manager
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\REFERENCEMANAGER\
State: Enabled

Name: Microsoft VisualStudio ProjectServices
Author: Microsoft Corporation
Description: Microsoft VisualStudio Project Services
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\PROJECTSERVICES\
State: Enabled

Name: Visual Studio Common Project System
Author: Microsoft Corporation
Description: A general and extensible project system.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\PROJECT\
State: Enabled

Name: Visual Studio Product Updates
Author: Microsoft
Description: Updates to Visual Studio
SystemComponent: False
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\PRODUCTUPDATE\
State: Enabled

Name: Visual Studio AnyCode
Author: Microsoft Corporation
Description: Fast editing of all files in your source tree, regardless of VS-compatible projects or solutions.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\OPENFOLDER\
State: Enabled

Name: NuGet Package Manager for Visual Studio 2017
Author: Microsoft Corporation
Description: A collection of tools to automate the process of downloading, installing, upgrading, configuring, and removing packages from a VS Project.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\NUGET\
State: Enabled

Name: Real Time Test Discovery Package
Author: Microsoft
Description: Roslyn-based unit test discovery for C# and Visual Basic
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\MANAGEDLANGUAGES\VBCSHARP\SOURCEBASEDTESTDISCOVERY\
State: Enabled

Name: Roslyn Language Services
Author: Microsoft
Description: C# and VB.NET language services for Visual Studio.
SystemComponent: False
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\MANAGEDLANGUAGES\VBCSHARP\LANGUAGESERVICES\
State: Enabled

Name: Roslyn Interactive Components
Author: Microsoft
Description: Interactive Roslyn components for Visual Studio.
SystemComponent: False
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\MANAGEDLANGUAGES\VBCSHARP\INTERACTIVECOMPONENTS\
State: Enabled

Name: Roslyn Expression Evaluators
Author: Microsoft
Description: Roslyn Expression Evaluators
SystemComponent: False
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\MANAGEDLANGUAGES\VBCSHARP\EXPRESSIONEVALUATORS\
State: Enabled

Name: Language Server Protocol Client
Author: Microsoft
Description: The support for the Language Server Protocol for Visual Studio.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\LANGUAGESERVER\
State: Enabled

Name: Generate Type User Interface
Author: Microsoft
Description: Generate Type User Interface
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\LANGUAGE\GENERATETYPE\
State: Enabled

Name: Call Hierarchy User Interface
Author: Microsoft
Description: Call Hierarchy User Interface
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\LANGUAGE\CALLHIERARCHY\
State: Enabled

Name: VisualStudio Interactive Window
Author: Microsoft
Description: Interactive components for Visual Studio.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\INTERACTIVEWINDOW\
State: Enabled

Name: GettingStartedTemplatesResources
Author: Microsoft
Description: Getting Started Templates Localized Resources.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\GETTINGSTARTEDTEMPLATES\RESOURCES\
State: Enabled

Name: Microsoft.VisualStudio.ExtensionManager.ServiceModule
Author: Microsoft
Description: Service Module for ExtensionManager
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\EXTENSIONMANAGER\SERVICEMODULE\
State: Enabled

Name: Microsoft Visual Studio Editor
Author: Microsoft Corporation
Description: Microsoft Visual Studio Editor
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\ERRORLIST\
State: Enabled

Name: editorconfig Wizard
Author: Microsoft
Description: Wizard that helps create editorconfig files
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\EDITORCONFIG\WIZARD\
State: Enabled

Name: Microsoft Visual Studio Editor
Author: Microsoft Corporation
Description: Microsoft Visual Studio Editor
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\EDITOR\
State: Enabled

Name: Visual Studio Diff
Author: Microsoft Corporation
Description: A diff viewer built on the Visual Studio editor.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\DIFF\
State: Enabled

Name: Expression Blend
Author: Microsoft
Description: Provides a design experience for Silverlight and WPF XAML files.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\DESIGNTOOLS\
State: Enabled

Name: Microsoft Visual Studio CodingConventions
Author: Microsoft Corporation
Description: Microsoft Visual Studio Coding Conventions
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\CODINGCONVENTIONS\
State: Enabled

Name: CodeAnalysis
Author: Microsoft Corporation
Description: Microsoft Visual Studio Code Analysis
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\CODEANALYSIS\
State: Enabled

Name: Client Diagnostics
Author: Microsoft
Description: Client Diagnostic Tools.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\CLIENTDIAGNOSTICS\
State: Enabled

Name: Application Responsiveness
Author: Microsoft
Description: Application Responsiveness Diagnostic Tool.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\CLIENTDIAGNOSTICS\APPRESPONSIVENESS\
State: Enabled

Name: Microsoft BI Shared Components for Visual Studio
Author: Microsoft
Description: The Microsoft SSDT for BI Shared Components is a dependency for any of the Analysis Services, Integration Services, or Reporting Services extensions.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\BISHARED\
State: Enabled

Name: Solution Provider
Author: Microsoft
Description: Microsoft Visual Studio Architecture Tools - Solution Provider
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\ARCHITECTURE TOOLS\PROVIDERS\SOLUTION\
State: Enabled

Name: C# Provider
Author: Microsoft
Description: Microsoft Visual Studio Architecture Tools - Managed Provider
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\ARCHITECTURE TOOLS\PROVIDERS\MANAGEDPROVIDER\
State: Enabled

Name: GraphProviderPackage
Author: Microsoft
Description: The Graph Provider package.
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\MICROSOFT\ARCHITECTURE TOOLS\GRAPHPROVIDERPACKAGE\
State: Enabled

Name: Microsoft Visual Studio DataDesign
Author: Microsoft Corporation
Description: Microsoft Visual Studio DataDesign
SystemComponent: True
InstallPath: C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO\2017\SQL\COMMON7\IDE\COMMONEXTENSIONS\DATADESIGN\
State: Enabled

=========================
Loaded Packages
=========================
Name: ExtensionManagerPackage
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.ExtensionManager.VSPackage.ExtensionManagerPackage
Assembly: Microsoft.VisualStudio.ExtensionManager.Implementation, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
AllowsBackgroundLoad:
Guid: e7576c05-1874-450c-9e98-cf3a0897a069

Name: Scc Display Information
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Services.SccDisplayInformationPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: d7bb9305-5804-4f92-9cfe-119f4cb0563b

Name: Microsoft.VisualStudio.TeamFoundation.TeamFoundationHost
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.TeamFoundation.TeamFoundationHost
Assembly: Microsoft.VisualStudio.TeamFoundation, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Guid: b80b010d-188c-4b19-b483-6c20d52071ae

Name: Settings Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Services.Settings.SettingsPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: a2863a10-2269-4d3f-9e38-149c15926e1d

Name: Microsoft.VisualStudio.PlatformUI.SolutionNavigatorPackage
InprocServer32: C:\Windows\\SYSTEM32\\MSCOREE.DLL
Class: Microsoft.VisualStudio.PlatformUI.SolutionNavigatorPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: cf6a5c16-83b0-4d04-b702-195c35c6e887

Name: Remote Settings Service Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Services.RemoteSettings.RemoteSettingsPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 0b9ff418-9dfc-4c6b-a4c6-7f64f3f66f27

Name: Feature Flags Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Services.FeatureFlags.FeatureFlagsPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: 7ac58323-1325-44db-a4d5-2823a1426a13

Name: SqlCompletePackage
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Devart.DbForge.Integration.SqlCompletePackage
CodeBase: C:\Program Files (x86)\Devart\dbForge SQL Complete\Devart.DbForge.Integration.VS2017.r1.dll
Version: 6.8.13.0
AllowsBackgroundLoad:
Guid: e3d67c28-293c-4843-845f-97be1720cde7

Name: Windows Forms Designer Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.VSCorePackage
Assembly: Microsoft.VisualStudio,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: 7494682b-37a0-11d2-a273-00c04f8ef4ff

Name: SQL Language Services Package
Assembly: Microsoft.VisualStudio.Data.Tools.SqlLanguageServices, Version=15.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
InprocServer32: C:\Windows\\system32\\mscoree.dll
Class: Microsoft.VisualStudio.Data.Tools.SqlLanguageServices.Package
CodeBase: C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\Common7\IDE\Extensions\Microsoft\SQLEditor\Microsoft.VisualStudio.Data.Tools.SqlLanguageServices.dll
ID:
ProductName: Microsoft SQL Server Data Tools, T-SQL Language Services
CompanyName: Microsoft Corporation
Guid: ed19932f-5443-4587-a005-1cb9158b2f64

Name: Shell Common UI Package
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Class: Microsoft.VisualStudio.PlatformUI.CommonUIPackage
InprocServer32: C:\Windows\system32\mscoree.dll
Guid: f384b236-b4a9-401b-bc58-3106e3aca3ec

Name: Image Service Package
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.Services.ImageServicePackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: 1491e936-6ffe-474e-8371-30e5920d8fdd


Name: Visual Studio CRC package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.CommonIDE.VsLicensingStatePackage
Assembly: Microsoft.VisualStudio.CommonIDE,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 6b238c39-b163-467e-83db-a2dec10459ed

Name: ProviderPackage
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.Progression.ProviderPackage
Assembly: Microsoft.VisualStudio.GraphProviderPackage, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Guid: 5f2e5e42-4192-4d79-a0d8-1d881e808829

Name: Microsoft Visual Studio Tools for Applications 2017 Shell Integration Package
Assembly: Microsoft.VisualStudio.Tools.Applications.Package, Version=15.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a
Class: Microsoft.VisualStudio.Tools.Applications.Package.VstaPackage
InprocServer32: C:\Windows\system32\mscoree.dll
CodeBase: c:\program files (x86)\microsoft visual studio\2017\sql\common7\ide\extensions\ia24kh3e.v0t\Microsoft.VisualStudio.Tools.Applications.Package.dll
Guid: dd3eeb42-d065-4f65-a9f9-bd3d8c4a75ef

Name: Publish Subscribe Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.PlatformUI.PublishSubscribePackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: 50c54c45-bb03-4b06-a1a7-916074f3135d

Name: Microsoft.VisualStudio.Shell.Connected.Packages.PathTrustVerifier.PathTrustVerifierPackage
InprocServer32: C:\Windows\\SYSTEM32\\MSCOREE.DLL
Class: Microsoft.VisualStudio.Shell.Connected.Packages.PathTrustVerifier.PathTrustVerifierPackage
Assembly: Microsoft.VisualStudio.Shell.Connected,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 2f6b5046-3bb0-4825-b344-3f4238921119

Name: SqlStudio Profile Package
Assembly: Microsoft.VisualStudio.Data.Tools.Package.SqlProfile, Version=15.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Class: Microsoft.VisualStudio.Data.Tools.Package.SqlProfile.UI.DataPackageProfile
CodeBase: C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\Common7\IDE\Extensions\Microsoft\SQLDB\Microsoft.VisualStudio.Data.Tools.Package.SqlProfile.dll
CompanyName: Microsoft Corporation
ID:
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
ProductName: Microsoft SQL Server Data Tools, Profile
Guid: 00a9524f-427f-46ee-8a20-615c25ecbe6f

Name: Experimentation Service Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Services.Experimentation.VSExperimentationPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: c3c7e24f-26f7-49d8-a1d6-a9c4adcd9bc2

Name: Global Search Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.PlatformUI.GlobalSearchPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: 18333854-d2ff-44a3-98d8-40501b914d7d

Name: Start Page
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Class: Microsoft.VisualStudio.PlatformUI.StartPagePackage
InprocServer32: C:\Windows\system32\mscoree.dll
AllowsBackgroundLoad:
Guid: 0e13fc54-9231-410b-8b74-95689cd32627

Name: Visual Studio Build Manager Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.CommonIDE.BuildManager.BuildManagerPackage
Assembly: Microsoft.VisualStudio.CommonIDE,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: b718a162-0361-4b0e-920b-d88d70be609b

Name: VSTelemetryPackage
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.Telemetry.VSTelemetryPackage
Assembly: Microsoft.VisualStudio.Telemetry.Package,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: 54befe64-0558-4d8c-9fd5-ab0b54733b08

Name: Threaded Wait Dialog Package
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.Services.ThreadedWaitDialogService.ThreadedWaitDialogPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: d6afe069-ec5b-49ca-a0ba-24e3a591c908

Name: HostPackage
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.ComponentModelHost.HostPackage
Assembly: Microsoft.VisualStudio.ComponentModelHost.Implementation, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
AllowsBackgroundLoad:
Guid: 49d12072-378b-4ffa-a09e-40e0b5d097cc

Name: SccProviderPackage
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.TeamFoundation.Git.Provider.SccProviderPackage
Assembly: Microsoft.TeamFoundation.Git.Provider, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Guid: 7fe30a77-37f9-4cf2-83dd-96b207028e1b

Name: Microsoft.VisualStudio.Shell.Connected.AccountManagerService.AccountManagerPackage
InprocServer32: C:\Windows\\SYSTEM32\\MSCOREE.DLL
Class: Microsoft.VisualStudio.Shell.Connected.AccountManagerService.AccountManagerPackage
Assembly: Microsoft.VisualStudio.Shell.Connected,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 9c987e78-f0bf-45ca-9ba5-96d3e4b2bac6

Name: Microsoft SQL Server Data Tools
Assembly: Microsoft.VisualStudio.Data.Tools.Package, Version=15.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Class: Microsoft.VisualStudio.Data.Tools.Package.UI.DataPackage
CodeBase: C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\Common7\IDE\Extensions\Microsoft\SQLDB\Microsoft.VisualStudio.Data.Tools.Package.dll
CompanyName: Microsoft Corporation
ID:
InprocServer32: C:\Windows\\system32\\mscoree.dll
ProductName: Microsoft SQL Server Data Tools
Guid: 00fee386-5f9f-4577-99f4-f327fafc0fb9

Name: General diagnostics about the running VS session
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.PlatformUI.Diagnostics.DiagnosticsPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: 7d1a598c-4f97-4a83-a178-6b1bfcc7061e

Name: Microsoft.VisualStudio.Shell.Connected.Packages.OnlineLicensing.OnlineLicensingManagerPackage
InprocServer32: C:\Windows\\SYSTEM32\\MSCOREE.DLL
Class: Microsoft.VisualStudio.Shell.Connected.Packages.OnlineLicensing.OnlineLicensingManagerPackage
Assembly: Microsoft.VisualStudio.Shell.Connected,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: a5c25d8f-4d74-4924-bd8c-f3c2b860f4ec

Name: Roaming Manager Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Services.Roaming.RoamingManagerPackage
Assembly: Microsoft.VisualStudio.Shell.Connected,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 54888390-2c04-4b04-b451-3166730c75ba

Name: RestoreManagerPackage
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: NuGet.SolutionRestoreManager.RestoreManagerPackage
Assembly: NuGet.SolutionRestoreManager, Version=4.9.3.5777, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
AllowsBackgroundLoad:
Guid: 2b52ac92-4551-426d-bd34-c6d7d9fdd1c5

Name: SqlStudio Editor Package
Assembly: Microsoft.VisualStudio.Data.Tools.SqlEditor, Version=15.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Class: Microsoft.VisualStudio.Data.Tools.SqlEditor.VSIntegration.SqlEditorPackage
CodeBase: C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\Common7\IDE\Extensions\Microsoft\SQLEditor\Microsoft.VisualStudio.Data.Tools.SqlEditor.dll
CompanyName: Microsoft Corporation
ID:
InprocServer32: C:\Windows\\system32\\mscoree.dll
ProductName: Microsoft SQL Server Data Tools, TSql Editor
Guid: fef13793-c947-4fb1-b864-c9f0be9d9cf6

Name: Microsoft.VisualStudio.Shell.Connected.ConnectedUser.ConnectedUserPackage
InprocServer32: C:\Windows\\SYSTEM32\\MSCOREE.DLL
Class: Microsoft.VisualStudio.Shell.Connected.ConnectedUser.ConnectedUserPackage
Assembly: Microsoft.VisualStudio.Shell.Connected,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 7f679d93-2eb6-47c9-85eb-f6ad16902662

Name: Microsoft.VisualStudio.Editor.Implementation.EditorPackage
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Editor.Implementation.EditorPackage
ID:
Assembly: Microsoft.VisualStudio.Editor.Implementation,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
MinEdition: Standard
ProductVersion: 1.0
ProductName: Text
CompanyName: Microsoft
AllowsBackgroundLoad:
Guid: e269b994-ef71-4ce0-8bcd-581c217372e8

Name: Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPackage, Microsoft.VisualStudio.TeamFoundation.WorkItemTracking
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPackage
Assembly: Microsoft.VisualStudio.TeamFoundation.WorkItemTracking, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
ID:
MinEdition: Standard
ProductVersion: 15.0.0.0
ProductName: Work Item Tracking
CompanyName: Microsoft Corporation
Guid: ca39e596-31ed-4b34-aa36-5f0240457a7e

Name: Roaming Profiles Package
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.Services.Roaming.RoamingProfilesPackage
Assembly: Microsoft.VisualStudio.Shell.Connected,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: c194969a-a5b1-4af2-a9df-ecf7ce982a05

Name: Microsoft.VisualStudio.Services.Promotions.PromotionsPackage
InprocServer32: C:\Windows\\SYSTEM32\\MSCOREE.DLL
Class: Microsoft.VisualStudio.Services.Promotions.PromotionsPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: b596a79c-0044-4fc4-aaf6-a700b6fdc9ed

Name: Microsoft.VisualStudio.Shell.Connected.UserInformation.UserInformationPackage
InprocServer32: C:\Windows\\SYSTEM32\\MSCOREE.DLL
Class: Microsoft.VisualStudio.Shell.Connected.UserInformation.UserInformationPackage
Assembly: Microsoft.VisualStudio.Shell.Connected,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 5e80a5a1-b722-4727-9015-148aab6310b0

Name: File Change Manager Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Services.FileChangePackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: 4825b9a3-93e2-4327-9044-41f72ee7e5c9

Name: Tab Designer Launcher
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Services.TabDesignerLauncherPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: b4e787a4-a9fc-4579-945e-d71afec4dd90

Name: MRU Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.PlatformUI.MruPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 8ff5c2a8-5eba-4717-8ee1-46b6427d8ff3

Guid: 632ad3cd-d718-3fb1-bb05-df20f46b41f6

Name: SQL Designer Package
Assembly: Microsoft.Data.Relational.Design.Package.DesignerPackage, Microsoft.VisualStudio.Data.Tools.Relational.Design.Package, Version=15.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.Data.Relational.Design.Package.DesignerPackage
CodeBase: C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\Common7\IDE\Extensions\Microsoft\SQLDB\Designers\Microsoft.VisualStudio.Data.Tools.Relational.Design.Package.dll
ID:
CompanyName: Microsoft Corporation
ProductVersion: 15.1
ProductName: Microsoft SQL Server Data Tools - Table Designer Package
Guid: 74bc53b2-d9b7-4579-abe5-43d11a7ecd03

Name: File Change Manager Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Services.FileChangePackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: 4825b9a3-93e2-4327-9044-41f72ee7e5c9

Name: Microsoft.VisualStudio.Feedback.FeedbackPackage
InprocServer32: C:\Windows\\SYSTEM32\\MSCOREE.DLL
Class: Microsoft.VisualStudio.Feedback.FeedbackPackage
Assembly: Microsoft.VisualStudio.Shell.Connected,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: b22490b8-aa51-43b1-97ee-509a33b681f3

Name: Visual Studio Solution Telemetry Package
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.CommonIDE.SolutionTelemetryPackage
Assembly: Microsoft.VisualStudio.CommonIDE,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 05b0dcb8-5f74-4a94-ab2f-8b2354c977ef

Assembly: Microsoft.VisualStudio.ServerExplorer,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Class: Microsoft.VSDesigner.ServerExplorer.VsServerExplorerPackage
InprocServer32: C:\Windows\system32\mscoree.dll
Name: Microsoft Visual Studio Server Explorer Package
Guid: 198e76c1-34c0-424d-9957-b3ebd80265fb

Name: Microsoft.VisualStudio.Services.Integration.ServicesPackage, Microsoft.VisualStudio.Services.Integration
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Services.Integration.ServicesPackage
Assembly: Microsoft.VisualStudio.Services.Integration, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Guid: 0b93ccc5-bc52-40e9-91a3-7b8b58c4526b

Name: Task Status Center
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.TaskStatusCenter.TaskStatusCenterPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: edfbcdc9-574e-40e1-8167-b8aab25ac6cb

Name: SqlStudio Debugger Package
Assembly: Microsoft.VisualStudio.Data.Tools.SqlDebugger, Version=15.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Class: Microsoft.VisualStudio.Data.Tools.SqlDebugger.SqlDebugPackage
CodeBase: C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\Common7\IDE\Extensions\Microsoft\SQLEditor\Microsoft.VisualStudio.Data.Tools.SqlDebugger.dll
CompanyName: Microsoft Corporation
InprocServer32: C:\Windows\\system32\\mscoree.dll
ProductName: Microsoft SQL Server Data Tools, Sql Debugger
Guid: 9a62b3ca-5bdf-47cb-a406-3ceb946f1ddf

Name: Microsoft.VisualStudio.Services.UserNotifications.UserNotificationsPackage
InprocServer32: C:\Windows\\SYSTEM32\\MSCOREE.DLL
Class: Microsoft.VisualStudio.Services.UserNotifications.UserNotificationsPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: b89cd7d2-19db-4b60-a958-e882ae71a66e

Name: Rules-based UI contexts implementation
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.PlatformUI.UIContextRules.UIContextRulesPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: efaef2d3-8bdb-4d78-b3eb-b55e44203e80

Name: Task Scheduler Package
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.Services.TaskSchedulerPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Guid: 00cd9dda-7350-457c-a240-71bd667fc4de

Name: ConnectedServicesPackage
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.ConnectedServices.ConnectedServicesPackage
CodeBase: c:\program files (x86)\microsoft visual studio\2017\sql\common7\ide\extensions\zq2obtwo.o1j\Microsoft.VisualStudio.ConnectedServices.Package2.dll
AllowsBackgroundLoad:
Guid: 8e15f3da-b303-4af9-814a-1dc5c2583398

Name: Environment Package Window Management
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Platform.WindowManagement.WindowManagementPackage
Assembly: Microsoft.VisualStudio.Platform.WindowManagement,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 5e56b3db-7964-4588-8d49-d3523ab7bdb9

Name: Code Container Provider
InprocServer32: C:\Windows\system32\mscoree.dll
Class: Microsoft.VisualStudio.Services.CodeContainerProviderPackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 473077e0-2af9-4154-935c-cc50fd83db72


Name: CommonAzureToolsPackage
InprocServer32: C:\Windows\SYSTEM32\MSCOREE.DLL
Class: Microsoft.VisualStudio.WindowsAzure.CommonAzureTools.CommonAzureToolsPackage
CodeBase: c:\program files (x86)\microsoft visual studio\2017\sql\common7\ide\extensions\microsoft\windows azure tools\common\Microsoft.VisualStudio.WindowsAzure.CommonAzureTools.Package.dll
VWDExpressId:
WDExpressId:
MinEdition: Standard
ProductVersion: 1.10.0.0
ProductName: Microsoft Azure Common Tools
CompanyName: Microsoft Corporation
Guid: 1e863ae9-93f6-42fd-a301-d3391f876208

Name: Microsoft.Internal.VisualStudio.PlatformUI.Tipping.TippingServicePackage
InprocServer32: C:\Windows\\SYSTEM32\\MSCOREE.DLL
Class: Microsoft.Internal.VisualStudio.PlatformUI.Tipping.TippingServicePackage
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
AllowsBackgroundLoad:
Guid: 46c434ef-05d2-4c98-aaa2-37f9d07b5d82

Name: VS Setup Composition
InprocServer32: C:\Windows\system32\mscoree.dll
Assembly: Microsoft.VisualStudio.Shell.UI.Internal,version=15.0.0.0,publicKeyToken=b03f5f7f11d50a3a,culture=neutral
Class: Microsoft.VisualStudio.PlatformUI.SetupCompositionPackage
Guid: f92174fd-f10d-418b-819a-7433dea53833


=========================
Window Layout
=========================
Active document window: 'proc_load_stg_fct_Report_Cell_Solvency.sql ' (Code)
Active window: 'proc_load_stg_fct_Report_Cell_Solvency.sql '
Active document 'proc_load_stg_fct_Report_Cell_Solvency.sql '

Documents:
Name: 'proc_load_stg_fct_Report_Cell_Solvency.sql ', Caption: 'proc_load_stg_fct_Report_Cell_Solvency.sql ', Visible: True, Active view: 'Code', Initial view: ''

Toolwindows (visible or have been shown in current session):

=========================
Execution History
=========================
Store queries: True
Store period : 60 (days)
Available period : 60 (days)
Folder: %appdata%\Devart\dbForge SQL Complete\ExecutedQueries
Max script size: 10240 (KB)
Initial interval: Week
History folder content:
C:\Users\rest\AppData\Roaming\Devart\dbForge SQL Complete\ExecutedQueries\ExecutedQueries.db (831488 B)

alexa

Re: VS error SQL Complete

Post by alexa » Thu 01 Jul 2021 10:33

Could please provide us the CREATE definition of the object causing the issue?

Post Reply