Getting an error when I ran the query 
DECLARE @sql nvarchar(1000)
DECLARE @ColumnName nvarchar(75)
DECLARE @TableName nvarchar(75)
SELECT @ColumnName = name from sys.columns
SELECT @TableName...

I did understand the concept. Thanks a lot. I appreciate it.

Thanks Drew for the query, worked beautifully. My development skills are still in developing stage so I am not sure what this query is doing even though it is working....

Had to ask. Thanks.

of course. Silly me. Its all good.

Done
update [Staging].[StgContactdata]
set CompanyNid = REPLACE(CompanyNid, char(9),'')

update [PMG].[Contactdata]
set CompanyNids = convert(int,s.CompanyNid)
FROM [PMG].[Contactdata] c
join [Staging].[StgContactdata] s on c.ContactNids = s.ContactNid
where...

https://www.acronis.com/en-us/
Just going to read about it.

I must have been doing something wrong but I was able to run setspn command successfully. So now I am able to access the linked server without getting any error,...

So I ran this query and I m looking at some connection using NTLM (for local machine) , some Kerberos and some SQL.
select session_id,net_transport,client_net_address,auth_scheme from sys.dm_exec_connections
I...