In the _Solution Explorer_:

 - right click on _yourTable.sql_ table definition
 - click on _Open with..._
 - choose _Microsoft SQL Server Data Tools, T-SQL Editor_
 - click on _Set as Default_
 - click _Ok_

The steps above will insure that you always will open the table definitions with the T-SQL editor. You can revert back to the default setting by choosing the _Microsoft SQL Server Data Tools, Editor Selector_.

When a marker is clicked, the default behavior for the camera is to center it on screen, but because I usually have long text description in the info window, it&#39;s more convenient to actually change the camera position so that the marker is on the bottom of screen(making the info window in the center of screen). I think I should be able to do that by overriding onMarkerClick function like below (the default behavior is cancelled when this function return true)


    @Override

	public boolean onMarkerClick(final Marker marker) {
		 

		// Google sample code comment : We return false to indicate that we have not
                
        // consumed the event and that we wish
		// for the default behavior to occur (which is for the camera to move
		// such that the
		// marker is centered and for the marker&#39;s info window to open, if it
		// has one).

		marker.showInfoWindow();
		 
                CameraUpdate center=
			        CameraUpdateFactory.newLatLng(new LatLng(XXXX,
			                                                 XXXX));
                mMap.moveCamera(center);//my question is how to get this center
		
                // return false;
		return true;
	}

Edit:

Problem solved using accepted answer&#39;s steps, codes below:

  

    @Override
    
    	public boolean onMarkerClick(final Marker marker) {
    		 
                    //get the map container height
    		LinearLayout mapContainer = (LinearLayout) findViewById(R.id.map_container);
    		container_height = mapContainer.getHeight();
    		
    		Projection projection = mMap.getProjection();
    
    		LatLng markerLatLng = new LatLng(marker.getPosition().latitude,
    				marker.getPosition().longitude);
    		Point markerScreenPosition = projection.toScreenLocation(markerLatLng);
    		Point pointHalfScreenAbove = new Point(markerScreenPosition.x,
    				markerScreenPosition.y - (container_height / 2));
    
    		LatLng aboveMarkerLatLng = projection
    				.fromScreenLocation(pointHalfScreenAbove);
    
    		marker.showInfoWindow();
    		CameraUpdate center = CameraUpdateFactory.newLatLng(aboveMarkerLatLng);
    		mMap.moveCamera(center);
    		return true;
    
    
    		 
    	}

Thanks for helping ^ ^

How to center the camera so that marker is at the bottom of screen? (Google map api V2 Android)

I&#39;ve read many articles and posts related to Tomcat and the Java runtime. I am confused and need help. Can anybody clear my doubt regarding whether Tomcat requires JDK or JRE? 

Thanks in advance.

Does Tomcat require JDK or JRE?

