quote:
Do you get the error right away or during the CURSOR_TBLDEF loop? If is is during CURSOR_TBLDEF loop perhaps SQL is grabing a big chunck of the syscomments entry and allocating too much for the record, are there any large table/procedure definitions in your DB?
I was a little bit unprecise!
I only need to remove the first occurence of FAST_FORWARD to get it running.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]