Dave Oliver's Technical Blog
The Technical Blog of an Enterprise Architect in a FTSE 100. The EA Blog is at EnterpriseArchitecture.co.uk

Intellisense in SQL Server 2000 and SQL Server 2005 editors

Monday, May 08, 2006 12:30 PM

As normal service has resumed and I’m blogging again (admittedly I’m not going to blog about absolutely everything) here is a wonderful little utility I found on my travels for adding Intellisense to editor in SQL Server. It’s called promptSQL from Red Gate. I really love how Intellisense makes me more productive (i.e. lazy) in Visual Studio and I was wondering about its rather obvious admission from SQL Server 2005 Management Studio, missing a trick strings to mind. Anyway for $95 you can have it in all its glory. Yep, $95 which seems a bit steep, it drops to $50 per head when you buy 10.

Another little gripe is that options in the drop down window are selected via the return key; the space-bar just generates a space. I’m very used to using the space-bar so it’s going to be weird going from one Intellisense to another.

The software can be eval’ed for 14 days and is still in beta but it hasn’t blown up on me yet.


Feedback

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors

You got to check out SqlAssist from http://www.roundpolygons.com.

Get Intellisense and more for $29 and very stable so far for me. 5/8/2006 6:14 PM | Shawn Cicoria

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors

.... I just have !

.... and it's awesome !

The only issues are that it doesn't yet integrate into SQL Server 2005 editors yet, but this is coming, and there are no plans for a SQL Server 2000 version. 5/9/2006 10:18 AM | Dave Oliver

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors

best site
http://www.mentalhealth.net.in 11/24/2006 8:30 PM | Mental Health

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors

SqlAssist does integrate with Sql Server 2005 editors now. Full release, and working great! This definitely is a must have for me... 2/20/2007 3:49 AM | Jon

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors

Yes, for my money, SqlAssist is the one. It's intellisense rocks, and it has several other nice little features too (like a built in pretty formatter for example, and correct case as you type!). After testing SqlAssist, I don't see why anyone would spend $95 on Sql Prompt. 3/22/2007 5:41 AM | Tim

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors

I was reading up on comparisons between SQL Prompt and SqlAssist, and I just can't see paying 200 bucks for the former!

To SqlAssist I go! 5/29/2007 7:58 PM | Wayne

Comments have been closed on this topic.