Extract Objects of a Linked Server
In a scenario where we need to find out all the objects of a LINKED Server and check which object is accessible to us,
we need to write following query:
2009-08-07 (first published: 2009-07-20)
699 reads
In a scenario where we need to find out all the objects of a LINKED Server and check which object is accessible to us,
we need to write following query:
2009-08-07 (first published: 2009-07-20)
699 reads
How to create and configure Sybase linked server in SQL Server 2005
2009-07-21 (first published: 2009-07-09)
666 reads
Retrieve data from different data sources such as Analysis Services and SQL Server relational database as one dataset, so that you can create tables, matrices of that data.
2008-09-17
9,952 reads
This Proc is written for either SQL 2000 or SQL 2005 to return a list of objects that are dependent on Linked Servers. This proc checks all Databases and Objects on a Server.
2008-10-15 (first published: 2008-09-05)
1,811 reads
2009-12-17 (first published: 2008-07-13)
1,848 reads
This article demonstrates the negative affect that linked servers can cause in queries and offers alternatives to speed up performance.
2008-03-07
15,684 reads
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,357 reads
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
If I configure remote access to 0 on my servers, am I right in...
What is the best way to set the schedule of a maintenance plan or...
The LA Data Platform User Group had a necessary speaker cancellation for the group...
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers