.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

URGENT - Run out of HD space whilst rebuilding an index

Posted By:      Posted Date: September 11, 2010    Points: 0   Category :Sql Server
I just altered a table on my large SQL server 2000 database and now the database has been offline for ages and the hard drive as run out of space because of the transaction log size.What can I do!  Enterprise manager has frozen me out completely and theres nothing else I can delete to free up space whist this completes.I've not received any kind of warning and the HD is still being accessed by SQLserver.Do you think this will eventually complete?  Should I stop the SQL service.  HELP

View Complete Post

More Related Resource Links

rebuilding index

I am having a table with indexes and I run a SSIS package once in a month i.e is scheduled.So I want to drop the indexes before loading the data and rebuild the indexes after loading the data.Can any one suggest to drop and rebuild index.

Index Rebuilding in Logshipping

Dear All,

I have configured logshipping with stand by option for reporting purpose. Please find the configuration details as below as

Primary Server: SQL 2005 sp3 EE 64 bit

log backup frequency: every 15 min

Secondary Server: SQL 2005 sp3 EE 64 bit

restore frequency: every 2 hours

Mode: stand by mode(secondary server's db is in read only mode for reporting purpose)

here my questions  are

1. when i do index rebuilding operations on a table in the primary server, will the indexes on the table  in the secondary server also be rebuilt? i hope index rebuilding is fully logged operation. or do i have to configure the separate maintenance plan on the secondary server to rebuild the indexes?

if the database is in bulk logged mode what will happen?

2. how do i find when the index was rebuilt last?

Please help me on this.

Thanks in advance.


Sql Server Management Studio->Table Properties->Storage->Index Space


Hello Forum Members,

 I have a table with 10K rows which does not have any indexes.But when I select the table properties,click on storage I see index space has a value and is not null as i thought. Will sqlserver add deafult index space even if there are no indexes on the table?? Please advise.



Super Urgent!!Index was outside the bounds of the array


Hi. I am having problem uploading the textfile. It will appear this error. When i upload other files,it is working fine. Could the reason be because the file that i am trying to upload has around 100 columm? Thanks for ur help. Could you paste the code too?

This is the error:

Index was outside the bounds of the array.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.

Source Error:

Line 142:        'for loop from 0 to total header element - 1
Line 143: For i As Integer = 0 To preheader.Length - 1 Step 1
Line 144: Dim header1 As String = preheader(i) & trgheader(i) 'header1 = joins up start header and trailin header
Line 145: Dim header2 As String = preheader(i) & " " & trgheader(i) 'header2 = joins up start header

Image processing, determine white space and crop



I have created a image upload for our ID card system to allow users to upload new images, edit them and submit for approval.  This is all working well with a combination of asp.net (c#) and jquery to give a seemless editor etc.

We have had a few users who I cannot believe have scanned a photo of themself and then just submitted it with the A4 page of white and little photo.

I am wondering if anyone can help with a suggestion on how I could possibly reduce the load of these coming through (I can't believe they can be this stupid), it stipulates UK passport standards.

Would my only option be to check for a single continues colour that occurs and if it reaches a certain percentage point say 60% then to just send back an error stating they need to crop the image.

Can anyone help with providing sample or that I can use to move this one on.

I am still in disbelief on this one.  the other one is they take a photo of whole body and other in it and cut straight down middle chopping the people out but supplying a photo that no use for an id photo card....but that I can't imagine being solved programatically as I need to determine where their face dimensions are and what percentage of the actual photo is taken up by it and if it below a threshold reject it.

Bitmap FromFile space "file not found"


I am using aspose.slides to create PPTx's. Some of the process involves loading jpg's from another server and including them in the presentation. This works fine in my development environment. When I upload the site to its server, the jpg loading fails.

I am trying to access jpg's on the other server by:

   oFS = New FileStream(sFile, FileMode.Open, FileAccess.Read)

This causes an access violation error when run from the server.

I also boiled the code down to reading the file directly:

   oImg = System.Drawing.Bitmap.FromFile(sFilePath)

This causes a file not found error.

We have narrowed the problem down to the fact that the File Path has a space in it. How does one solve this problem (while still keeping the space, there is a lot of legacy data)? I have tried replacing the space with %20 or +. I have tried using Server.UrlEncode. The error message always comes back with the encoding in place (like no decoding

Office Space: Custom Field Types for SharePoint 2007


Custom field types provide a powerful way to define a reusable SharePoint column definitions.

Ted Pattison

MSDN Magazine May 2009

Office Space: Custom Auditing In SharePoint


Learn how to enable an auditing solution for Windows SharePoint Services (WSS) 3.0 with customized control pages in Microsoft Office SharePoint Server (MOSS) 2007.

Ted Pattison

MSDN Magazine September 2008

Office Space: Automated SharePoint Site Branding


Here's a custom branding solution for SharePoint sites that integrates Master Pages and CSS files at the level of the site collection.

Ted Pattison

MSDN Magazine July 2008

Office Space: From VBA Macro to Word Add-in


See how to use Word to capture a VBA macro and use Visual Studio Tools for Office to wrap it up into a deployable Word add-in.

Robert Bogue

MSDN Magazine May 2008

Office Space: Simplify SharePoint Development with STSDEV


Ted Pattison shows how to use a new STSDEV utility to set up and deploy SharePoint development projects in Visual Studio in an easy and repeatable manner.

Ted Pattison

MSDN Magazine March 2008

Office Space: Security Programming in SharePoint 2007


This month Ted Pattison presents an overview of programming security and permissions for Windows SharePoint Services 3.0.

Ted Pattison

MSDN Magazine February 2008

Office Space: Events in SharePoint 2007


Windows SharePoint Services (WSS) 3.0 provides a new and improved infrastructure for handling server-side events. In this installment of Office Space, we look at techniques for hooking up Before Events and After Events using both Features and code.

Ted Pattison

MSDN Magazine November 2007

Office Space: Solution Deployment with SharePoint 2007


WSS 3.0 introduces a new deployment mechanism that lets you move your development efforts into a staging or production environment.

Ted Pattison

MSDN Magazine August 2007

Office Space: Building Office Open XML Files


This new column explores how you can extend and customize Microsoft Office System applications and file formats.

Ted Pattison

MSDN Magazine February 2007

Netting C++: The Design Space of the Common Type System


Stanley Lippman moves Text Query Language to the Microsoft .NET Framework using the C++/CLI language extensions in Visual C++ 2005.

Stanley B. Lippman

MSDN Magazine December 2006

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend