Inteligence tool in MSSQL 2005

Question

Post reply

Inteligence tool in MSSQL 2005

pallavi.unde

SSCommitted

Points: 1987
More actions
December 9, 2011 at 4:18 am

#144673

I am using MSSQL 2005 .. as it doec not provide intelligence feature like MSSQL 2008.
How can i add it in MSSQL 2005.
Is there any need to install the the specific tool????
Thanks & Regards,
Pallavi

Viewing 5 posts - 1 through 4 (of 4 total)

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

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 1

Do you mean Intellisense?

I believe it wasn't present in 2005 RTM but may have been subsequently added in the 4 SPs.

See here for Microsoft's guide to enabling it.

http://msdn.microsoft.com/en-us/library/ms173743(v=sql.90).aspx

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

pallavi.unde SSCommitted Points: 1987 More actions · Answer 2

Noah i follwed steps to on intelissens but not getting anything

:sick:

is there any other option for it??? mine is sp2

Thanks & Regards,
Pallavi

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

Buy SQL Prompt from RedGate.

SQL 2008 intellisense isn't available in SQL 2005, and only works for SQL 2008 SSMS if working against 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

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

derek.colley (12/9/2011)
See here for Microsoft's guide to enabling it.
http://msdn.microsoft.com/en-us/library/ms173743(v=sql.90).aspx

IntelliSense is not implemented for Transact-SQL editors.

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