Zubair

While writing T-SQL queries in SQL Management studio 2005, one of the problems developers and database administrators face everyday is the lack of intellisense, while Visual Studio developers enjoy this support out-of-the-box but to achieve intellisense in SQL Management, developers had to rely on third-party tools such as SQL Prompt.

The good news is Microsoft has realized this deficiency and now T-SQL intellisense will be a first-class citizen of SQL Management Studio 2008.

From SSDS official page

SQL Server Data Services (SSDS) are highly scalable, on-demand data storage and query processing utility services. Built on robust SQL Server database and Windows Server technologies, these services provide high availability, security and support standards-based web interfaces for easy programming and quick provisioning.

Register for beta or download PDF