>I still see people using sp_ to prefix their stored procs. Bad idea too.

Maybe - but a quick look at SQL2005 shows that MS threw in 1,285 of them..... (g)

>
>>And really not for much of anything else...
>>
>>I don't even use it in T-SQL anymore. Years ago, if I had a topcount variable, I'd call it @nTopProducts - but then came to realize that was unnecessary.