I got it. It worked fine

Thank you for your help:

    EXEC sp_addlinkedserver @server=&#39;Servername&#39;

    EXEC sp_addlinkedsrvlogin &#39;Servername&#39;, &#39;false&#39;, NULL, &#39;username&#39;, &#39;password@123&#39;




Add the linked server first with

    exec sp_addlinkedserver
    @server = &#39;SNRJDI\SLAMANAGEMENT&#39;,
    @srvproduct=N&#39;&#39;,
    @provider=N&#39;SQLNCLI&#39;

See http://msdn.microsoft.com/en-us/library/ms190479.aspx


*I had  the same issue connecting an SQL_server 2008 to an SQL_server 2016 hosted in a remote server. @Domnic &#39;s answer didn&#39;t worked for me straightforward. I write my tweaked solution here as I think it may be useful for someone else.*

An extended answer for remote IP db connections:

**Step 1: Link servers**

    EXEC sp_addlinkedserver @server=&#39;SRV_NAME&#39;,
       @srvproduct=N&#39;&#39;,
       @provider=N&#39;SQLNCLI&#39;,   
       @datasrc=N&#39;aaa.bbb.ccc.ddd&#39;;
       
    EXEC sp_addlinkedsrvlogin &#39;SRV_NAME&#39;, &#39;false&#39;, NULL, &#39;your_remote_db_login_user&#39;, &#39;your_remote_db_login_password&#39;

...where `SRV_NAME` is an invented name. We will use it to refer to the remote server from our queries. `aaa.bbb.ccc.ddd` is the ip address of the remote server hosting your SQLserver DB.

**Step 2: Run your queries**
For instance:

    SELECT * FROM [SRV_NAME].your_remote_db_name.dbo.your_table

...and that&#39;s it!

Syntax details: [sp_addlinkedserver][1] and [sp_addlinkedsrvlogin][2]


  [1]: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedserver-transact-sql?view=sql-server-2017
  [2]: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedsrvlogin-transact-sql?view=sql-server-2017

FOR SQL SERVER

    EXEC sp_addlinkedserver @server=&#39;servername&#39; 

No need to specify other parameters. You can go through this [article][1]. 


  [1]: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedserver-transact-sql

-- check if server exists in table sys.server
	  
    select * from sys.servers

-- set database security 

		EXEC sp_configure &#39;show advanced options&#39;, 1
		RECONFIGURE
		GO

		EXEC sp_configure &#39;ad hoc distributed queries&#39;, 1
		RECONFIGURE
		GO

-- add the external dbserver
	 
    EXEC sp_addlinkedserver @server=&#39;#servername#&#39;

-- add login on external server 
	  
    EXEC sp_addlinkedsrvlogin &#39;#Servername#&#39;, &#39;false&#39;, NULL, &#39;#username#&#39;, &#39;#password@123&quot;&#39;

