Agreed. My only issue with PATINDEX is it's hard to read the code, but it is leaner code.

My bad. I've resubmitted it. The contribution editor is... confusing. In my defense the field for the sql text strips the white space and looks odd as...

Alter procedure will update syscomments, so will drop/creating the procedure.

I tested this with SMO scripting (2008), and it worked ok, the renamed procedure scripted with the correct name. After scripting I checked syscomments, and it will still showing...

Me too! I passed the 70-432 on 5/24/2010. Which test are you doing next? I'm starting the 70-450 next.

Wow, that's really labor intensive! Compare that to the integration between a visual studio c# project and visual source safe, where the checkout/checkin can be done with a mouse click.

We had a similar solution to the problem of developers changing stored procedures without any version control. The only version control we had was limited to the previous backup....

I have a similar goal (to get certified on a budget) when I decided to get my MCITP DBA 2008 certification. I did some research, the MCITP DBA 2008...

Cool. I did not know that, but I see it now. Usually when I look for code examples I don't search BOL, I search this site. If...

Fixed.

Not sure if this is related, by my users were having problems with the report being cached on the server.  They would make a data change, but the change wouldn't...

TSQL handles this if you're using a sql query.

Select * from orders where isnumeric(Order) = 0