Set Up a Single PC for Remote Access

RELATED: How to Forward Ports on Your Router

The process is pretty straightforward if you just have one PC you want to make accessible over the internet. The PC on which you set up Remote Desktop is already listening for traffic using the Remote Desktop Protocol (RDP). You’ll need to log into your router and have it forward all traffic using TCP port 3389 to the IP address of the PC running Remote Desktop. Since routers have different interfaces, it’s impossible to give instructions specific to you. But for more detailed help, be sure to check out our in-depth guide to port forwarding. Here, we’re just going to run through a quick example using a basic router.

Insert data table data in Table

create procedure Sp_TableDataInsert
@TempTable TypeTable READONLY
As
Begin
SET IDENTITY_INSERT TableName ON
insert into Table (Column1, Column2 , Column3 , Column4 )
select Column1 , Column2 , Column3 , Column4 from @ TempTable
SET IDENTITY_INSERT TableName OFF
End