SP1 Bug: SELECT Query on Table with Computed Column Generates Access Violation

November 08, 2001 SP1 Bug: SELECT Query on Table with Computed Column Generates Access Violation A Web Exclusive from WinInfo Kathy Blomstrom WinInfo InstantDoc #23172 WinInfo	Email this Article Printer Friendly Reader Comments Digg This Del.icio.us RSS
Subscribe to Windows IT Pro \| See More SQL Server and Database Articles Here \| Reprints \| Or get the Monthly Online Pass—only $5.95 a month!

Microsoft has posted a new article that details a SQL Server 2000 Service Pack 1 (SP1) bug. The article explains that executing a SELECT statement that has a nested query on a table that contains a computed column might generate the following Access Violation:
   ODBC: Msg 0, Level 19, State 1
   SqlDumpExceptionHandler: Process 61 generated fatal exception
   c0000005 EXCEPTION_ACCESS_VIOLATION.
   SQL Server is terminating this process.
   Connection Broken

To avoid this problem, the article recommends that you place the computed column's value into a variable, then use that variable in the SELECT list. However, the article also notes that good database design typically avoids storing computed columns in a table; performing the computations through queries is a better practice. For more information about this problem, see the Microsoft article, "BUG: SP1 Regression: SELECT Query on a Table with a Computed Column Generates Access Violation."

End of Article

Top Viewed ArticlesView all articles

No Jobs, No Excitement at Apple's Last Macworld Keynote

Apple CEO Steve Jobs made the right move in skipping out on his company's last appearance at Macworld: In a Tuesday keynote address at the conference, Apple had no interesting new products to sell, opting instead to spend mind-numbing amounts of time on ...

Where is Microsoft NetMeeting in Windows XP?

...

The Memory-Optimization Hoax

Don't believe the hype. At best, RAM optimizers have no effect. At worst, they seriously degrade performance. ...

SQL Server and Database Whitepapers StoreVault SnapManagers for Microsoft Exchange and SQL Server

Related Events Storage Consolidation for Your Microsoft Applications: Reducing Cost and Complexity

Virtualization for Mission-Critical BI with SQL Server

Check out our list of Free Email Newsletters!

SQL Server and Database eBooks Safeguarding Your Windows Servers

SQL Server Administration for Oracle DBAs

Taking Control: Monitoring the Windows Platform Proactively

Related SQL Server and Database Resources Become a VIP member of the Windows IT Pro community!
Get it all with the VIP CD and VIP access. A $500+ value for only $279!

Subscribe to Windows IT Pro!
Solve your toughest technical problems with our experts and access 10,000 + articles online. 30% off

Monthly Online Pass - Only $5.95!
Get instant access to 10,000+ articles from Windows IT Pro Magazine!

TechNet Virtual Labs
Evaluate and test Microsoft's newest products.

ADS BY GOOGLE

Job Openings in IT		SPONSORED LINKS		FEATURED LINKS
		Maximize speed, performance and reliablity of your PCs and servers—automatically! Speed Up Your PC! Try Diskeeper 2008 with InvisiTasking Free Now! Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business. Order Your Fundamentals CD Today! Register today for your in-depth copy of one of three Fundamental CDs on the following topics – Exchange, SQL, and SharePoint. Microsoft Learning Snack - Virtualization With Windows Server 2008 Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features. Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization.		Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization. Microsoft Learning Snack - Virtualization With Windows Server 2008 Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features. Empower Your Processes with PowerShell 201 Paul Robichaux delves deep into PowerShell how-tos in 3 informative lessons, each followed by live Q&A—all on your own computer! Register today! Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business. New Release: Windows IT Pro Master CD 13 years of content archives, fast answers with advanced search tools, and full access to WindowsITPro.com—order today!

Windows IT Pro Home

FAQ for Windows

WinInfo News
Europe Edition

About Us

Media Kit

Affiliates / Licensing

SQL Server Magazine

Office & SharePoint Pro

Windows Dev Pro

ITTV
IT Library

Technology Resource Directory

Connected Home

Windows Excavator

Windows SuperSite