Terry

  • Interests: cycling, hiking, long walks off short piers, tai chi

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

229 reads

Blogs

Power BI Monthly Digest – October 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 26 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Read the latest Blogs

Forums

Unique value constraint among active records

By CanuckBuck

I have a lookup table that implements a system-generated Id for DRI purposes.  The...

Textfield comparator.

By ben.brugman

A client would like to be able to recognize similar free-texts in a text...

Are there any free resources/ebooks to develop database design and modeling ?

By vijay41

  I want to develop my skills in database design and modeling. I found...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers