Sigh.

I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.

To be fair, I don't know for sure that the...

TheSQLGuru (8/3/2016)

---

Brandie Tarvin (8/3/2016)

I appreciate the suggestion, Eric. But my hands are tied on third party software. We're not allowed to use unapproved stuff. Hence hacking SSMS Object Explorer Details...

Well, this is heartbreaking...

Poking around AdventureWorks, I get stuff like this in SQL 2008.

exec sp_executesql N'SELECT

udf.name AS [Name],

SCHEMA_NAME(udf.schema_id) AS [Schema],

''Server[@Name='' + quotename(CAST(

serverproperty(N''Servername'')

...

Phil Parkin (8/9/2016)

---

Wow, those double quotes are really throwing the SQL parser off, makes it difficult to read.

It's probably obvious, but I didn't see it. Which line of code is...

Luis Cazares (8/5/2016)

---

djj (8/5/2016)

---

Brandie Tarvin (8/5/2016)

---

A million things to do at work and they want me off my PC. I've got a new one I've got to configure.

So I'm importing...

Phil Parkin (8/5/2016)

---

ThomasRushton (8/5/2016)

---

Brandie Tarvin (8/5/2016)

---

A million things to do at work and they want me off my PC. I've got a new one I've got to configure.

So I'm importing...

A million things to do at work and they want me off my PC. I've got a new one I've got to configure.

So I'm importing my outlook rules, my IE...

There's also the issue of the final sort order. Lynn's results are sorted differently than...

Eirikur Eiriksson (8/4/2016)

---

The problem with Lynn's fine solution is that it isn't able to utilise an index on the Address Type, hence a relatively expensive sort operator is introduced in...

Eirikur Eiriksson (8/4/2016)

---

Lynn Pettis (8/3/2016)

---

Jack Corbett (8/3/2016)

---

Lynn Pettis (8/3/2016)

---

Is the code I wrote here really that sophisticated, or is it that I have been doing this so long...

Luis Cazares (8/3/2016)

---

Exactly, unless they're the same. I did that to...

Did you read...

Eric M Russell (8/1/2016)

---

Rather than attempting to hack SSMS Object Explorer, maybe there is a SSMS add-in alternative that work in the way you want. Some people like to use...

Whoever posted or proofed this is not a native English speaker. Or it's a translation program gone rogue.

We don't know if...

The definitive tutorial by Perry Whittle (Staircase to Always On[/url]).

What we did. Create a 4 node cluster with 2 nodes in data center A and 2 nodes in data center...