I am at a loss on this one. Can you walk thru an example of this query's utility (usefulness)?

OK, disregard, I see what the intentions are. Just never...

I was hoping someone know of a tool or trick that would accomplish this. If not, would need something using dynamic sql to loop thru each column, check for...

Great function! Definitely going into my Hall of Fame!

One other trick it handled nicely was including a decimal in the numeric sort order. For example, I needed 1.11.338...

Let me be the first to say, "You are da man!"

We have always avoided CLR like the plague, mainly due to deployment issues. We keep a delta of all...

Just do a find/replace with the characters holding the indentation formatting. I replaced w/ a space and worked fine.

Thanks for a...

Thank, I like the addition and appreciate you taking the time to put this together (and posting of course). You might want to change the title to Overview Info...

I am using the Find and Replace dialog from within SSMS. I have a large text file (> 100K lines) that includes a delta of all our change scripts.

Hello and thanks for the quick reply. I am trying to use the Regular Expressions feature in Find and Replace of the SSMS UI to search my text file...

Thank you. I appreciate you posting your script. Might I suggest a link on configuring db mail, as this would be a prerequisite.

http://www.kodyaz.com/articles/sql2005-database-mail.aspx

Sean, the ?'s appear during copy/paste operations for some code. The easiest solution is the perform a Find/Replace on the ?'s and replace them with spaces. If you...

Figured I would throw one more method, albeit quite a bit more manual. You can also check the error log in found in the Log folder where your SQL...

Thank you, that is a nice overview to reference when coming up against a daunting task like this. I did want to throw one tool into the mix that...

Great scripts! If you added some checks for existence, I think it would hit a home run.

Loved the script, as we come across all types of environments and frequently need the extra info.

I added a slight tweak to include SQL Version as part of the output:

--...

SLA is Service Level Agreement. Basically, a performance and quality agreement between the vendor/programmer and company commissioning...