Intellisense for sql 2005 is needed

Question

Intellisense for sql 2005 is needed

sseetha

SSC Veteran

Points: 217
More actions
July 1, 2009 at 5:01 am

#384892

can anybody tell me how to add intellisense in sqlserver2k5 without purchasing it......Needed to add it manually............
tanx
seetha

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

The only way I know is buying something like SQLPrompt (Redgate). There's no built-in intellisense in SQL 2005 and the intellisense built into SQL 2008 only works when connected to a SQL 2008 server.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

WayneS SSC Guru Points: 95460 More actions · Answer 2

GilaMonster (7/1/2009)
The only way I know is buying something like SQLPrompt (Redgate). There's no built-in intellisense in SQL 2005 and the intellisense built into SQL 2008 only works when connected to a SQL 2008 server.

Which brings up some questions:

1. What difference does it make what version a server is on for Intellisense to work?

2. Does anyone else find Intellisense getting in your way, hindering you more than helping you? I ended up turning it off - too ofter it would automatically fill in wrong words for me. If you're typing your code without actively watching the screen, then it becomes easy. For instance, if typing

declare @var xml

I'll end up with:

declare @var xmlnamespaces (or something like that)

IMO, a great idea (works great in VS), but it just gets in my way in SSMS more than it helps me.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

I too found it to be kind of sketchy in SSMS, where it was screwing me much more often than helping, I too shut it off. I had similar issues in VS, but to a lesser degree..

CEWII

Dugi SSCoach Points: 17998 More actions · Answer 4

You can find many applications that can do intellisense for SQL Server 2005 even for SQL Serve 2000! - But sure that you should buy it!

😎

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

WayneS (7/1/2009)
Which brings up some questions:
1. What difference does it make what version a server is on for Intellisense to work?

Valid T-SQL constructs. Should intellisense show that DATE is a valid data type or not? Should it show that TRUNCATE_ONLY is a valid clause for backup log or not? The answer to both depends on what version the engine that I'm connected to is.

Design decision was to only support native intellisense when connected to SLQ 2008 servers. In the earlier CTPs, it worked regardless but validated only SQL 2008 syntax (so date was shown as a valid data type)

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

WayneS SSC Guru Points: 95460 More actions · Answer 6

GilaMonster (7/1/2009)
WayneS (7/1/2009)
Which brings up some questions:
1. What difference does it make what version a server is on for Intellisense to work?
Valid T-SQL constructs.

Good point Gail. So much of what I do is pretty much the same between 05/08 that I hadn't considered it. Thanks.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2