SQL Server 2008 Features for SQL Server 2005

Question

SQL Server 2008 Features for SQL Server 2005

Raj's

Ten Centuries

Points: 1044
More actions
October 21, 2008 at 12:51 pm

#194784

Hi Folks,
While working with SSMS 2008, I see there are good features of programing like auto completion of object names (Tables, database, views and others) also it has a good grouping logic. So, wondering is there a way to include same format to SSMS 2005 ?
Programing would be easy with these features ?
Any comments would be good
Rajesh

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

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

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 1

There are some third party tools which support that, one being from the sponsor of this site, Red-Gate. The tool is called SQL Prompt. Haven't used any others so I don't know if they exist or not. 🙂

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Raj's Ten Centuries Points: 1044 More actions · Answer 2

Could be a good one 🙂 But I am looking for free stuff ;). My company wont pay for this 😀

Thanks,

Rajesh 🙂

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 3

Nothing free that I'm aware of. SQL Prompt is pretty inexpensive though. It's got a real return on investment with the speed you can realize in writing TSQL code. You might want to explore it a bit. You can download a free demo.

"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

Raj's Ten Centuries Points: 1044 More actions · Answer 4

Thanks for the update. There is notepad++, this tool has no connectivity with database, still a very good free tool for organizing.

Thanks,

Rajesh