Linked Servers are an interesting technology in SQL Server to allow remote access from within the database to external data sources. They can be a boon in a heterogenous environment with other Oracle, DB2, etc. data sources. But they can also help in a smaller scale against those "hidden" datasources like Excel or Access. New Author Krishna.
2007-06-08 (first published: 2004-06-02)
47,240 reads
2004-10-29
2,669 reads
If we give SP_HELP , we'll know to which File Group the table belongs.If we give SP_HELPFILEGROUP , we'll know the logical and physical file names along with other information that belong to the given File Group. But have you ever tried that, given a file group, how to find all the tables that belong […]
2004-05-10
131 reads
It is a very simple but useful SP to get Trigger and related table info especially on databases having large number of tables.
2002-09-19
321 reads
By HamishWatson
This blog post is around the changing landscape of both SQL Server and the...
By damianwidera
This is the second article in the Machine Learning area. I have explained a...
In this article, we will focus on creating a data pipeline to ETL (Extract,...
Comments posted to this topic are about the item Container Ports
Similar to the one mentioned in the below article. We are sql server build...
Hello, I have a task for which I wasn't able to find much information...
Ask SSC