SQL Server Availability Monitoring

This VB script will attempt to make a connection to all SQL Servers enumerated in the SQLInventory table over Named Pipes and TCP\IP. If a SQL Instance is listed, it will attempt TCP\IP connections using both port and instance name. Once the connection is established to each server using each protocol, the script will query […]

2007-01-11 (first published: )

1,217 reads

Blogs

Azure Synapse Analytics new features

By

Almost lost in all the announcements from Ignite was a bunch of amazing new...

Docker, Git and DBATools

By

For those who don’t know, last week was the PASS Summit. It’s an amazing...

SQLSaturday Orlando Notes – Coffee

By

I like to say that the goal for any event is to meet the...

Read the latest Blogs

Forums

result in same line

By patdev99

Hello,   trying to query the result by success or failure in 2 seperate...

Dropping SP's safely

By sizal0234

Hi, Is the below script good to delete 3 sp's... Please let me know...

SQL 2017 Listener with Read-Scale (Clusterless environment) AG not working

By JP10

Hello, I have a Read-Scale AG set up.  I have it failing over back...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers