Access Extra

Independent Microsoft Access, Office, and SQL Server News from Tony D'Ambra

Tuesday, May 06, 2008

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
Posted by Tony D'Ambra at 5/06/2008 02:16:00 AM
Labels: SQL Server, SQL Server 2005
Newer Post Older Post Home

Search This Blog


AccessExtra.com
AccessExtra.net


Everything I know you know:
no special subscriptions or newsletters...
from
aadconsulting.com

Access 2007 posts
Access 2010 posts
Access 2010 posts

Access 2013 posts


an aadconsulting.com service


Archive

  • ►  2018 (1)
    • ►  February (1)
  • ►  2015 (3)
    • ►  September (1)
    • ►  May (1)
    • ►  February (1)
  • ►  2014 (8)
    • ►  December (1)
    • ►  November (2)
    • ►  October (1)
    • ►  August (3)
    • ►  March (1)
  • ►  2013 (8)
    • ►  July (2)
    • ►  June (2)
    • ►  May (1)
    • ►  April (2)
    • ►  March (1)
  • ►  2012 (6)
    • ►  November (1)
    • ►  August (1)
    • ►  July (1)
    • ►  March (1)
    • ►  February (2)
  • ►  2011 (6)
    • ►  June (2)
    • ►  May (1)
    • ►  April (1)
    • ►  March (2)
  • ►  2010 (36)
    • ►  November (2)
    • ►  October (2)
    • ►  September (5)
    • ►  August (3)
    • ►  July (4)
    • ►  June (3)
    • ►  May (8)
    • ►  April (4)
    • ►  March (1)
    • ►  February (2)
    • ►  January (2)
  • ►  2009 (53)
    • ►  December (1)
    • ►  November (9)
    • ►  October (2)
    • ►  August (2)
    • ►  July (8)
    • ►  June (1)
    • ►  May (7)
    • ►  April (8)
    • ►  March (5)
    • ►  February (6)
    • ►  January (4)
  • ▼  2008 (124)
    • ►  December (2)
    • ►  November (2)
    • ►  October (9)
    • ►  September (10)
    • ►  August (14)
    • ►  July (12)
    • ►  June (7)
    • ▼  May (20)
      • Updated BETA of PRO Version of 123 Error Handler W...
      • Adding a Program to an Access 2007 Deployment Pack...
      • Dot vs. Bang: Put to Rest The issue of whether t...
      • Latest Access Knowledge Base ArticlesCourtesy of K...
      • Access 2007 Keyboard ShortcutsYou can now download...
      • Access 2007 Bug Alert: Compact and Repair Might De...
      • Access Help and How To Links at Office On-LineOn-L...
      • Latest SQL Server KB ArticlesAn ongoing MS DTC tra...
      • On Demand Web Seminar: True High Availability for ...
      • Tips on Controlling the Access Application WindowY...
      • Latest SQL Server FixesFIX: An ongoing MS DTC tran...
      • Expanded List of Formats to be Supported in Office...
      • SQL Server Data Types10+ Common Questions about SQ...
      • Access 2007 SecurityThese two articles from Micros...
      • How Custom Access 2007 Ribbons WorkThe most challe...
      • Free MS Access Databases and TemplatesFor those wh...
      • Webcast: Essential SQL Server 2008 for DevelopersS...
      • NEW Dashboard Demofor Microsoft© Access 2000/2002/...
      • UI Builder for AccessJust came across this product...
      • Latest SQL Server FixesFIX: The SQL Server service...
    • ►  April (11)
    • ►  March (13)
    • ►  February (14)
    • ►  January (10)
  • ►  2007 (180)
    • ►  December (12)
    • ►  November (11)
    • ►  October (12)
    • ►  September (7)
    • ►  August (23)
    • ►  July (15)
    • ►  June (21)
    • ►  May (10)
    • ►  April (17)
    • ►  March (15)
    • ►  February (14)
    • ►  January (23)
  • ►  2006 (249)
    • ►  December (16)
    • ►  November (34)
    • ►  October (29)
    • ►  September (9)
    • ►  August (17)
    • ►  July (25)
    • ►  June (29)
    • ►  May (15)
    • ►  April (17)
    • ►  March (25)
    • ►  February (10)
    • ►  January (23)
  • ►  2005 (197)
    • ►  December (10)
    • ►  November (20)
    • ►  October (13)
    • ►  September (26)
    • ►  August (14)
    • ►  July (15)
    • ►  June (23)
    • ►  May (22)
    • ►  April (16)
    • ►  March (14)
    • ►  February (10)
    • ►  January (14)
  • ►  2004 (105)
    • ►  December (10)
    • ►  November (13)
    • ►  October (8)
    • ►  September (10)
    • ►  August (9)
    • ►  July (8)
    • ►  June (3)
    • ►  May (10)
    • ►  April (13)
    • ►  March (18)
    • ►  February (3)

