John Rowan (1/9/2009)
I am not aware of it being depricated. It exists in SQL Server 2008 as well.
It's not deprecated, but it is a cursor under the hood. AFAIK.
You can script sp_ stored procedures if you use SMO, or another IDE.
Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone