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)
685 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)
685 reads
How to create and configure Sybase linked server in SQL Server 2005
2009-07-21 (first published: 2009-07-09)
658 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,753 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,756 reads
2009-12-17 (first published: 2008-07-13)
1,831 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,516 reads
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,343 reads
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
I have joined a new project, where the business uses Azure SQL Hyperscale for...
Dears, Hope this message finds you well I did not see in this foruns...
The below code works for backup files only from local drives. When replaced with...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers