ADP Developers: Stick With SQL Server 2005

The MS Access Team Blog has today posted this advice:

• Access 2007 ADP’s will run against SQL Server 2008 but do not support designing server objects (tables, views, stored procedures, functions and relationships).
  
  
• SQL Server 2008 shipped after Office 2007 SP1 and after MS had locked down all the fixes for Office 2007 SP2 (coming out in a few months).
  
  
• If you rely on the design features of ADP’s it is recommended that you stick with SQL Server 2005.
  
  
• If you do make the move to SQL Server 2008 use the SQL Server Management Studio to design your server objects.

Latest SQL Server Updates (December 2008)

• Microsoft SQL Server 2005 Service Pack 3
• Feature Pack for Microsoft SQL Server 2005 - December 2008
  A collection of standalone install packages that provide additional value for SQL Server 2005.
• SQL Server 2005 Books Online
  
• Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
  This package includes two add-ins for Microsoft Office Excel 2007 (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2007 (Data Mining Templates).
• Microsoft SQL Server 2005 Express Edition Service Pack 3
• Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3
• Microsoft SQL Server Management Studio Express Service Pack 3
  Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services.

Latest SQL Server Fixes

FIX: SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall security update KB948108 or security update KB948109

FIX: No rows are returned when you use the sp_replqueuemonitor stored procedure to list the queued messages for a queue-updating subscription in SQL Server 2005

New v4.0 of SQL Server Migration Assistant 2005 for MS Access

Microsoft SQL Server Migration Assistant (SSMA) 2005 for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server 2005. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server. SSMA for Access supports Access 97 - Access 2007 databases.

More SQL Server Fixes

FIX: SQL Server 2005 Express Edition cannot pass the Windows logo certification when you install an ISV application on a Windows Vista-based computer or on a Windows Server 2008-based computer.

FIX: When you update more than one row in a table that is joined to another table in SQL Server 2005, some rows are not added.

Latest SQL Server 2005 Fixes

FIX: Error message when you try to insert data on a subscriber of a merge replication in SQL Server 2005: "Msg 548, Level 16, State 2, Line 1. The insert failed"

FIX: The size of a database keeps increasing when you perform many DELETE operations and many INSERT operations on the database in SQL Server 2005

Latest SQL Server KB Articles

An ongoing MS DTC transaction is orphaned in SQL Server 2005

Microsoft does not provide support for SQL Server TDS enhancers

Latest SQL Server Fixes

FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005

FIX: The transactional replication does not run the corresponding stored procedure at the subscriber when the stored procedure is run at the publisher in SQL Server 2005

Latest SQL Server Fixes

FIX: The SQL Server service may stop responding when you run a query that contains many OR clauses in SQL Server 2005

FIX: The update operation is performed on incorrect rows when you update a column of the VARCHAR data type on a remote table by using a linked server in SQL Server 2005

FIX: The SQLGetData function may return zero for the actual size of the data that is to be copied when you use the function to retrieve data for a binary column in SQL Server 2005

FIX: The application seems to stop responding when an application executes a large query that has parameters in predicates in SQL Server 2005 Compact Edition

Latest SQL Server and Data Access KB Articles

FIX: SQL Server 2005 is not installed on a Windows Web Server 2008-based system

An SPN for the SQL Server Browser service is required when you establish a connection to a named instance of SQL Server 2005 Analysis Services or of SQL Server 2005

FIX: No results are returned when you run a stored procedure in Server Explorer in Business Intelligence Development Studio if the stored procedure returns a column of the unique identifier data type in SQL Server 2005

FIX: Error message when you try to delete the rows from the table in SQL Server 2005 Compact Edition or in SQL Server Compact 3.5: "Major Error 0x80004005, Minor Error 0. Attempted to divide by zero"

Latest SQL Server 2005 Fixes

FIX: Error message when you run queries on a database that has the SNAPSHOT isolation level enabled in SQL Server 2005: "Unable to deallocate a kept page"

Error message when you execute a CLR routine or use an assembly in SQL Server 2005: "Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)"

FIX: SQL Server 2005 requests columns that you do not expect when you run a SELECT statement

Implement Custom Paging with SQL Server 2005

The default behavior of .NET data components involves retrieving the entire results of a query when loading data for display on a page. A better approach involves loading only data that will display on the page. In this article Tony Patton of TechRepublic.com shows you how to use ListView and GridView controls to implement custom paging with a SQL Server 2005 backend.

SQL Server Resources and Links

Official SQL Server Resources:

• SQL Server 2005 Elearning Portal Nine FREE Microsoft E-Learning courses for Database Administrators, Database Developers, and Business Intelligence Developers.
• Microsoft SQL Server
• MSDN SQL Server Developer Center
• Microsoft SQL Server TechCenter
• SQL Server Support Center

SQL Server Community Resources:

• Professional Association for SQL Server (PASS)
• SQL Junkies

SQL Server 2005 Webcast Live and on Demand:

• Webcasts and Chats for SQL Server
  
• TechNet Support WebCast: Overview and deployment of Microsoft SQL Server 2005

Latest SQL Server Fixes

FIX: The %TEMP% folder is not cleaned up after you use database mail to send an e-mail message that has an attachment in SQL Server 2005

FIX: Error message when you use a symmetric key to decrypt data in a SQL Server 2005 database: "The decryption key is incorrect"

Latest SQL Server 2005 FIXES

FIX: A stored procedure cannot finish its execution in SQL Server 2005.

FIX: Error message when you run a stored procedure that references a linked server that is linked to the local server itself in SQL Server 2005: "Transaction context in use by another session".

FIX: In SQL Server 2005 the "SQLMoreResults" function returns incorrect results when you use it to retrieve a result set.

Latest SQL Server 2005 Fixes

FIX: Error message when you preview a SQL Server 2005 Reporting Services report that uses the Microsoft .NET Data Provider 1.0 for SAP NetWeaver Business Intelligence: "An error occurred during local report processing"

FIX: Error message when you run a maintenance plan that contains a Back Up Database task in SQL Server 2005: "Failed:(-1073548784) Executing the query 'BACKUP DATABASE"

Finding Dependencies in SQL Server 2005

Tim Chapman from TechRepublic.com shows you how to write a procedure that will look up all of the objects that are dependent upon other objects in a SQL Server database.

Latest SQL Server 2005 Fixes

FIX: Error message when you run a complex query after you install Cumulative Update 3 or Cumulative Update 4 for SQL Server 2005 Service Pack 2: 'The query processor ran out of internal resources and could not produce a query plan'

FIX: you receive incorrect data from SQL Server 2000 Analysis Services after you use the Page Heap tool (Pageheap.exe) to troubleshoot heap corruption issues

SQL Server 2005 Best Practices Analyzer (January 2008)

This download is the January 2008 release of SQL Server 2005 Best Practices Analyzer (BPA), which gathers data from Microsoft Windows and SQL Server configuration settings.

BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in your SQL Server database environment.

Guide to Migrating from Microsoft Access to SQL Server 2005

This white paper from Microsoft covers migrating Access databases to SQL Server 2005, and discusses the differences between the two platforms.

SQL Server Migration Assistant for Access (SSMA Access) is recommended as the best tool for this type of migration, and the paper tells you how to use it to mitigate potential problems in database conversion. For additional information, also see the white paper Microsoft Access or SQL Server 2005: What's Right in Your Organization?