How to access my database from another server

DB: SQL Server 2008

I have two servers A and B. I want to able to insert data from server A into server B using a particular user. What is the syntax for doing that?

Solution

You can use sp_addlinkedserver and sp_addlinkedsrvlogin.

How can I efficiently convert a bigint into a base 2 string and count the 1s?
Create Table Computed Value
How to place FK constraint so that deleting a single FK record DOES NOT delete the primary record
Why can't I just use "HAVING" clause all the time instead of "WHERE"? It works the same basically if you use it before/without "GROUP BY"
Remove constraints in sequelize migration
Calculate Count of true bits in binary type with t-sql
SQL Server Operating system error 5: "5(Access is denied.)"
Modelling a Meals / Recipes / Foods database
Shapiro-Wilk test
Select rows for a specific date using TIMESTAMP datatype
How do I DELETE with WHERE and IN using a composite primary key?
String Matching Struggle
SQL-Server: Error - Exclusive access could not be obtained because the database is in use
Apache Spark: "with as" vs "cache"
What COLLATE should i set to use all kind of possible languages?
Authenticate from Linux to Windows SQL Server with pyodbc
SQL query to return total and percentage calculation grouped by day
MYSQL - SELECT NULL otherwise latest DATE per group
Add an incremental categorical column
PostgreSQL Crosstab Query
WHERE clause that needs to be NULL or NOT NULL
A mathematical way to divide overlapping time ranges into hours
Replacing window function OVER() with WINDOW clause reference yields different results
#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
Dateadd for moving 7 day avg VS (partition by price order by date rows between 6 preceding and current row)
SQL Server does not exist or access denied
Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Checking if a value exists in database
Redshift GROUP BY ALL syntax not supported
Sum by ID in another table