Agree with above.

Yikes!

Just put it in the Version Control script for database creation 🙂

Apply SP4 and this includes all cumulative patches before it. Be aware that there are a number of post SP4 fixes, including SP4 issues with AWE.

hey, we're geeks. Not like we'd be less dorky.

Besides, everyone wants to invent a new word or acronym. Keeps "Meeting Bingo" fresh.

Tom,

Before I respond, Scotty, I need more power to the forward shields (bad, Donald-Farmer-like-Scottish-Accent in place here).

My apologies for the column thing. I didn't notice it. I saw "dob" and...

Hah, I worked with a disk drive you could see spinning.

Ok, it was old when I saw it, but the nuclear plant had this old computer used for moving rods...

No, but I might just build a new job and whack this one. Might be some strange value stuck in the code somewhere.

Don't cross post:

answered here: http://www.sqlservercentral.com/Forums/Topic480819-149-1.aspx

Reinstall.

Also, you can look at the version of sqlsrvr.exe (right click, properties)

If you :), which is colon-closed paren, it gets converted.

You can : ), which might work better. Or ; )

Shouldn't need to. I'd add some logging code to this proc. Make a table, insert into it at various places from the proc the value of variables and what's happening....

Most people don't participate 🙁

Of the 10k-20k people, and 45-50k pages, we get about 300-500 responses quite often to polls and surveys. Probably should add them to the newsletter, which...

How important is this for performance? If it's a batch, send a few emails here and there, I might stick with the cursor. Not sure a temp table helps here.

However...

Create it in model 😉

sp_recompile for the proc? Reboot the server?

If a bad plan gets chosen on the stored proc (happens, not sure why sometimes), then you might get stuck with it.

How complicated is...