Friday, September 26, 2008
A security issue has been identified in the SQL Server 2000 Service Pack 4 and the MSDE 2000 sql server engine used by MS Access that could allow an attacker to compromise your system and gain control over it. Download the hot fix.
Date Published: 9/26/2008
Download Size: 16.5 MB - 39.4 MB Download size depends on selected download components.
Wednesday, September 24, 2008
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
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.
Tuesday, September 16, 2008
Hot fixes are now available for the following Microsoft Access issues:
- An Access 2003 project (.adp) stops responding when in table Datasheet view, you delete all child rows from a parent row and then delete the parent row. This issue applies only to an Access 2003 project.
- A database in .mdb format in Access 2003 SP3 stops responding when you try to delete a parent record from a table in Datasheet view and the Datasheet view uses a sub-datasheet that is expanded to show the related child records.
- In Access 2007, you create a query that does not contain a parameter. When you export the query to a Microsoft Office Excel Worksheet, the Enter Parameter Value dialog box opens.
- When you open a chart object in Access 2007 on a computer that is running Windows Vista or Windows Server 2008, you see a blank chart.
- After you upgrade Access 2003 to Access 2007, operations on existing forms have slow performance.
- You cannot use the SetValue macro in the click events of a Button control to set the Locked property of a Check Box control in Access 2007.
- You have a printer that has a staple feature. When you print an object in multiple copies in Access 2007, all the copies are stapled as one unit. However, you expect that each copy is stapled individually.
Tuesday, September 09, 2008
Friday, September 05, 2008
SQL Server 2008 Microsoft SQL Server 2008 Books Online Release Notes
SQL Server 2008 Express with Advanced Services - English
SQL Server 2008 Express
SQL Server 2008 Upgrade Advisor
SQL Server 2008 Books Online
SQL Server 2008 Enterprise Evaluation: Trial Experience for Developers
SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals
Thursday, September 04, 2008
Wednesday, September 03, 2008
Configuring the Windows Firewall to Allow SQL Server Access To access an instance of SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server to allow access. This MSDN article discusses how to configure the Windows firewall, but the basic principles apply to other firewall programs.
New articles from Techrepublic.com on SQL Server 2008: