Hello, I'm getting an error message (below) on my site and I 've been told that I need to make sure that proper indexing (at least 1 cluster index is in place). If proper indexing is in place, then I can issue the dbcc dbreindex or dbcc indexdefrag command (SQL BOL for information) to help with the physical fragmentation of the database. I am not sure what all this means as my web guy is away and I desperately need to get my site back up and running. So I need to create indexes on database. Although you see that there is space, internally SQL is not allowed to grant more space then the assigned space because the way the data is positioned internally. I need to make sure my database is properly indexed. It should be at least 1 clustered index per table. Can anyone help? Thank you, Art Yumorganics.com Server Error in '/' Application. Could not allocate space for object 'newOrder' in database 'DB_366509_yumorganics' because the 'PRIMARY' filegroup is full. [FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]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.Data.SqlClient.SqlException: Could not allocate space for object 'newOrder' in database 'DB_366509_yumorganics' because the 'PRIMARY' filegroup is full. Source Error: Line 4461: catch (Exception e)Line 4462: {Line 4463: throw e;Line 4464: // return (0);Line 4465: } Source File: e:\web\yumorganics\htdocs\App_Code\Components\dbNew.cs Line: 4463 Stack Trace: [SqlException (0x80131904): Could not allocate space for object 'newOrder' in database 'DB_366509_yumorganics' because the 'PRIMARY' filegroup is full.] dbNew.createOrder(Int64 cartID, String name, String surname, String address, String city, String state, Int32 postcode, String country, String email, String recName, String recSurname, String recStreet, String recCity, String recState, String recPostcode, String recCountry, String recEmail, String memberOrder, String instruction, String phone, String recPhone, String reminder) in e:\web\yumorganics\htdocs\App_Code\Components\dbNew.cs:4463 order.doSend() in e:\web\yumorganics\htdocs\order.aspx.cs:118 order.ImageButton1_Click(Object sender, ImageClickEventArgs e) in e:\web\yumorganics\htdocs\order.aspx.cs:96 System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +108 System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +118 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565 Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082 [/FONT]
...PM me with your DASP Account login and I'll take a look then get back with you. DON'T post you account info here in the forums. All the best, Mark
