Hello,
These are features in Sql Server 2005
-Integration with .net framework.
It means we can code stored procedures, functions, and triggers in the .NET Framework language of our choice.
When we write stored procedures, triggers, and user-defined functions, one decision we will now have to make is whether to use traditional Transact-SQL or a programming language that is compatible with the .NET Framework, such as Visual Basic .NET or C#.
-Devloping web services in database tier.
We can use HTTP to access SQL Server directly, without using a middle-tier listener such as Microsoft Internet Information Services (IIS).
-ADO.Net Support
New features ADO.NET Notification and MARS is added
ADO.NET Notification Support
SQL Server 2005 introduces notification support for SQL Server queries.
Multiple Active Result Sets
Multiple active result sets (MARS) provides the ability to have more than one pending request per connection.
-XML
Enhancements in retrieving and writing XML
-SQL Management Objects
The SQL Management Objects (SMO) model is the management object model for SQL Server 2005. SMO is the primary tool for developing database management applications using.NET Framework.