The Lounge - CodeProject

Welcome to the Lounge

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

Wasn't Expecting That

AspDotNetDev2-Nov-12 15:11

AspDotNetDev

2-Nov-12 15:11

I was just debugging a query in SQL Server Management Studio 2008 and got an error that said something like:

Unable to create window handle.

Because it was a (SQL) cursor with a bunch of SELECT statements, each of them displayed as a grid in the results window. Evidently, there is a limit to the number of grids you can create... had to restart my computer. D'Oh! | :doh:

Thou mewling ill-breeding pignut!

Re: Wasn't Expecting That

Rutvik Dave2-Nov-12 22:56

Rutvik Dave

2-Nov-12 22:56

Hi, this is Microsoft Support, please follow the following...

1. Go to Options > Query Results
2. Change Default Destination for results: to Result to text
3. If your insane cursor query still producing crazy amount of data, please change it to Result to file
4. And even that overflows, please buy a new hard drive

* Above solution only work once you open new query window.

And how do you expect us to open a window without handle, please try this at your home to understand the practicality of the situation.

Yours truly,

Microsoft Support Big Grin | :-D

General

News

Suggestion

Question

Bug

Answer

Joke

Praise

Rant

Admin

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.