Terry

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

Technical Article

Comprehensive HTML Database Documentation(SS2K5)

This script has been on the SQL Server Central site for a while and has been revised a number of times. I enclose yet another revision that works with SQL Server 2005 (June CTP anyway) with much thanks to all those who have contributed to it in the past.Terry Grignon

5 (2)

You rated this post out of 5. Change rating

2006-02-08 (first published: )

1,075 reads

Technical Article

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. 

You rated this post out of 5. Change rating

2003-02-27

239 reads

Blogs

SQL Saturday NYC Recap 2025

By

My first time at SQL Saturday New York City was an absolute blast! Thank...

SSMS 21

By

Just a quick one this morning. I’m on the road and haven’t worked up...

Why Data Silos Hurt Your Business Performance

By

Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...

Read the latest Blogs

Forums

Problem creating a Linked Server to MS Access 97 database from SQL Server 2019

By Weegee71

Hi there I need help on creating a Linked Server to an MS Access...

SSPI handshake failed error code 0x80090311

By jamesstirling01

Hi, I have a workstation with SQL Express 2019 installed and I have a...

Need query help - MAX record

By jmerlau

Hello - I have attached a Word document here with details about my issue....

Visit the forum

Question of the Day

Removing Log Shipping

If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?

See possible answers