October 12, 2009 at 10:52 pm
I just saw in my collegues desktop that while he is writing the query, some intelligence is enabled as in When he writes SELECT * FROM TIM all the table names starting with TIM gets shown as it happens in the .Net Screen. But, in my system, it is not happening. Can you help me in achieving that? Any Option i need to get enabled??
I am working on 2008 client with 2005 being the server.
Pramod
October 12, 2009 at 10:55 pm
Intellisense only works against a SQL 2008 server with 2008 tools. Sorry, I wish it weren't so..
CEWII
October 12, 2009 at 10:58 pm
:'(
October 13, 2009 at 12:51 am
Is there no way, i mean any add on's installation all all would help to achieve it?
Pramod
October 13, 2009 at 1:19 am
nope, there are 3rd party tools that do some intellisense, i think sql prompt is one of them
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 13, 2009 at 1:23 am
pramod_yg (10/13/2009)
Is there no way, i mean any add on's installation all all would help to achieve it?
You can buy SQL Prompt from RedGate. It's around $300 iirc. In my opinion, it's far, far better than the built-in intellisense (disclaimer, I have a free copy of SQLPrompt)
The built-in intellisense only works when connected to a 2008 server, no way around that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply