Insert records into an existing table from another table
INSERT INTO MyTable (PriKey, Description)
SELECT ForeignKey, Description
FROM SomeView;
To create a new table from values in another table, you can use SELECT INTO. For example:
SELECT LastName, FirstName, Phone
INTO dbo.PhoneList492
FROM dbo.Customers
WHERE Phone LIKE '492%'
Insert Unicode into a table
Insert State values ('CA', 'California', N'加州', 1)
SQL Server Replication
Replication Compatibility in Different Versions
Suppported SQL Server versions in Replication
Setup Replication Official Tutorial
https://docs.microsoft.com/en-us/sql/relational-databases/replication/lesson-1-creating-windows-accounts-for-replication?view=sql-server-2014
Find sqlagent.out file location
USE MASTER
GO
EXEC msdb..sp_get_sqlagent_properties
GO
Move database to another drive
Errors
Cannot obtain exclusive access when restoring database:
Solution:
alter database your_db_name set offline with rollback immediate
alter database your_db_name set online