March 2, 2009 at 4:55 am
Hi
Do u any of you know any free Intellisense tool ?
March 2, 2009 at 6:23 am
Free? No. But Red Gate's SQL Prompt is extremely inexpensive.
It won't help while writing the code, but ApexSQL has a free clean-up utility that will help you with formatting.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 3, 2009 at 2:33 am
You may also consider upgrading to SQL 2008...
March 3, 2009 at 2:51 am
Option 1:
Try SQL 2008 Express which is free
Option 2:
Install SQL 2008 Client tools and connect to SQL 2005 and see whether intellisense works
Note:
Just ideas... Don't know whether either will work... 🙂
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
March 3, 2009 at 3:29 am
Sakthivel Chidambaram (3/3/2009)
Option 1:Try SQL 2008 Express which is free
Option 2:
Install SQL 2008 Client tools and connect to SQL 2005 and see whether intellisense works
As far as I know, option 2 will not work. See http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=341872
March 3, 2009 at 4:57 am
Sakthivel Chidambaram (3/3/2009)
Option 2:Install SQL 2008 Client tools and connect to SQL 2005 and see whether intellisense works
It doesn't. 2008's intellisense works only to 2008 servers.
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
March 3, 2009 at 5:29 am
Also, do you get Management Studio (and all the other GUI tools) with SQL Server Express? I didn't think you did.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 3, 2009 at 5:33 am
Great ideas, but neither will work. The SQL 2008 express ms isn't an option, thats a different tool altogether. As far as red gate goes, it's pretty decent once you get used to all of the popups (columns and DDL) that it gen up as your typing. I'm using it now and think it's pretty nice; I like how it captalizes where SQL 2008 doesn't. Red Gate is about $300 bucks I think.
Back to your question - not that I am aware of, but if you find one please pm!
March 3, 2009 at 5:47 am
Grant Fritchey (3/3/2009)
Also, do you get Management Studio (and all the other GUI tools) with SQL Server Express? I didn't think you did.
Not with it, but Management Studio Express is a free download
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
March 3, 2009 at 6:14 am
GilaMonster (3/3/2009)
Grant Fritchey (3/3/2009)
Also, do you get Management Studio (and all the other GUI tools) with SQL Server Express? I didn't think you did.Not with it, but Management Studio Express is a free download
Oh, excellent. I didn't know that. Thanks Gail.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 10, 2009 at 1:53 am
Use Red Gate SQL Prompt tool. Its a nice tool and inexpensive as well. It will also do the formatting of the SQL Code. It's available for free trial for 15 days.
Amol
Amol Naik
March 11, 2009 at 5:52 am
SQL Prompt (redgate) is a great tool, if you do not have SQL Server 2008. Should have regard to the settings, for example Cache
March 11, 2009 at 12:36 pm
Another inexpensive option is SQL Assistant (http://www.softtreetech.com/isql.htm). It's less than $200/developer with maintenance. I have no affiliation with them whatsoever but I've found their tool to be the most non-invasive and responsive intellisense-type tool out there. Their website is a little underwhelming but the tool is top-notch.
March 11, 2009 at 2:36 pm
seth.rothman (3/11/2009)
Another inexpensive option is SQL Assistant (http://www.softtreetech.com/isql.htm). It's less than $200/developer with maintenance. I have no affiliation with them whatsoever but I've found their tool to be the most non-invasive and responsive intellisense-type tool out there. Their website is a little underwhelming but the tool is top-notch.
I have to agree with this - we use it here, and it also works with different systems. Since we have both Oracle and SQL Server this tool works the best for us.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 17, 2009 at 3:05 pm
Our DbOctopus has SQL editor with intellisense. It's free until September so if you need such tool you can take a look:
http://www.cogin.com/dboctopus/
Dejan
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply