Setup the SQL Database development environment in VS2015

To setup the SQL Database development environment in VS2015, SQL Server Data Tools (SSDT) is required. Follow the link below to download and install:
https://msdn.microsoft.com/en-us/mt186501.aspx

Comments

Post a Comment

Popular posts from this blog

Error - vbe6ext.olb could not be loaded

Issue description: The target PC has both Office 2010 and 2016 installed, after uninstalled the Office 2016, and open an Excel Spreadsheet, the above error happened. Fix: Go to below folder: C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6 Rename the file "VBE6EXT.OLB" to "VBE6EXT.OLD”. Open Excel again, click Alt+F11, a popup window prompting for repairing, click "Yes". After repair completed, the problem is fixed also.
Read more

Visual Studio $(TargetDir) macro is empty

I encounter this issue in VS2017, it shall apply to older version also. To repeat the issue: 1. Create a PreBuildEvent, and type below script echo TargetDir = "$(TargetDir)" 2.  Build the project, you will see: TargetDir = "" Solution: Open the project file with a text editor, then remove the PreBuildEvent section, including the outer <PropertyGroup>. Then re-add the Pre Build Events using Visual Studio.   <PropertyGroup>     <PreBuildEvent>          <!-- Pre build commands go here -->     </PreBuildEvent>   </PropertyGroup>
Read more

VBA codes showing the list of users who open the shared workbook

Image
VBA codes showing the list of users who open the shared workbook: ThisWorkbook: Private Sub Workbook_Open()     Application.OnKey "{F2}", "UsersInfo"     UsersInfo End Sub Module1: Public Sub UsersInfo()     Users = ActiveWorkbook.UserStatus         Dim sMsg As String         Dim nLen1 As Integer Dim nLen2 As Integer     nLen1 = 0 nLen2 = 0     For Row = 1 To UBound(Users, 1)         If Len(Users(Row, 1)) > nLen1 Then             nLen1 = Len(Users(Row, 1))         End If         If Len(Users(Row, 2)) > nLen2 Then             nLen2 = Len(Users(Row, 2))         End If   ...
Read more