Steven Whaley

Retrieve SQL Instance Connect Info

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2013-04-11 (first published: 2013-03-24)

1,466 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: