Thanks Luis!

You rock! I was trying to do it with a CTE and was having difficulty. I knew it was me. Thanks again this works perfectly!

Thanks again Luis! I really appreciate all of you help and everyone else as well!: -)

Thanks Luis!

I read your links. Never occurred to me to get that detailed. But I can definitively do that in the future. Thanks for the advice.

Quick question, how would I...

Smendle,

You rock! I stared at this all morning and just couldn't see it. I should have, but just couldn't. I will make sure the next time I add more to...

I figured out the issue, just a simple comma. lol Thanks again for all the help I really appreciate it!!!

Thanks for the reply!

I have to use WITH(NOLOCK) because this dat come from a scrub table that a XML Shredding process is constantly running. And the powers to be want...

Not sure this helps, but I have several 2000 servers in Production still and I had to right a couple of queries to do my incremental backups and delete files...

Very useful query! I tweaked it for English-US. Hope you don't mind. Thanks for the hard work on this one!

SELECTTAB.NAME AS [Table Name],

COL.NAME AS [Column Name],

TIP.NAME AS...

Great script! Works perfectly on Default Instances. I just can't get it to work on any of my Named Instances. Like Server\Database. I get connection error...

First let me start by acknowledging I probably have WAY TOO MUCH TIME on my hands. LOL

That said, I made a small, :), change to the query around the...

Persistence pays off! lol I belive I have figured it out. Seems to work in my test environment. Darn Quote Marks get me every time lol

So...

Gary you ROCK!!! The second solution works perfectly!!! Thanks so much for taking the time to help me!!

Thanks Gary!

I'm still not getting the $DriveSize.Name back or $DriveSize.Size. I've tried adding the '[0]' and the same results. $DriveSize[0].DriveSizeFree returns now but in an expression like 2.49952E+11.

In...

You rock! Thanks. I see where I went wrong and it's a perfect solution. Thanks again!

No worries 🙂 We can do this like this:

1. In the properties of the column you want the color chnage to occur, go to Appearance | BackgroundColor and...