-- control query on remote table
		
    select top (1000) * from [#server#].[#database#].[#schema#].[#table#]

In java when an interface extends another interface:

 1. Why does it implement its methods?
 2. How can it implement its methods when an interface can&#39;t contain a
    method body
 3. How can it implement the methods when it extends the other interface
    and not implement it?
 4. What is the purpose of an interface implementing another interface?

This has major concepts in Java!

**EDIT:**  

    public interface FiresDragEvents {
    
      void addDragHandler(DragHandler handler);
    
      void removeDragHandler(DragHandler handler);
    }


    public interface DragController extends FiresDragEvents {
    
      void addDragHandler(DragHandler handler);
    
      void removeDragHandler(DragHandler handler);
    
      void dragEnd();
    
      void dragMove();
    }

**In eclipse there is the implement sign besides the implemented methods in `DragController`.**
   
**And when I mouse-hover it, it says that it implements the method!!!**

Interface extends another interface but implements its methods

This is useful when:

 - the server is down and the client can&#39;t connect for real-time sync
 - there is no Internet connectivity
 - the user doesn&#39;t want to go online but wants to work with application;


How can Meteor apps work offline?

I tried to insert values from one server to another server and I got the error: 

&gt; Msg 7202, Level 11, State 2, Line 1 Could not find server
&gt; &#39;SNRJDI\SLAMANAGEMENT&#39; in sysservers. Execute sp_addlinkedserver to
&gt; add the server to sysservers.

To add server using sp_addlinkedserver

<p>I tried to insert values from one server to another server and I got the error:</p>
<p>> Msg 7202, Level 11, State 2, Line 1 Could not find server
> 'SNRJDI\SLAMANAGEMENT' in sysservers. Execute sp_addlinkedserver to
> add the server to sysservers.</p>


I have this date format: 2011-09-28 18:01:00 (in varchar), and I want to convert it to datetime changing to this format 28-09-2011 18:01:00. How can I do it?

SQL Server Convert Varchar to Datetime

The following image is a part of Microsoft SQL Server 2008 R2 System Views. From the image we can see that the relationship between `sys.partitions` and `sys.allocation_units` depends on the value of `sys.allocation_units.type`. So to join them together I would write something similar to this:

    SELECT  *
    FROM    sys.indexes i
            JOIN sys.partitions p
                ON i.index_id = p.index_id 
            JOIN sys.allocation_units a
                ON CASE
                   WHEN a.type IN (1, 3)
                       THEN a.container_id = p.hobt_id 
                   WHEN a.type IN (2)
                       THEN a.container_id = p.partition_id
                   END 

But the upper code gives a syntax error. I guess that&#39;s because of the `CASE` statement. 
Can anyone help to explain a little?


---
Add error message:

&gt; Msg 102, Level 15, State 1, Line 6 Incorrect syntax near &#39;=&#39;.

![this is the image][1]


  [1]: http://i.stack.imgur.com/HYmiS.jpg

Can I use CASE statement in a JOIN condition?

I have a table called `countries` and I define the `country_name` column to be unique by creating a “Index/Key” of type “Unique Key” on SQL Server 2008 R2. 

But I have the following questions:

1. will creating “Index/Key” of type “Unique Key” automatically create a non-clustered index on this column?
2. if I change the type from being “Unique Key” to &quot;Index&quot; and I keep the `IsUnique` value to be &quot;Yes&quot;,, then will there be any differences ?
3. so why there are two options “Unique Key” and &quot;Index&quot; I think the two are the same ?

Unique key vs. unique index on SQL Server 2008

A column `height` is integer type in my SQL Server table. I want to do a division and have the result as decimal in my query:

    Select (height/10) as HeightDecimal

How do I cast so that the `HeightDecimal` is no longer integer? Thanks.

How to convert integer to decimal in SQL Server query?

I have two tables `Country` and `Capital`, I set `Capital`&#39;s primary key as foreign key which references `Country`&#39;s primary. But when I use Entity Framework database-first, the model is 1 to 0..1. 

How does one create a one-to-one relationship in SQL Server?

[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/uqP3U.png

How to Create a real one-to-one relationship in SQL Server

I have the following SQL query:

    DECLARE @MyVar datetime = &#39;1/1/2010&#39;    
    SELECT @MyVar

This naturally returns &#39;1/1/2010&#39;.

What I want to do is have a list of dates, say:

    1/1/2010
    2/1/2010
    3/1/2010
    4/1/2010
    5/1/2010

Then i want to FOR EACH through the numbers and run the SQL Query.

Something like (pseudocode):

    List = 1/1/2010,2/1/2010,3/1/2010,4/1/2010,5/1/2010

    For each x in List
    do
      DECLARE @MyVar datetime = x
    
      SELECT @MyVar

So this would return:-

   1/1/2010
    2/1/2010
    3/1/2010
    4/1/2010
    5/1/2010

I want this to return the data as one resultset, not multiple resultsets, so I may need to use some kind of union at the end of the query, so each iteration of the loop unions onto the next.


**edit**

I have a large query that accepts a &#39;to date&#39; parameter, I need to run it 24 times, each time with a specific to date which I need to be able to supply (these dates are going to be dynamic) I want to avoid repeating my query 24 times with union alls joining them as if I need to come back and add additional columns it would be very time consuming.

SQL Server FOR EACH Loop

How can I convert a String to a Date in T-SQL?

My test case is the string: `&#39;24.04.2012&#39;`

How to parse string into date?

I just added an identity column to an existing table with data through the `SSMS` Designer, the table updates fine and I can run a select query against it successfully, but after the query finishes I noticed that the new column is underlined in red with an error indicating it&#39;s an invalid column name.  

Why does this occur?  I would expect the query to fail if the column was invalid.  

Does the SSMS keep some type of internal reference to the old table that must be flushed?  

I tried closing the DB connection and reopening it, but still the same error.  Not sure what I&#39;m missing here.

    SELECT TOP 100 
    [PRIMARY_NDX_Col1],
    [NEW_Col], --QUERY EXECUTES SUCCESSFULLY, BUT THIS IS UNDERLINED RED AS AN INVALID COLUMN
    [Col3]
    FROM [dbo].[MyTable]

SQL Server Invalid Column name after adding new column

I&#39;ve been tasked with coming up with a means of translating the following data:

    date        category        amount
    1/1/2012    ABC             1000.00
    2/1/2012    DEF             500.00
    2/1/2012    GHI             800.00
    2/10/2012   DEF             700.00
    3/1/2012    ABC             1100.00

into the following:

    date        ABC             DEF             GHI
    1/1/2012    1000.00
    2/1/2012                    500.00
    2/1/2012                                    800.00
    2/10/2012                   700.00
    3/1/2012    1100.00

The blank spots can be NULLs or blanks, either is fine, and the categories would need to be dynamic. Another possible caveat to this is that we&#39;ll be running the query in a limited capacity, which means temp tables are out. I&#39;ve tried to research and have landed on `PIVOT` but as I&#39;ve never used that before I really don&#39;t understand it, despite my best efforts to figure it out. Can anyone point me in the right direction?

Content Type	Original Author	Original Content on Stackoverflow
Question	Domnic	View Question on Stackoverflow
Solution 1 - Sql Server	Domnic	View Answer on Stackoverflow
Solution 2 - Sql Server	hkf	View Answer on Stackoverflow
Solution 3 - Sql Server	MarcM	View Answer on Stackoverflow
Solution 4 - Sql Server	Rohan Bhutani	View Answer on Stackoverflow
Solution 5 - Sql Server	wike	View Answer on Stackoverflow

To add server using sp_addlinkedserver

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Solution 4 - Sql Server

Solution 5 - Sql Server

How can Meteor apps work offline?

Interface extends another interface but implements its methods

Attributions