I have recently upgraded my database projects to **VS2012** and am now faced with the abomination of the **table designer** (I&#39;m sure there are people that love it, but I am a Sql developer and find coding table definitions by hand &lt;i&gt;much&lt;/i&gt; faster).  Is there any way of turning the damned thing off?  I have tried (well believe I have) all the options under ***Tools -&gt; Options -&gt; Database Tools with no effect.***

Things attempted
----------------

 1. I&#39;ve attempted to remove the Designer from the **&quot;&lt;i&gt;C:\Program
    Files (x86)\Microsoft Visual Studio
    11.0\Common7\IDE\Extensions\Microsoft\SQLDB\Designers&lt;/i&gt;&quot;** directory, but that just caused errors when attempting to open a
    table script.
 2. I&#39;ve attempted to rename the registry key pointing to the designer
    **(&lt;i&gt;HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\11.0_Config\Packages\{74bc53b2-d9b7-4579-abe5-43d11a7ecd03}&lt;/i&gt;)**
    but the registry key magically renames itself and comes back.

Disable Table Designer in Visual Studio

I have recently upgraded my database projects to VS2012 and am now faced with the abomination of the table designer (I'm sure there are people that love it, but I am a Sql developer and find coding table definitions by hand much faster). Is there any way of turning the damned thing off? I have tried (well believe I have) all the options under Tools -> Options -> Database Tools with no effect.
<h4 id="things-attempted"><a aria-hidden="true" tabindex="-1" href="#things-attempted"></a>Things attempted</h4>
<ol>
<li>I've attempted to remove the Designer from the "C:\Program
Files (x86)\Microsoft Visual Studio
11.0\Common7\IDE\Extensions\Microsoft\SQLDB\Designers" directory, but that just caused errors when attempting to open a
table script.</li>
<li>I've attempted to rename the registry key pointing to the designer
(HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\11.0_Config\Packages{74bc53b2-d9b7-4579-abe5-43d11a7ecd03})
but the registry key magically renames itself and comes back.</li>
</ol>

Is there a way to set by default for all projects removing the precompiler secure warnings that come up when using functions like scanf(). I found that you can do it by adding a line in the project option or a `#define _CRT_SECURE_NO_WARNINGS` in the beginning of the code.

I find myself repeatedly creating new projects for solving programming contests and it is really annoying (and takes valuable time) to add:

    #ifdef _MSC_VER
    #define _CRT_SECURE_NO_WARNINGS
    #endif

In the beginning of the code, or to set it in the precompiler options every time I start a new project.

Remove secure warnings (_CRT_SECURE_NO_WARNINGS) from projects by default in Visual Studio

I have installed MS SQL Server 2008 R2 and when I try to update model from database under EDMX file I am facing that error.

&gt; Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc
&gt; version 11.0.0.0

I  have tried to install Microsoft SQL Server 2008 R2 Shared Management Objects [from here][1] but no joy.


  [1]: http://www.microsoft.com/en-us/download/confirmation.aspx?id=16978

Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0

First of all, I know this question is all over this site but I have looked at almost all of them and can&#39;t seem to find out what is wrong. This is in VS 2012. Thanks.

    //Socket.h
    #pragma once
    
    #include &lt;iostream&gt;
    #include &lt;WinSock2.h&gt;
    
    using namespace std;
    
    const int STRLEN = 256;
    
    class Socket
    {
        protected:
            WSADATA wsaData;
            SOCKET mySocket;
            SOCKET myBackup;
            SOCKET acceptSocket;
            sockaddr_in myAddress;
        public:
            Socket();
            ~Socket();
            bool SendData( char* );
            bool RecvData( char*, int );
            void CloseConnection();
            void GetAndSendMessage();
    };
    
    class ServerSocket : public Socket
    {
        public:
            void Listen();
            void Bind( int port );
            void StartHosting( int port );
    };
    
    class ClientSocket : public Socket
    {
        public:
            void ConnectToServer( const char *ipAddress, int port );
    };
Here&#39;s Socket.cpp

    //Socket.cpp
 

    #include &quot;stdafx.h&quot;
    #include &quot;Socket.h&quot;

    
    Socket::Socket()
    {
        if( WSAStartup( MAKEWORD(2, 2), &amp;wsaData ) != NO_ERROR )
        {
            cerr&lt;&lt;&quot;Socket Initialization: Error with WSAStartup\n&quot;;
            system(&quot;pause&quot;);
            WSACleanup();
            exit(10);
        }
    
        //Create a socket
        mySocket = socket( AF_INET, SOCK_STREAM, IPPROTO_TCP );
    
        if ( mySocket == INVALID_SOCKET )
        {
            cerr&lt;&lt;&quot;Socket Initialization: Error creating socket&quot;&lt;&lt;endl;
            system(&quot;pause&quot;);
            WSACleanup();
            exit(11);
        }
    
        myBackup = mySocket;
    }
    
    Socket::~Socket()
    {
        WSACleanup();
    }
    
    bool Socket::SendData( char *buffer )
    {
        send( mySocket, buffer, strlen( buffer ), 0 );
        return true;
    }
    
    bool Socket::RecvData( char *buffer, int size )
    {
        int i = recv( mySocket, buffer, size, 0 );
        buffer[i] = &#39;\0&#39;;
        return true;
    }
    
    void Socket::CloseConnection()
    {
        //cout&lt;&lt;&quot;CLOSE CONNECTION&quot;&lt;&lt;endl;
        closesocket( mySocket );
        mySocket = myBackup;
    }
    
    void Socket::GetAndSendMessage()
    {
        char message[STRLEN];
        cin.ignore();//without this, it gets the return char from the last cin and ignores the following one!
        cout&lt;&lt;&quot;Send &gt; &quot;;
        cin.get( message, STRLEN );
        SendData( message );
    }
    
    void ServerSocket::StartHosting( int port )
    {
         Bind( port );
         Listen();
    }
    
    void ServerSocket::Listen()
    {
        //cout&lt;&lt;&quot;LISTEN FOR CLIENT...&quot;&lt;&lt;endl;
        
        if ( listen ( mySocket, 1 ) == SOCKET_ERROR )
        {
            cerr&lt;&lt;&quot;ServerSocket: Error listening on socket\n&quot;;
            system(&quot;pause&quot;);
            WSACleanup();
            exit(15);
        }
        
        //cout&lt;&lt;&quot;ACCEPT CONNECTION...&quot;&lt;&lt;endl;
        
        acceptSocket = accept( myBackup, NULL, NULL );
        while ( acceptSocket == SOCKET_ERROR )
        {
            acceptSocket = accept( myBackup, NULL, NULL );
        }
        mySocket = acceptSocket;
    }
    
    void ServerSocket::Bind( int port )
    {
        myAddress.sin_family = AF_INET;
        myAddress.sin_addr.s_addr = inet_addr( &quot;0.0.0.0&quot; );
        myAddress.sin_port = htons( port );
        
        //cout&lt;&lt;&quot;BIND TO PORT &quot;&lt;&lt;port&lt;&lt;endl;
    
        if ( bind ( mySocket, (SOCKADDR*) &amp;myAddress, sizeof( myAddress) ) == SOCKET_ERROR )
        {
            cerr&lt;&lt;&quot;ServerSocket: Failed to connect\n&quot;;
            system(&quot;pause&quot;);
            WSACleanup();
            exit(14);
        }
    }
    
    void ClientSocket::ConnectToServer( const char *ipAddress, int port )
    {
        myAddress.sin_family = AF_INET;
        myAddress.sin_addr.s_addr = inet_addr( ipAddress );
        myAddress.sin_port = htons( port );
        
        //cout&lt;&lt;&quot;CONNECTED&quot;&lt;&lt;endl;
    
        if ( connect( mySocket, (SOCKADDR*) &amp;myAddress, sizeof( myAddress ) ) == SOCKET_ERROR )
        {
            cerr&lt;&lt;&quot;ClientSocket: Failed to connect\n&quot;;
            system(&quot;pause&quot;);
            WSACleanup();
            exit(13);
        } 

    }

And here&#39;s stdafx.h

    #pragma once
    
    #include &quot;targetver.h&quot;
    
    #define WIN32_LEAN_AND_MEAN             // Exclude rarely-used stuff from Windows headers
    // Windows Header Files:
    #include &lt;windows.h&gt;
    
    // C RunTime Header Files
    #include &lt;stdlib.h&gt;
    #include &lt;malloc.h&gt;
    #include &lt;memory.h&gt;
    #include &lt;tchar.h&gt;
    
    
    // TODO: reference additional headers your program requires here
    #include &quot;Socket.h&quot;

And here are my error messages:

    1&gt;------ Build started: Project: Client, Configuration: Debug Win32 ------
    1&gt;  stdafx.cpp
    1&gt;  Socket.cpp
    1&gt;  Client.cpp
    1&gt;  Generating Code...
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__accept@12 referenced in function &quot;public: void __thiscall ServerSocket::Listen(void)&quot; (?Listen@ServerSocket@@QAEXXZ)
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__bind@12 referenced in function &quot;public: void __thiscall ServerSocket::Bind(int)&quot; (?Bind@ServerSocket@@QAEXH@Z)
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__closesocket@4 referenced in function &quot;public: void __thiscall Socket::CloseConnection(void)&quot; (?CloseConnection@Socket@@QAEXXZ)
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__connect@12 referenced in function &quot;public: void __thiscall ClientSocket::ConnectToServer(char const *,int)&quot; (?ConnectToServer@ClientSocket@@QAEXPBDH@Z)
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__htons@4 referenced in function &quot;public: void __thiscall ServerSocket::Bind(int)&quot; (?Bind@ServerSocket@@QAEXH@Z)
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__inet_addr@4 referenced in function &quot;public: void __thiscall ServerSocket::Bind(int)&quot; (?Bind@ServerSocket@@QAEXH@Z)
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__listen@8 referenced in function &quot;public: void __thiscall ServerSocket::Listen(void)&quot; (?Listen@ServerSocket@@QAEXXZ)
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__recv@16 referenced in function &quot;public: bool __thiscall Socket::RecvData(char *,int)&quot; (?RecvData@Socket@@QAE_NPADH@Z)
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__send@16 referenced in function &quot;public: bool __thiscall Socket::SendData(char *)&quot; (?SendData@Socket@@QAE_NPAD@Z)
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__socket@12 referenced in function &quot;public: __thiscall Socket::Socket(void)&quot; (??0Socket@@QAE@XZ)
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__WSAStartup@8 referenced in function &quot;public: __thiscall Socket::Socket(void)&quot; (??0Socket@@QAE@XZ)
    1&gt;Socket.obj : error LNK2019: unresolved external symbol __imp__WSACleanup@0 referenced in function &quot;public: __thiscall Socket::Socket(void)&quot; (??0Socket@@QAE@XZ)
    1&gt;C:\Users\ajayp_000\documents\visual studio 2012\Projects\Client\Debug\Client.exe : fatal error LNK1120: 12 unresolved externals
    ========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========



Unresolved external symbol LNK2019

&gt; Unexpected error detected. Check the Tests Output Pane for details.

Where is the &#39;Tests Output Pane&#39;? I can&#39;t find it anywhere in Visual Studio. I found &#39;Test *Explorer*&#39; but it doesn&#39;t show any details.

Where is the &#39;Tests Output Pane&#39;?

I have an ASP.NET MVC 4 app developed in VS 2012.  The app consists of a main project (MyProject), a unit-test project (MyProject.Tests), an Azure deployment project (MyProject.Azure), and a couple of general-purpose library projects.

When I right-click on either the solution or the main project and select Manage NuGet Packages, I see a bunch of Microsoft updates that have apparently become available in the last month or so.  If I click on the Update All button then the updates are apparently installed without any obvious problems, but when I build the solution I get this error message TWICE:

    warning : All projects referencing MyProject.csproj must install nuget package Microsoft.Bcl.Build

Ok, so I have two projects that reference MyProject: MyProject.Tests and MyProject.Azure. I can right-click MyProject.Tests, select ManageNuGet Packages, and add Microsoft.Bcl.Build. That gets rid of one of the two warnings. But **VS does not give me an option to manage NuGet packages for the MyProject.Azure project**.

How do I add the Microsoft.Bcl.Build package to the Azure deployment project?

EDIT:

Thanks to user [swell][1], I now know that a Microsoft Connect issue for this problem has been opened [here][2].


  [1]: https://stackoverflow.com/users/1026105/swell
  [2]: http://connect.microsoft.com/VisualStudio/feedback/details/789839/unexpected-warning-when-building-solution-that-has-azure-cloud-services-and-a-reference-to-the-microsoft-bcl-build-nuget-package

Content Type	Original Author	Original Content on Stackoverflow
Question	John O	View Question on Stackoverflow
Solution 1 - Visual Studio	Alex Filipovici	View Answer on Stackoverflow

Disable Table Designer in Visual Studio

Visual Studio Problem Overview

Things attempted

Visual Studio Solutions

Solution 1 - Visual Studio

Does Tomcat require JDK or JRE?

How to center the camera so that marker is at the bottom of screen? (Google map api V2 Android)

Attributions