Yes. Associated courses require MCTs to hold a credential to teach them. These requirements must be fulfilled approximately 90 days after the availability of each Professional Series credential. The MCT Program Competencies Web site provides course-specific requirements and deadlines for attaining new competencies. You will not be authorized to deliver courses that require the new certifications.

Express Edition products are designed for hobbyists, students, and novice developers. As such, they lack the full breadth of features found in higher-end Visual Studio and SQL Server Editions. They are designed specifically for scenarios common to the hobbyist, student, and novice developer. Each Express Edition includes targeted documentation that will help the beginning programmer quickly learn the concepts required to build more advanced applications.

Yes. First back up your SQL 2000 database, and then move it to the SQL 2005 server you want to use. Restore your database, and then run the Orion Configuration wizard on the Orion server and specify the new SQL Server instance. For more information, see the Orion NPM Migration Technical Reference.

You can upgrade most installations using the SQL Server 2005 setup program. All report server content and settings will be fully functional after the upgrade process. In cases where you have customized your report server deployment (added extensions, changed virtual directory settings, or encrypted the ASP.NET account user name in the registry), you will need to migrate your Reporting Services installation.

SQL Server 2005 Express is an easy-to-use and free version of SQL Server 2005 that is designed for building simple, data-driven applications.

Yes. In order to do this you will need to buy Visual Studio Team Foundation Server and a Client Access License for proper communication with the server. Team Explorer, which is included with Team Foundation Server, is a stand alone client that uses the Visual Studio 2005 shell providing a UI for source control, work item tracking and all the other features. For more information on licensing Visual Studio Team System (including Team Foundation Server) see the Team System Licensing White Paper.

No. Unlike SSRS 2000, which required users to purchase Visual Studio 2003, SQL Server 2005 comes with Business Intelligence Development Studio, which provides the Visual Studio shell and the business intelligence projects including Report Designer and Report Builder Model Designer. If users already have Visual Studio 2005, these projects are installed along with language projects.

SQL Server Express is designed to meet the needs of simple applications. It is limited to using 1 CPU and up to 1GB RAM, with a 4GB maximum database size. SQL Server Express does not include any of the advanced components of SQL Server including Analysis Services, Reporting Services, Data Transformation Services, and Notification Services.

the Microsoft Full-Text Engine for SQL Server (MSFTESQL) service running a query to retrieve data from an indexed view, or The causes listed above are only a sampling of the issue slow response time issues encountered with SQL Server 2005. This slow response time can be rectified according to Microsoft by upgrading to the latest service pack for SQL Server 2005, Service Pack 2.

SQL Server 2005 Workgroup Edition has many of the key new features of SQL Server 2005, including programmability improvements such as CLR integration and SQL Service Broker support, Reporting Services, including the new end-user reporting tool, Report Builder, and SQL Server Management Studio, a new management tool for SQL Server 2005. These are all new features that come with SQL Server 2005 and are not available in SQL Server 2000 Standard Edition.

If your software assurance coverage ends on December 1, 2005 or after this date, you are eligible for a free upgrade to SQL Server 2005. No. Processor licenses grant you the right to install SQL Server 2005 on any computer for which you have acquired the appropriate number of processor licenses. You need a separate processor license for each processor on the server. Separate server plus device CALs or server plus user CALs are not required.

You will need to download and install additional components. Please see the Visual Studio Developer Center for more information. No, each release of Visual Studio is tied to a specific version of the .NET Framework. The Express Editions can only be used to create applications that run on the .NET Framework 2.0.

It's here: http://msdn2.microsoft.com/library/default.aspx The documentation system previews some new design ideas and new URL model as described here . MSDN welcomes your feedback on the new system at that page.

The MSDN Library for Visual Studio 2005 provides access to legacy documentation via the MSDN Online search provider, accessible from the Search page. Access to legacy documentation is also available on earlier editions of the MSDN Library installed on your computer.

No. Rules extensions can be built and compiled on a separate computer, then copied to the extensions folder on the MIIS server. Installing the debugger on the MIIS computer is a good idea, since it will improve the troubleshooting experience. Top

I'm getting an error message - "Cannot Load DLL 'SDI' Reason 126 ( The specified Module Cannot be found)" when doing a stored-procedure debug on SQL Server. Or breakpoints just don't fire.

Yes the product id you received when you purchased the license for Ref++ VS2003 can be used to activate the version of Ref++ for VS2005.

EMS SQL Management Studio is a complete solution for database administration and development. The STUDIO is an integrated suite of powerful database management tools united in one easy-to-use work environment. Developers will appreciate its ability to create/edit/drop any database objects and will find DB comparison, data export/import and test data generation tools extremely helpful. Database migration, BackUp and Restore tools will be of great help to DBAs.

SQL Server 2005 Express Edition with Advanced Services is a download that includes the SQL Server 2005 database engine, SQL Server 2005 Reporting Services, SQL Server 2005 Management Studio Express and Full-Text Search. SQL Server 2005 Management Studio Express will also be available separately as a download.

Pricing for SQL Server software varies by deployment scenario. Visit the How to Buy page for more information.

Processor License. Under this model, a license is required for each physical or virtual processor that is accessed by an operating system environment running SQL Server software. This license does not require any device or user client access licenses (CALs). Server plus Device CALs. Under this model, a server license is required for each operating system environment running an instance of SQL Server software, as well as a CAL for each client device that accesses a server running SQL Server.

Yes. As with MOM 2000, we offer a special SKU to enable customers to purchase SQL Server 2000 Technology with MOM 2005. SQL Server Technology acquired via this combined offering can only be used to support MOM 2005 and SMS 2003 activities, and no other application. The estimated retail price of a MOM OML is $539 per server managed by MOM 2005, regardless of how many processors per server. (OMLs are not available individually in retail and are offered in 5 OML pack.

SQL Server 2005 Reporting Services is a server-based enterprise reporting environment, managed through Web services, that delivers a variety of interactive and printed reports. SQL Server 2005 retains the core functionality of SQL Server 2000 Reporting Services. The product contains several key additions and enhancements, including the following: Detailed explanations of Reporting Services enhancements are available at the Microsoft SQL Server TechCenter page for Reporting Services.

SQL Server Compact Edition is a lightweight , easy to deploy database system that is ideal for Windows database development. A 2MB footprint that requires no administration makes it an ideal solution for creating most data storage needs. Some of the limitations of SQL Server Compact Edition: Does not support stored procedures SQL Server Express is designed to be feature-rich and powerful database system. It is an ideal solution for creating client-server Windows applications and Web development.

Based on customer feedback received, we decided that at release, System Center Reporting Manager 2006 will support only SQL Server 2005 to allow customers to take advantage on the newest and richest database technology.

To upgrade local mining models from SQL 2000 to SQL 2005, connect using the AS2005 OLE DB provider (MSOLAP.3) and set the â??Mining Locationâ?? connection string property to the name of the directory as you did in SQL 2000. The local mining model service will read all the .dmm files in the directory and import them into a .cub file (if you donâ??t specify an existing or new .cub file in your â??Data Sourceâ?? connection property, a new file called â??__MSOLAP90_Imported80MiningModels.

Using our products you can work with the following SQL Server versions: SQL Server 7, SQL Server 2000, MSDE, SQL Server 2005, SQL Server Express.