Contents
Which SQL Server is best for Visual Studio 2010?
SQL Server 2008 R2
Visual Studio 2010 is compatible with SQL Server 2008 R2 so things should just work. Note that Visual Studio 2010 does not install R2, so you will need to download it separately if you want to try it out.
Where do MSI logs go?
The log file, Msi. log, appears in the Temp folder of the system volume. For more information about MSI logging, see Windows Help. To do this, search by using the phrase msi logging, and then select Managing options for computers through Group Policy.
How do I run a SQL query in Visual Studio 2010?
You can run the query by right-clicking the designer and selecting Execute SQL. You can develop T-SQL scripts and other database objects in VS 2010 via the T-SQL editor, which provides full T-SQL IntelliSense as well as T-SQL debugging. You can start the T-SQL editor in several ways.
How do I create a data connection in Visual Studio 2010?
Open Visual Studio 2010 then open Server Explorer. Click on Connect to database. It will open an Add Connection window as in the following image. There you need to provide the username that comes automatically if you click on refresh, if not come then specify your server name.
How to install Visual Studio 2010 Service Pack 1?
Insert or attach your original installation media or network location for the product referenced in the caption. Return to the prompt dialog, click the Browse button, and browse to the root of the installation media above. Select vs_setup.msi (the file name must match) and click Open to continue.
Is there a problem installing Visual Studio 2005?
I’m having a problem installing installing Visual Studio 2005. When it pops up the first screen on the waizrd and popup appears saying “The Windows Installer package: d:\\vs_setup.msi could not be open” Any suggestions? this may/may not help you in resolving the problem.
Is there a workaround for installing VS2010 SP1?
If you’re running into this issue with other MSI files when installing VS2010 SP1, please comment below. This workaround also may apply to any other language for the Visual Studio 2010 Shell (Integrated), and the instructions are similar for Visual Studio 2010 Shell (Isolated) through the download location and file names will be different.
Do you need Visual Studio bi for SQL Server?
You will need to download Visual Studio 2012 SSDT-BI or 2013, these support BI projects for SQL Server 2012 and 2014 respectively. BI 2010 came with SQL 2012 standard edition install file. I was able to install.