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,780 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
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
In this series of blog posts, we’re diving into how to use the Pure...
Hello Gurus for one use case we converted the code to use temp tables...
CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...
I am considering implementing an Azure Postgres DB for use in a part of...
Ask SSC