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

Interview with Greg Low

By

This is the sixth interview we have done. This time our guest is Greg...

Azure SQL Database Types

By

I want to do a quick summary post of the many different types of...

Azure SQL Database – Azure Portal Updates

By

A small but useful change has been made to the Azure Portal for Data...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Which items can be built (do we have enough product for)?

By pietlinden

I have a stupid question. I'm dealing with a Bill Of Materials problem... I...

Modifying the Dataframe in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Modifying the Dataframe in R

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers