Technical Article

Checking the REMOTE site of a database-link

When gathering SQL server statistics on ALL our Active SQL servers the script was failing sometime when one of our servers was not reachable for one reason or another.This script is checking if the LINKED SERVER is up and running before executing the "gathering statistics" script for this particular server.

You rated this post out of 5. Change rating

2006-12-25 (first published: )

185 reads

Blogs

Announcements from the Microsoft Fabric Community Conference

By

(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...

The Basics of TRY CATCH Blocks–#SQLNewBlogger

By

I was working with a customer and discussing how to do error handling. This...

Working with ALS – Insights from the Ability Summit

By

The 14th annual Ability Summit is a global event that I attended a few...

Read the latest Blogs

Forums

Deadlock problem with upsert

By Kavada

Hello people, I am an SQL beginner and I have a problem with the...

SSIS in Visual Studio File and Folder Structure

By cpiacente

Hello, I had an oddball question I was hoping someone could point me in...

Botched "Data warehouse" design...

By pietlinden

Someone landed a PowerBI mess in my lap, and near as I can tell,...

Visit the forum

Question of the Day

Backing up the Resource Database

How does the Resource database in SQL Server 2022 get backed up?

See possible answers