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: )

195 reads

Blogs

PlanTrace Now Supports PostgreSQL

By

PlanTrace Now Supports PostgreSQL The same plan analysis you know from...

A New Word: the Kinder Surprise

By

the kinder surprise – . the point in your early adolescence when you realize...

Crash-Consistent Snapshot Cloning - Hyper-V Edition

By

If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...

Read the latest Blogs

Forums

Call Center Batik Air Tangerang

By aaron.carr

Call Center Batik Air Tangerang dapat di lakukan menghubungi Layanan resmi Batik Air di...

Call Center Batik Air Jakarta

By aaron.carr

Call Center Batik Air dapat di lakukan menghubungi Layanan resmi Batik Air di +62...

Bagaimana Cara Reschedule Tiket Batik Air

By aaron.carr

Reschedule tiket Batik Air dapat di lakukan menghubungi Call Center resmi Batik Air di...

Visit the forum

Question of the Day

SSoL Support on the OS

On which Linux versions is SQL Server 2025 on Linux supported?

See possible answers