| 
	
		| 
		
			|  | SoftTree Technologies Technical Support Forums
 |  |  
	
		| 
	
	
	
		| Author | Message |  
		| ezhovea 
 
 
 
 
			
				| Joined: 07 Jul 2016 Posts: 9
 Country: Russian Federation
 |  
 | 
			
				|  11.5 - bug with Visual studio 2019 |   |  
				| Dears, When I first time open the T-SQL editor (just a plain editor for SSDT scripts) in Visual Studio I receive two pop-up window with exceptions:
 First one:
 ----------------------------
 SQL Assistant - Error
 ---------------------------
 ServiceCache class not found in Microsoft.SqlServer.Express.VSIntegration
 ---------------------------
 ОК
 ---------------------------
 Second one immediately after the first:
 ---------------------------
 SQL Assistant - Error
 ---------------------------
 ScriptType type not found in Microsoft.SqlServer.Express.VSIntegration
 ---------------------------
 ОК
 ---------------------------
 
 After that everything works fine, but after MSVS restart is occures again.
 
 
 11.5.362 prof
 VisualStudio.16.Release/16.9.4+31205.134
 Microsoft .NET Framework Version 4.8.04084
 Installed Version: Professional
 SQL Server Data Tools   16.0.62103.10080
 
 BR, Evgeniy
 
 |  |  
		| Tue May 11, 2021 4:00 am |     |  
		|  |  
		| ezhovea 
 
 
 
 
			
				| Joined: 07 Jul 2016 Posts: 9
 Country: Russian Federation
 |  
 |  |  
		| Tue May 11, 2021 4:09 am |     |  
		|  |  
		| SysOp Site Admin
 
 
 
 
			
				| Joined: 26 Nov 2006 Posts: 7990
 
 |  
 | 
			
				|   |   |  
				| Does it work for you when you open SQL files using File/Open menu?  When opening procedure code from SQL Server Object Explorer or Database Explorer? 
 |  |  
		| Tue May 11, 2021 9:50 am |     |  
		|  |  
		| SysOp Site Admin
 
 
 
 
			
				| Joined: 26 Nov 2006 Posts: 7990
 
 |  
 | 
			
				|   |   |  
				| We managed to reproduce this issue.  The issue is specific to one particular editor type in VS which is different from everything else. That editor is invoked from Tools / SQL Server / New Query... menu,  it internally has a dependency on Microsoft.SqlServer.Express.VSIntegration component from SQL Server Express, which we currently don't expect/support in VS IDE. We will have it supported in the next version 12.0. 
 As a workaround for now, please use File / Open menu to open existing or new SQL file, or to edit existing procedures in the database, you can open them from the VS Database Explorer. We support both of them.
 
 |  |  
		| Thu May 13, 2021 10:03 am |     |  
		|  |  
		|  |  
  
	| 
 
 | You cannot post new topics in this forum You cannot reply to topics in this forum
 You cannot edit your posts in this forum
 You cannot delete your posts in this forum
 You cannot vote in polls in this forum
 
 |  |  |