All about sp_addlinkedserver syntax
- Get link
- Other Apps
sp_addlinkedserver linked 2 servers. Once sp_addlinkedserver query executes, query can be run against these servers.
Run below queries one by one to link, to provide login credentials and to access data
EXEC sp_addlinkedserver @server='ServerName'
EXEC sp_addlinkedsrvlogin 'ServerName', 'false', NULL, 'username', 'password'
select * from [ServerName].[DBName].[DBO].[TableName]
Once your requirement is done, you may drop the linking by running following query.
EXEC sp_dropserver 'ServerName', 'droplogins'
- Get link
- Other Apps
Popular
Top 30 ASP.Net Web API Interview Questions and Answers
In this blog, I have collected interview questions and answers of ASP.Net Web API.
CAML Query Tutorial for SharePoint 2013 and 2010 - A Complete tutorial guide
CAML Query is one of the most important topics in SharePoint. CAML Query is the way for querying items from SharePoint objects like List and Library. This blog is helpful in SharePoint 2010 development as well as in SharePoint 2013 development.
Create a static website using Angular7 step by step tutorial
In this blog, we will see how to create a static website in Angular 7? If you are new to Angular then please visit my earlier blog - Angular Tutorial.
ASP.Net Core CRUD example using ADO.Net
ASP.Net Web API Security
In the previous blog, I wrote about Routing in Web API. I have also explained, How to create a secure Web API? in my earlier blog. If you are new to ASP.Net Web API then please start from the beginning level. What is ASP.Net Web API?
In this blog, let's discuss the Web API security in details.
In this blog, let's discuss the Web API security in details.
What is Web API? When should we use in our projects?
Web API is the Microsoft open source technology for developing REST services based on HTTP protocol. ASP.Net Web API is a framework for building, consuming HTTP based service. The advantage of Web API is that it can be consumed by a wide range of clients like a web browser and mobile applications.
How to use multiple layout pages in MVC application
PowerShell Script to export SharePoint List in Excel File - SharePoint Tutorial
In this blog, I will write about "Export SharePoint list items using PowerShell Script".
Basic Authentication in Web API
How to consume RESTful APi from server side code - C#
Tags
Tags
cloud-computing12
sharepoint-201310
dot-net-core9
sql9
interview8
webservice7
angularjs6
entity-framework6
design-pattern5
linq5
sharepoint-programming5
powershell4
socialmedia4
caml3
rest3
workflow3
ajax2
aws2
html2
infopath2
javascript2
json2
oops2
searchservice2
sharepoint-interview2
soa2
timer job2
website2
3tier1
active-directory1
caching1
devops1
fba1
imageupload1
list1
managed-metadata-service1
metadata1
odata1
page-layout1
performance1
run with elevated1
safecontrol1
security1
sharepoint interview questions1
sharepoint security1
sharepoint-architecture1
sharepoint-branding1
sharepoint-migration1
sharepoint-service1
sharepoint-topics1
sharepointlist1
site-definition1
soap1
uls1
validation1
viewstate1
xml1
Show more
Show less
Comments
Post a Comment
Dear Readers, Please post your valuable feedback in the comment section if you like this blog or if you have any suggestions. I would love to hear the same from you. Thanks