2007-04-30 (first published: 2007-04-03)
1,677 reads
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: 2006-09-29)
179 reads
Blogs
Why I am running for the PASS Board in 2020
By HamishWatson
This blog post lists the reasons why I felt the need to run for...
Blog Refresh – Growing Readers
By gbargsley
Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes...
Daily Coping 27 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SSIS 2017 stopped running, not status is Pending Execution
We have 3 sql agent jobs that are running SSIS packages. Until this past...
cannot find MSOLEDBSQL driver for SSIS 2019 connection manager
In the list of connection manager driver, I cannot find MSOLEDBSQL, There is a...
Ask SSC