dbTalk Databases Forums  

Cant create new query

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Cant create new query in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jim Jacoby
 
Posts: n/a

Default Cant create new query - 10-13-2008 , 03:50 PM






From ssms 2005, when I select the New query all I get is a blank sql window.
How do I open in the query grid window? ALso why is the query designer window
always greyed out. I can't change the Query type. Thanks.


Reply With Quote
  #2  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Cant create new query - 10-13-2008 , 03:58 PM






Quote:
From ssms 2005, when I select the New query all I get is a blank sql window.
That is by design, because SQL Server can't predict the query you want to
run, and expects you to type something. Did you try typing SELECT * FROM
some_table and hitting F5?

Quote:
How do I open in the query grid window? ALso why is the query designer window
always greyed out.
You may not think so at this moment, but this is probably a good thing. The
visual designers in SSMS are severely broken and aren't necessarily the best
way to accomplish anything in SQL Server.

Quote:
I can't change the Query type.
What is a "Query type"? Do you mean SELECT vs. INSERT, or T-SQL vs. MDX, or
something else?



Reply With Quote
  #3  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Cant create new query - 10-13-2008 , 03:58 PM



Quote:
From ssms 2005, when I select the New query all I get is a blank sql window.
That is by design, because SQL Server can't predict the query you want to
run, and expects you to type something. Did you try typing SELECT * FROM
some_table and hitting F5?

Quote:
How do I open in the query grid window? ALso why is the query designer window
always greyed out.
You may not think so at this moment, but this is probably a good thing. The
visual designers in SSMS are severely broken and aren't necessarily the best
way to accomplish anything in SQL Server.

Quote:
I can't change the Query type.
What is a "Query type"? Do you mean SELECT vs. INSERT, or T-SQL vs. MDX, or
something else?



Reply With Quote
  #4  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Cant create new query - 10-13-2008 , 03:58 PM



Quote:
From ssms 2005, when I select the New query all I get is a blank sql window.
That is by design, because SQL Server can't predict the query you want to
run, and expects you to type something. Did you try typing SELECT * FROM
some_table and hitting F5?

Quote:
How do I open in the query grid window? ALso why is the query designer window
always greyed out.
You may not think so at this moment, but this is probably a good thing. The
visual designers in SSMS are severely broken and aren't necessarily the best
way to accomplish anything in SQL Server.

Quote:
I can't change the Query type.
What is a "Query type"? Do you mean SELECT vs. INSERT, or T-SQL vs. MDX, or
something else?



Reply With Quote
  #5  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Cant create new query - 10-13-2008 , 03:58 PM



Quote:
From ssms 2005, when I select the New query all I get is a blank sql window.
That is by design, because SQL Server can't predict the query you want to
run, and expects you to type something. Did you try typing SELECT * FROM
some_table and hitting F5?

Quote:
How do I open in the query grid window? ALso why is the query designer window
always greyed out.
You may not think so at this moment, but this is probably a good thing. The
visual designers in SSMS are severely broken and aren't necessarily the best
way to accomplish anything in SQL Server.

Quote:
I can't change the Query type.
What is a "Query type"? Do you mean SELECT vs. INSERT, or T-SQL vs. MDX, or
something else?



Reply With Quote
  #6  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Cant create new query - 10-13-2008 , 03:58 PM



Quote:
From ssms 2005, when I select the New query all I get is a blank sql window.
That is by design, because SQL Server can't predict the query you want to
run, and expects you to type something. Did you try typing SELECT * FROM
some_table and hitting F5?

Quote:
How do I open in the query grid window? ALso why is the query designer window
always greyed out.
You may not think so at this moment, but this is probably a good thing. The
visual designers in SSMS are severely broken and aren't necessarily the best
way to accomplish anything in SQL Server.

Quote:
I can't change the Query type.
What is a "Query type"? Do you mean SELECT vs. INSERT, or T-SQL vs. MDX, or
something else?



Reply With Quote
  #7  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Cant create new query - 10-13-2008 , 03:58 PM



Quote:
From ssms 2005, when I select the New query all I get is a blank sql window.
That is by design, because SQL Server can't predict the query you want to
run, and expects you to type something. Did you try typing SELECT * FROM
some_table and hitting F5?

Quote:
How do I open in the query grid window? ALso why is the query designer window
always greyed out.
You may not think so at this moment, but this is probably a good thing. The
visual designers in SSMS are severely broken and aren't necessarily the best
way to accomplish anything in SQL Server.

Quote:
I can't change the Query type.
What is a "Query type"? Do you mean SELECT vs. INSERT, or T-SQL vs. MDX, or
something else?



Reply With Quote
  #8  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Cant create new query - 10-13-2008 , 03:58 PM



Quote:
From ssms 2005, when I select the New query all I get is a blank sql window.
That is by design, because SQL Server can't predict the query you want to
run, and expects you to type something. Did you try typing SELECT * FROM
some_table and hitting F5?

Quote:
How do I open in the query grid window? ALso why is the query designer window
always greyed out.
You may not think so at this moment, but this is probably a good thing. The
visual designers in SSMS are severely broken and aren't necessarily the best
way to accomplish anything in SQL Server.

Quote:
I can't change the Query type.
What is a "Query type"? Do you mean SELECT vs. INSERT, or T-SQL vs. MDX, or
something else?



Reply With Quote
  #9  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Cant create new query - 10-13-2008 , 03:58 PM



Quote:
From ssms 2005, when I select the New query all I get is a blank sql window.
That is by design, because SQL Server can't predict the query you want to
run, and expects you to type something. Did you try typing SELECT * FROM
some_table and hitting F5?

Quote:
How do I open in the query grid window? ALso why is the query designer window
always greyed out.
You may not think so at this moment, but this is probably a good thing. The
visual designers in SSMS are severely broken and aren't necessarily the best
way to accomplish anything in SQL Server.

Quote:
I can't change the Query type.
What is a "Query type"? Do you mean SELECT vs. INSERT, or T-SQL vs. MDX, or
something else?



Reply With Quote
  #10  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Cant create new query - 10-13-2008 , 03:58 PM



Quote:
From ssms 2005, when I select the New query all I get is a blank sql window.
That is by design, because SQL Server can't predict the query you want to
run, and expects you to type something. Did you try typing SELECT * FROM
some_table and hitting F5?

Quote:
How do I open in the query grid window? ALso why is the query designer window
always greyed out.
You may not think so at this moment, but this is probably a good thing. The
visual designers in SSMS are severely broken and aren't necessarily the best
way to accomplish anything in SQL Server.

Quote:
I can't change the Query type.
What is a "Query type"? Do you mean SELECT vs. INSERT, or T-SQL vs. MDX, or
something else?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.