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,283 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 James-Serra
Almost lost in all the announcements from Ignite was a bunch of amazing new...
For those who don’t know, last week was the PASS Summit. It’s an amazing...
By Andy Warren
I like to say that the goal for any event is to meet the...
Hello, trying to query the result by success or failure in 2 seperate...
Hi, Is the below script good to delete 3 sp's... Please let me know...
Hello, I have a Read-Scale AG set up. I have it failing over back...
Ask SSC