[System.Reflection.Assembly]::LoadWithPartialName("System.windows.forms") | Out-Null

This first line of code throws me an error says it can't find it....so is it specific to a certain version of SQL??

TIA!!

I am going to check his suggestion as well (tomorrow). Only reason is that I had "already" done it.....

I ended up using INFORMATON_SCHEMA.COLUMNS. I needed what info I gleaned from that view. Thank you so much for responding!!!

THANK YOU SO MUCH!!!!!! :w00t:

I too need the INDEX CREATE DATE......not the Table Create Date. Any ideas of narrowing this down a bit farther????

Keep 'em comin' boyz!!! Too fun....dork dork!!

AMEN!!!!!! 😛

WHEW!! Thank goodness for the fix!!! YOU ROCK!! :hehe:

[font="Comic Sans MS"]:hehe::hehe:[/font] LOVE IT!!! Thanks for the funny!!! :hehe::hehe:

turns out that there are spaces and tabs at the beginning and end of the file. Issue is to strip out all of this and just leave what is...

Thank you....gives me something to go on!! I will give this a shot!

Me too Lee, thanks for the quick fix!!!

Thank you Steven for the script!!

Thank you everyone for all the good advice. I would not do this on our dev or production servers as a rule. What I am doing is sending...

ok...so I did more research and the issue seems to be the length of printing out @sql being 8000/4000....whodathunkit.

next...the count was off due to some of the dbs...