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-10-02 (first published: 2004-06-02)
47,632 reads
2004-10-29
2,672 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
134 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
323 reads
And no, the answer is not because you want to be a Microsoft MVP....
By Steve Jones
Today’s coping tip is to avoid saying “I should” and make time to do...
Recently I had an interesting use case where I had to a compound calculation...
It is crucial for Wikipedia contributors to decide what they will cover in their...
Error code 15271in QuickBooks is common error of the 15x series. A QuickBooks Error...
Hi. In source SQL Instance target linked server has been created and connection tested...
Ask SSC