Hello Mr. Denny,

Thanks for your response. To answer your question, no, I am not using any CLR, function or a T-SQL stored procedure. I just ran the query (as a batch) on query window and this is the exact error I get:

[font="Courier New"]An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown. [/font]

Does this help?

Thanks again for your response.

Regards,

Venky