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.

2006-12-25 (first published: )

178 reads

Blogs

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers

By

Welcome back to my Power Platform Quick Tips series! In this second episode we...

Simple-Talk Article…Understanding Azure Storage Options

By

Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...

T-SQL Tuesday #120 – Recap

By

The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Best Law Practice Management Application - Law Software

By adjonline

ADJ Online Web edition covering all cases, justice, judgements, Allahabad daily judgement, Lucknow high court...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers