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?