May 24, 2005 at 8:20 am
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
May 26, 2005 at 2:19 am
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.
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