Query window in MS-SQL 2005

[prashant12se]

Hi All,
I am using MS-SQL 2005 database for the application. I need the dll file to be installed for MS-SQL 2005 which would be used for intellicence in the query window i.e as we do in Visual Studio code behind file where we use ctrl + spacebar to get the class etc. I need to do the same for query window in MS-SQL which would list for all the tables, columns etc.

Thanks
Prashant

[skhanal]

Try SQL Prompt from Red Gate software

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

[MAK]

use sql server 2008 SSMS. it lists all the objects, variables etc as you type the commands.

[prashant12se]

Thanks skhanal,
Had checked with the SQL prompt latest version from Red Gate software, it's a paid version. I was looking for free version. Anyway i got the old version of SQL prompt free version.

Thanks Again!!