Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to turn off SQL warnings when viewing

Status
Not open for further replies.

TonyScarpelli

Programmer
Jan 23, 2003
361
0
0
US
When I Open a table, and Return All Rows, after a while I get a warning that I am using resources and it needs to shut the window, even with less than 100 rows.

Since I am doing a lot of testing in other applications and am writing code and checking this and that, going back and forth, this message is bugging me.

Is there a way to shut this off while I am testing locally?

Thanks.


Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102
 
Why not use Query Analyzer instead?

SELECT TOP 100 *
FROM dbname


-SQLBill

Posting advice: FAQ481-4875
 
Duh, I guess I should be doing that. I just get so used to doing things one way, I forget about other ways.

I'm no expert, by the way, and my brain is slower now of days. My cat stepped on my brain. I guess I won't try any more excuses...

Thanks.

CU


Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top