Labels

  • .NET 2.0 (1)
  • aad consulting web site (1)
  • ac (1)
  • acc (1)
  • Access (26)
  • access switchboards (8)
  • access 15 (1)
  • access 2002 (2)
  • access 2003 (4)
  • access 2007 (69)
  • access 2007 runtime (10)
  • access 2007 SP1 (1)
  • access 2007 SP2 (2)
  • access 2010 (41)
  • access 2010 runtime (2)
  • Access 2010 SP1 (1)
  • access 2013 (16)
  • access 2013 sp1 (1)
  • access add-ins (14)
  • Access application window (1)
  • access converters (1)
  • access data projects (3)
  • access database templates (7)
  • access forms (2)
  • access hosting (1)
  • access mde (2)
  • access reports (1)
  • access runtime (3)
  • access sql (1)
  • access switchboard (8)
  • access switchboards (4)
  • Access training (1)
  • acess switchboards (1)
  • ASP.NET (2)
  • autorun (1)
  • Business Data Catalog (1)
  • C# Database (1)
  • CGZipLibrary.dll (1)
  • client-server (1)
  • cloud computing (2)
  • command bars (1)
  • custom ribbon (5)
  • dashboard (1)
  • data collection using emails (1)
  • data mining (2)
  • data models (3)
  • database performance (1)
  • databases (3)
  • date picker (1)
  • desktop (2)
  • developer extensions (3)
  • dreamspark (1)
  • eLearning (1)
  • error-handling (2)
  • excel (5)
  • Excel 2007 (5)
  • Excel 2007 Add-in (1)
  • Excel Services (1)
  • exchange server (1)
  • ezy exporter (1)
  • ezy sql (1)
  • ezy startbar (1)
  • form wizard (1)
  • free software (5)
  • freebase (1)
  • graphics (1)
  • icon designer (1)
  • image formats (1)
  • iPad (1)
  • it search engine (1)
  • keyboard shortcuts (1)
  • library databases (1)
  • linked tables (1)
  • menu bars (1)
  • metro icons (4)
  • metro-style (4)
  • Micorosoft Access (3)
  • microsoft word (2)
  • microsoft access (30)
  • microsoft access security (8)
  • microsoft office (29)
  • microsoft office live workspace (2)
  • microsoft press (1)
  • Microsoft SDK for Open XML Formats (1)
  • migrate from access to sql server (1)
  • ms access (11)
  • msconfig (1)
  • MSDE (3)
  • msdn (2)
  • mysql (1)
  • navigation control (1)
  • office 14 (4)
  • office 15 (1)
  • office 2003 (9)
  • office 2007 (52)
  • office 2007 developer extensions (3)
  • office 2007 ribbon (10)
  • office 2007 sp1 (1)
  • office 2007 sp2 (5)
  • office 2010 (32)
  • office 2013 (3)
  • office 2013 sp1 (1)
  • office 365 (1)
  • Office Backstage (1)
  • Office Live (2)
  • office service packs (1)
  • Office SharePoint Server 2007 (4)
  • office tutorials (1)
  • office xp (1)
  • Open XML (4)
  • Oracle (1)
  • Oracle migration (1)
  • outlook (3)
  • PDF (1)
  • queries (1)
  • ribbon (5)
  • RibbonX (17)
  • sharepoint (8)
  • Smart Tags (1)
  • snaphot viewer (1)
  • spell-checker (1)
  • SQL (1)
  • SQL Server (68)
  • sql server 2000 (1)
  • SQL Server 2005 (29)
  • SQL Server 2008 (17)
  • SQL Server Compact (1)
  • sql server express (7)
  • sql server express 2008 (2)
  • SQL Tools (1)
  • start menu (2)
  • startup (1)
  • taskbar (2)
  • training (1)
  • Unzip (1)
  • Variables (1)
  • vb script (1)
  • VB6 (3)
  • VBA (9)
  • VBA code editors (1)
  • Visual Basic (2)
  • Visual Basic for Applications (2)
  • Visual Studio (6)
  • Visual Studio 2005 (1)
  • Visual Studio For Office (3)
  • w (1)
  • web browsing (1)
  • wikis (1)
  • windows (5)
  • windows 8 (4)
  • windows sidebar (1)
  • Windows Vista (2)
  • windows xp sp3 (3)
  • Winforms (1)
  • WinZip (1)
  • XML (2)
  • XPS (1)
  • Zip (1)
  • zoho (1)
© Copyright 2010 aadconsulting.com. Simple theme. Powered by Blogger.