Dang Farrell, you sound like me! You are a Libertarian (not a Republican)  and just don't know it...   You're right, the Republicans are out of control spenders. I can't believe it. I...

Sorry Michelle, I spelled your name wrong, my bad. The reason I said what I said is because you specifically said "Perhaps I am just lucky, but I’ve never had...

Micehelle, I'm having a hard time believing that you pay absolutely no taxes. Do you not get taxed by the goverment (central/federal Canadian) each pay check? If not, maybe you...

Oh man P. Jones, that is pathetic. I knew it was far worse over the pond in Europe, but that is ridiculous. Well, I guess that's where America is headed...

Unfortunately not!

What I also find fascinating is those people who say, "hey mon, actually, I didn't have to pay any taxes... I got some back!"!!! Hellllloooooooo!!!! Take a nice look...

http://www.fairtax.org

set libertarian_rant on

It's MY money, not the government's. The money I have earned is forced from me by the govt, and I see practically none of it back. That money...

Sounds great, but too bad about the .NET framework 1.1 dependency. Since I have the Framework 2.0 installed to play with SQL Server 2005 Beta, it wouldn't let me install...

Having rollback scripts for text-based objects like stored procedures, triggers, views is one thing (relatively easy) However, having rollback scripts for scripts that change structure, rearrange data, etc is entirely...

This is a handy little feature that for some reason I've missed before. Thanks Steve.

-Vic

The problem that the author had to fix had nothing to do with identity columns. This could have been a regular int column that got its new numbers via time-tested...

As far as environments, it's interesting that you do not mention a Staging environment. It's tough to go straight from QA/Test right into Production. In my last 3 software development...

Thanks Calvin, but like I said a few posts ago, I was really looking for a magic bullet setting or something here. I will not be using a temp table/var,...

Great idea Remi, but alas the report data is very dynamic. In fact, a single proc is used to execute different queries that are already stored in a table for...

Thanks for the responses guys. Actually what I was looking for was a magic bullet, something like, just check this system var and it gives you the total! it's unfortunate that...

Hmmm. I don't see anything about error_line() in 2005 BOL. Nor does it let me run a select error_line() and at least get a null value outside a try ......