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


no.1 for ms access tools: what's hot

Event Manager Database
Super Dashboard Builder
Web 2.0 Switchboard
Access Documenter Pack
Nested TreeView Switchboard
SideBar Switchboard
Dashboard Switchboard
Ribbon Switchboards
Ezy Documenter
Object Dependency Browser
123 Error Handler
SmartForm Plus
Ezy SQL
Access Data Analysis Pack
Ezy Exporter Premium

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Access Team News

Loading...

Access Extra Feed

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.