[font="Tahoma"][/font]

Extremely well-written article with lots of valuable input but as some of the readers have observed (rather correctly), it would have been greatly helpful if the French was somehow substituted...

Thank you all guys for your prompt responses. Yes, despite the initial failure of the process, I could at least gauge how much can SSMS hold in terms of data...

Considering Jeff's suggestion, I ran the query on the server itself but with the same results. As Denny points out it is the problem with SSMS (which is built on...

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...

Hi Roy,

Thanks for your reply. However, after some research and assiduous poring over MSDN-bestowed articles, I found that the culprit was the restored database! I had restored one of the...