As the others have said, there is only a 32 bit version.

The important thing is, if you’re running an x64-based SQL instance (64-bit), make sure to select “New Instance” on the Installation Type page, and NOT “Add features to an existing instance”. Not doing so will cause it to error out.

Only 32 bit version of SQL Server Data Tools published by Microsoft.

SQL Server comes in x32 and x64 but Visual Studio comes in only x32. 


So if you have `x64 SQL Server 2014`, you can only install `SQL Server Data Tools x32` in a new instance configuration. This will install `Visual Studio 2013 x32`. 


However if you have `SQL Server 2012`, `SQL Server Data Tools` are available in the installation media (unlike SQL 2014 where it has to be manually downloaded &amp; installed). 


How do I display all changes which I made using Chrome Developer tools?


**Example:**

 1. open a website.
 2. open *Chrome Developer Tool*.
 3. change style attribute of a tag.
 4. add new style to some css file.
 5. change a JavaScript function.

How to see those changes? Something like:
    
        page.html:56 Change style attribute of foo to bar.
        page.css:21 Lines added: 21,22,23,24.
        page.js:12 Line modified.

Show all changes made through Chrome Developer Tools

My question is a bit related to this: https://stackoverflow.com/questions/23395632/webapi-equivalent-for-httpcontext-items-with-dependency-injection. 

*We want to inject a class using HttpContext.Current in WebApi area using Ninject.*

My concern is, this could be **very dangerous**, as in WebApi (*everything?*) is async.

Please correct me if I am wrong in these points, this is what I investigated so far:

1. HttpContext.Current gets the current context by Thread (I looked into the implementation directly).

2. Using HttpContext.Current inside of async Task is not possible, because it can run on another Thread.

3. WebApi uses IHttpController with method `Task&lt;HttpResponseMessage&gt; ExecuteAsync` =&gt; every request is async =&gt; you cannot use HttpContext.Current inside of action method. It could even happen, more Request are executed on the same thread by coicidence.

4. For creating controllers with injected stuff into constructors `IHttpControllerActivator` is used with **sync** method `IHttpController Create`. This is, where ninject creates Controller with all its dependencies.

---

- If I am correct in all of these 4 points, using of `HttpContext.Current` inside of an action method or any layer below is very dangerous and can have unexpected results. I saw on StackOverflow lot of accepted answers suggesting exactly this. In my opinion this can work for a while, but will fail under load.

- But when using DI to create a Controller and its dependencies, it is Ok, because this runs on one separated thread. **I could get a value from the HttpContext in the constructor and it would be safe?**. I wonder if each Controller is created on single thread for every request, as this could cause problem under heavy loads, where all threads from IIS could be consumed.

*Just to explain why I want to inject HttpContext stuff:*

  - one solution would be to get the request in controller action method and pass the needed value all the layers as param until its used somewhere deep in the code.
  - our wanted solution: all the layers between are not affected by this, and we can use the injected request somewhere deep in code (e.g. in some `ConfigurationProvider` which is dependent on URL)
  
  
 Please give me your opinion if I am totally wrong or my suggestions are correct, as this theme seems to be very complicated.

Using HttpContext.Current in WebApi is dangerous because of async

I am having trouble finding the 64 bit version of Microsoft SQL Server Data Tools.

Does any one know where i can download the **64 bit version** of Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 and SQL Server 2014.

I have only been able to find the following 32 bit version http://www.microsoft.com/en-us/download/details.aspx?id=42313 but i need the 64 bit version.




64 bit Microsoft SQL Server Data Tools

I am having trouble finding the 64 bit version of Microsoft SQL Server Data Tools.
Does any one know where i can download the 64 bit version of Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 and SQL Server 2014.
I have only been able to find the following 32 bit version <a href="http://www.microsoft.com/en-us/download/details.aspx?id=42313" target="_blank" rel="noopener noreferrer">http://www.microsoft.com/en-us/download/details.aspx?id=42313</a> but i need the 64 bit version.

I know that you can&#39;t (at least not easily) restore a SQL Server 2012 backup on SQL Server 2008. But how does it work for SQL Server 2014 to SQL Server 2012 ?

On database level there is the property to adjust the compatibility mode to any other SQL Server version.

How does this helps or work ? Will it only disallow the features from 2014? 

To be honest I already tried to restore a backup, but 2012 didn&#39;t recognize the datafile, so I couldn&#39;t click `ok Button` to start the restore procedure.

Did I miss some important option ?

Possible to restore a backup of SQL Server 2014 on SQL Server 2012?

I&#39;m trying to add a table to my newly created database through SQL Server Management Studio.
However I get the error:

&gt; *the backend version is not supported to design database diagrams or tables*

To see my currently installed versions I clicked about in SSMS and this is what came up:

![enter image description here][1]


What&#39;s wrong here?


  [1]: http://i.stack.imgur.com/2rj6M.png

The backend version is not supported to design database diagrams or tables

I am trying to write an MS sql script that has a transaction and a try/catch block.  If it catches an exception, the transaction is rolled back.  If not, the transaction is committed.  I have seen a few different websites saying to do it like this:

    begin transaction
    begin try
        --main content of script here
    end try
    begin catch
        rollback transaction
    end catch

    commit transaction

But won&#39;t we still hit the &quot;commit transaction&quot; line even in the case of catching an exception?  Won&#39;t this lead to a SQL error because the transaction has already been rolled back?  I think it should be done like this:

    declare @success bit = 1

    begin transaction
    begin try
        --main content of script here
    end try
    begin catch
        rollback transaction
        set @success = 0
    end catch

    if(@success = 1)
    begin
        commit transaction
    end

