T-SQL: The Evils of SQL Cursors

There's a nice discussion thread on stackoverflow.com about the dangers of using SQL Cursors. Reference: http://stackoverflow.com/questions/58141/why-is-it-considered-bad-practice-to-use-cursors-in-sql-server