SQL Server 2005 Features and System requirements

  • Hello Folks,

    Can anyone point me to any links that discuss SQL Server 2005 features and system requirements? We are trying to get a handle on the changes that might be required, what to look out for, software requirements. Looking around on various Microsoft sites turns up a lot of marketing type info but no straight "these are the features" or "here are the requirements" type info.

    Any help would be greatly appreciated.

    Mark


    Best Regards,

    Mark Tierney

  • 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.


    Kindest Regards,

    BhatiaWorld
    sanians.com

Viewing 2 posts - 1 through 1 (of 1 total)

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