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,260 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
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...
By damianwidera
This is the sixth interview we have done. This time our guest is Greg...
By Arun Sirpal
I want to do a quick summary post of the many different types of...
Comments posted to this topic are about the item Is Data the Future of...
Good Morning, We had an issue yesterday where SQL Alerts were generated from one...
Hi there, I am looking for a way to import kafka event data into...
Ask SSC