Clay Punnett

Finding lost or forgotten SQL Servers

This article will show a way to find all SQL Servers, particularly those that have been forgotten about or lost.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(40)

You rated this post out of 5. Change rating

2013-07-29 (first published: 2011-04-19)

15,667 reads

This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...

Today is Christmas and while I do not expect anybody to actual be reading...

Until recently, my family's 90,000+ photos have been hidden away in the depths of...

Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...

Comments posted to this topic are about the item UNISTR Escape

Comments posted to this topic are about the item Celebrating Tomorrow

In SQL Server 2025, I run this command:

SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";

What is returned? (assume the database has an appropriate collation) A: