Technical Article

Ping Linked Server

This Stored Procedure serves to verify if some error with the source of data of a Linked Server exists. In this in case,  I will use a mdb that already exists in the Office - Northwind.mdb. If we do a Link Server  concerned to this mdb, this is generated without errors . But when this […]

You rated this post out of 5. Change rating

2006-11-02 (first published: )

708 reads

Blogs

SQL Server Source Control on a $0 Budget

By

The Source Control Dilemma Every DBA has been there. Trying to keep track of...

CHOOSE’ing a Beer: #SQLNewBlogger

By

We recently published an article on CHOOSE at SQL Server Central. I thought it...

Don’t Treat Your Data Catalog Like a Data Museum

By

Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...

Read the latest Blogs

Forums

Transactional Replication from Read replica

By cooldude001

If I have Read replica (in Azure SQL MI), can it be used as...

SQL availability group and file server role answering from the same name

By bill-humphrey

Hello, I'm tasked with setting up a 2 node server cluster that will host...

Visit the forum

Question of the Day

Replacing a Null

What is returned from this code in SQL Server 2022?

DECLARE @value INT = NULL;
SELECT ISNULL(@value, 100.5) AS Result;

See possible answers