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)
696 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)
696 reads
How to create and configure Sybase linked server in SQL Server 2005
2009-07-21 (first published: 2009-07-09)
665 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,897 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,795 reads
2009-12-17 (first published: 2008-07-13)
1,842 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,630 reads
Query Servers using 1 sql statement. Will make your job easy!!!
2012-03-28 (first published: 2008-01-16)
3,350 reads
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
Comments posted to this topic are about the item Sparse Column Defaults
Comments posted to this topic are about the item The AI Budget Assistant
Comments posted to this topic are about the item Why Standards are Important
What are the restrictions for defaults on columns declared as sparse?
See possible answers