Howcome the commonly-posted solution does not include the @success variable?  Is there no sql error that happens as a result of committing a transaction that has already been rolled back?  Am I incorrect in saying that the &quot;commit transaction&quot; line of the first code example will still be hit in the case of catching an exception?

sql try/catch rollback/commit - preventing erroneous commit after rollback

I&#39;m trying to import a flat file into an oledb target sql server database.

here&#39;s the field that&#39;s giving me trouble:

![enter image description here][1]

here are the properties of that flat file connection, specifically the field:

![enter image description here][2]

here&#39;s the error message:

&gt; [Source - 18942979103_txt [424]] Error: Data conversion failed. The
&gt; data conversion for column &quot;recipient-name&quot; returned status value 4
&gt; and status text &quot;Text was truncated or one or more characters had no
&gt; match in the target code page.&quot;.


What am I doing wrong?


  [1]: http://i.stack.imgur.com/CBYws.png
  [2]: http://i.stack.imgur.com/GTBcj.png

Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

    Select * from [User] U
    where  U.DateCreated = &#39;2014-02-07&#39;     

but in the database the user was created on `2014-02-07 12:30:47.220` and when I only put `&#39;2014-02-07&#39;`

It does not show any data

How to compare datetime with only date in SQL Server

In Visual Studio 2013 update 2 with Git integration, is there a way to show in the editor who last modified a line? (like the `git blame` command?)

How to show &#39;git blame&#39; in Visual Studio 2013?

I have a simple solution in visual studio 2013 that is composed by one web project, one library project and one unit test project. When I open the solution and try to run the unit tests they are not discover by visual studio. To run the tests I try to go to the menu and choose Test -&gt; Run -&gt; Run all tests or by opening the test explorer window. By those to methods visual studio doesn’t discover any tests in the solution.

Creating first a simple unit tests project and try to run the test, visual studio know discover the test and I can run it. Then, if I open my previous solution visual studio now discovers all the tests. I try to save my solution but closing it and reopening, without creating a unit test project first, the visual studio doesn’t find the tests again. This is a very strange behave that I don’t know why this is happening. 

I used to working alone in this project that was using the source control git integrated with the visual studio team foundation. The problem of visual studio not discover the unit tests start when a new element came to the project and when I need to recreate the solution through the source control online. Before this, all tests always been discovered by visual studio.

For creation the unit tests I use the dll Microsoft.VisualStudio.QualityTools.UnitTestFramework. My version of visual studio is: Microsoft Visual Studio Express 2013 for Web Version 12.0.30723.00 Update 3. My version of .net framework is 4.5.50938.

All of my tests are like this: 

    [TestClass] 
    public class Service1Test 
    { 
        [TestMethod] 
        public void Test1() 
        {
            Assert.IsTrue(True); 
        } 
    }

Visual Studio 2013 doesn&#39;t discover unit tests

I&#39;ve got a database project as part of my solution in Visual Studio 2013. Been working perfectly for the last 3 weeks and now suddenly today it won&#39;t build and so I cannot publish any changes. I&#39;m getting an MSBuild error: 

&gt; &quot;C:\Program Files
&gt; (x86)\MSBuild\Microsoft\VisualStudio\v12.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(513,5):
&gt; Error:  MSB4018: The &quot;SqlBuildTask&quot; task failed unexpectedly.
&gt;     System.MethodAccessException: Attempt by method &#39;Microsoft.Data.Tools.Schema.Sql.Build.SqlTaskHost.OnCreateCustomSchemaData(System.String,
&gt; System.Collections.Generic.Dictionary`2&lt;System.String,System.String&gt;)&#39;
&gt; to access method
&gt; &#39;Microsoft.Data.Tools.Components.Diagnostics.SqlTracer.ShouldTrace(System.Diagnostics.TraceEventType)&#39;
&gt; failed.&quot;

Anyone got any ideas? All I did this morning was pull down the latest changes from source control. I can&#39;t see how that would mess up the actual `MSBuild` process, and the guy who checked in last doesn&#39;t have any issues at all. 


Visual Studio 2013: Database Project MSBuild error

I created a new SQL Server Database Project in VS2013 (Update 3) and attempted to build but it fails.  The only build output I receive follows:

    ------ Build started: Project: Database1, Configuration: Debug Any CPU ------
    	Creating a model to represent the project...
    Done building project &quot;Database1.sqlproj&quot; -- FAILED.
    
    Build FAILED.
    ========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========

If I build the project via MSBuild.exe with detail verbosity I see the following inner failure:

    Task &quot;SqlBuildTask&quot;
      Creating a model to represent the project...
    Done executing task &quot;SqlBuildTask&quot; -- FAILED.

After searching the web I have tried the following to resolve this to no avail:

-Restart VS 

-Restart machine

-Repair VS Update 3 and reboot

-Repair VS2013 and reboot


What am I missing?

VS2013 Database Project fails to build

I accidentally closed the Immediate Window in Visual Studio 2013 Update 3, and can&#39;t for the life of me figure out how/where to get it back.

Can someone please point out how I get the Immediate Window open again?

Content Type	Original Author	Original Content on Stackoverflow
Question	StackTrace	View Question on Stackoverflow
Solution 1 - Sql Server	g2server	View Answer on Stackoverflow
Solution 2 - Sql Server	mehdi lotfi	View Answer on Stackoverflow
Solution 3 - Sql Server	AbdullahRaz	View Answer on Stackoverflow

64 bit Microsoft SQL Server Data Tools

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Using HttpContext.Current in WebApi is dangerous because of async

Show all changes made through Chrome Developer Tools

Attributions