Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 9th, 2010, 12:07 PM
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
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 08:20 AM
Regarding Cursor param99 SQL Server 2000 1 September 8th, 2006 11: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 06:48 PM



All times are GMT -4. The time now is 07:01 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.