Wrox Programmer Forums
|
BOOK: Professional Microsoft SQL Server 2008 Programming
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2008 Programming by Robert Vieira; ISBN: 9780470257029
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2008 Programming section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 9th, 2010, 11:07 AM
Registered User
 
Join Date: Jul 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cursor reads, but does not operate

I am having a lot of problems with what seems like it would be an awefully useful bit of SQL from Chapter 13. Actually, the problem seems to extend throughout the AdventureWorks2008 database. I am not able to REBUILD the indexes in this database. I even went as far as to drop and create a new version of one of them, which is the very first one that stops the process to see if the cursor would be able to run the REBUILD to the next index, but it wouldn't. Then, I went into the indexes individually and attempted a rebuild in the MSSMS. When doing it by hand in MSSMS it appears to be working, but the percent fragmented remains the same.

I would like to know why this is occurring. Like it says in the book "Keeping your indexes defragmented is, however, a core part of administering your system." Could this be because of all the constraints on the table. I understand that clustered indexes have the actual column data on the leaf. Is the leaf constraint the problem.

I'm going to try this on some of my own data to see if I can get it to run without getting the error that I get when working on the AdventureWorks2008 database which is as follows:

Reindexing Production.ProductListPriceHistory.PK_ProductListP riceHistory_ProductID_StartDate
Msg 1088, Level 16, State 9, Line 1
Cannot find the object "Production.ProductListPriceHistory" because it does not exist or you do not have permissions.

Thank you,

Donny Buckman





Similar Threads
Thread Thread Starter Forum Replies Last Post
Page title reads Article:{0} iguta BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 December 18th, 2009 03:46 PM
Magnetic Cursor - Target Area Cursor? gcarcass .NET Framework 2.0 1 May 5th, 2008 07:20 AM
Regarding Cursor param99 SQL Server 2000 1 September 8th, 2006 10:03 AM
Reads : Hit counter cutesneakers PHP How-To 1 December 28th, 2004 11:44 AM
operate electrical circuit using c program kale_tushar C++ Programming 2 August 1st, 2003 05:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.