>I have been spending a lot of time in stored procedures lately. More than once in a while its limitations make me chafe. It reminds me -- and this is not a warm memory -- of COBOL. I hope major improvements to both T-SQL and the SSMS IDE are somewhere in the pipeline.
>
>Which version of SQL Server were you using, and what limitations were you encountering?

Agreed. I've never found any limitations, I just decided to spend my time making a rich domain model.