If you are working on a website then there might be a chance to handle a large amount of data on a public site. Generally, we are binding code with Gridview like this: Gridview1.Datasource = dataset; GridView.DataBind();

In this blog, we will see Active Directory Programming using C# code. In other blogs, you can read ASP.Net Tutorial , . Net Core Tutorial. We will first understand - What is Active Directory?

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'