Quick and Dirty Server/Instance information

I do a lot of SQL Server Desktop Edition instance testing and I cobbled together this script from BOL and other scripts I've seen posted.  It is intended to show version, service pack level, machine and instance name and the security type among other information.  Hopefully someone else may find it of use. 

2003-02-27

226 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