Recommendations for SQL Server 2005 IntelliSense tools/add-ins?

views:

2846

answers:

+4 Q:

Recommendations for SQL Server 2005 IntelliSense tools/add-ins?

I am your average Visual Studio .NET developer who has become dependent on Intellisense and Pre-compile syntax checking.

I am looking for similar Intellisense functionality for MSSQL Server 2005 and T-SQL

I was wondering what editors or add-ins people have had success with and would be happy to recommend. What key features do you use regularly, and what are any weaknesses?

+7 A:

Red Gate makes a product that works with 2000, 2005, and 2008, called SQL Prompt. It has the same/better functionality than Intellisense. It integrates with Management Studio and Query analyzer.

http://www.red-gate.com/products/SQL_Prompt/index.htm

GluedHands 2008-12-24 11:09:59

Doesn't 2008 have intellisense? Is red gate's any better?

Giovanni Galbo 2008-12-25 04:50:06

I love SQL Prompt. It's an excellent product. The entire toolbelt from Red Gate is amazing.

Nathan DeWitt 2008-12-25 06:07:48

Yes 2008 has intellisense, but it only works for SQL 2008 databases that you connect to.

GluedHands 2008-12-25 19:28:53

SQL Prompt is very good, however you could install the SQL Server 2008 client tools.

Mark Allison 2008-12-29 13:40:25

SQL 2008 intellisense only works on 2008 instances. Most of the other tools work with older versions.

John Mo 2009-01-10 01:07:56

+1 A:

ApexSQL's Edit tool has intellisense and many other features I find very handy. They offer many other tools that I've found to be productivity boosts. Highly recommended. See: ApexSQL

John Mo 2008-12-29 14:04:42

print("code sample");We are currently using SQL Assistant from SoftTreeTech. It has some fantastic features and keeps on growing.

I would be interested to see if anyone has used ((Apex OR RedGate) AND SqlAssist) and could provide an objective comparison?

Find Details here: SqlAssist

nick_alot 2008-12-29 22:47:18

I'm sold on Apex's stuff and haven't used SQL Assistant, so it's hard to be objective. It looks to me like SQL Assistant would be a good deal if you work in multiple database engines. I think for SQL Server only, you get more for the extra $50 with the Apex Edit tool. Free to try Apex. Check it out.

John Mo 2008-12-30 18:09:20

ansaurus

tags:

views:

answers:

Recommendations for SQL Server 2005 IntelliSense tools/add-ins?

related questions