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


Post New Web Links

DBCC SHRINKFILE: Page 4:11283400 could not be moved because it is a work table page.

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :Sql Server
 

 

Hi,

 

I issued this command on Tempdb but it doesnot shrink the file.

 

dbcc shrinkfile (tempdev_3,1)

go

 

Messages:

-----------------------------------------------------------------------------------------------------------

DBCC SHRINKFILE: Page 4:11283400 could not be moved because it is a work table page.

-----------------------------------------------------------------------------------------------------------------------------------------------

 

I have  checked that there are no tables associated with any user in tempdb. Any help is appreciated.

 

Regards,

Razi




View Complete Post


More Related Resource Links

Adding table to a page, but the format lost when I use clear border

  

Hi,

I added a table to a page, by default, the table layout is the light border. So, I add my content and the vertical align seems to set to the top. But when I changed it to clear border, the content of the table will set vertical align to center. Is there a way to change this back to top align but with the clear border. I don't think I can do this by what is available in the ribbon. Please advice.


not able to edit page when moved site to a new farm

  
Hi, I moved my site to a new farm. Now when I tired to edit the page I am getting Page error. I thought its a page layout url issue. I found some broken links for that web site in sharepoint designer, but some pages are giving error which are not listed as a broken url. what should i do to fix this problem? can anybody help me please?    

wrapping a table into a multi column page

  
I have a table populated with some data fields that spans 5 pages.  I am trying to set up the layout to be a multi column report (just two columns) in which the table wraps at the end to populate the right section of the page How can this be done?Javier Guillen

How does "Alert Me" work with simple web page?

  
In another post (http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/83ec9566-0357-4f40-9388-f364e87c1bd4/)  I've learnt how to make simple web pages in MOSS 2007. Then I want to "subscribe" some users using the "alert me" function but it doesn't seem to work.  Do I miss something or "alert me" doesn't work with simple web pages?  

making page work after DB update in Form View

  
I could really use some help with this issue. I have a DropDown that allows the selection of a Category Code. The selection populates a Gridview with details of records matching the Category Code. I have only enabled the Select option on the Gridview, which when clicked populates a Formview in Edit Mode with the full record information. When editing is complete and the Update link is clicked, I can not get the page to properly reload/postback. When another Category Code is selected from the Drop Down the Gridview does not report a list of records.   Any help would be greatly appreciated.   Thanks,              

Page.ClientScript.RegisterClientScriptBlock does not work

  
All, I am new to .Net and webpart. What I try to do is to create a griedview webpart with a functionality of export to excel. The gridview also can drildown another gridview. The drilldown work as expected. When click export to excel link button it works ok, too. The problem is when comeing back to the gridview to click any row, it stops to drilldown. If I want to use export to excel link it stop working also. Only refresh page can make it work again. I did research and found a solution, that is, to implement a javascript to solve the problem. I follow references from microsoft site as shown below. But it never works. Can anyone tell me what wrong I did? Thanks a lot   private const string ByeByeIncludeScriptKey = "myByeByeIncludeScript"; private const string EmbeddedScriptFormat = "<script type='text/javascript'>function ClientScript(){ _spOriginalFormAction = document.forms[0].action; _spSuppressFormOnSubmitWrapper=true;}</script> "; //Constructor  public DataViewer() {  public DataViewer()this.PreRender += new EventHandler(DataViewer_PreRender); } //Client Script registration   private void DataViewer_PreRender(object sender, System.EventArgs e) { if (!this.Page.ClientScript.IsClientScriptBlockRegistered(ByeByeIncludeScriptKey))this.Page.ClientScript.RegisterClientScriptBlock(typeof(DataViewer), ByeByeI

Repeat Report Item with Data Region on Every Page - doesn't work

  
Hi All, The Repeat Report Item with Data Region on Every Page property does not work - or atleast not the way i would expect it to. My report contains a header which is the Report Name. In the report body - I have text box with the company name, pulled from a data set. Below the company name i have a line, followed by a text box displaying the selected parameters. When I run the report, the first page displays all information as expected. However, subsequent pages only display the report header (report name) with the table butted up against it. I have tried setting the Repeat Report Item with Data Region on Every Page to true (and the data region to my table) for the Company Name text box, the line, and the parameters text box. This has no affect i.e. page 2, page n... are not printing the three items. Any suggestions much appreciated. Thanks.  Clay

Table styling at the bottom of the page

  
Hi, i am in the process to do a master page with  a table.The problem i am facing now is the footer is not always at the bottom of the page.When the content in the content page holder is shorter, the footer go up a bit to the page.While the content in the content page holder is longer, the footer of the page is at the bottom of the page (which is what i want). Does anyone has idea on how to have the footer  always at the bottom of the page using table ?My code is as below:Cssbody { margin-top:0; margin-left:0; margin-right:0; margin-bottom:0; width :100%; } .SiteHeader { background-color:#292929; My html code is as below:<form id="form1" runat="server"> <div> <table border ="2" width ="100%" cellspacing ="0" cellpadding="0" > <tr Class="SiteHeader" height="113px"> <td valign="middle" align="center" colspan="2"> <%-- <asp:Image ID="Image1" runat="server" ImageUrl="~/Images/top.jpg" />--%> </td> </tr> <tr bgcolor="red" > <td align="right" colspan="2">

Master Page and table layout

  
Hi, i am in the process to learn create master page using HTML table layout.I find out many resources online that use table to design their master page layout.I have 1 thing that i do not undestand:all of them using heigh= n pixel to control their footer, header, content  and navigation menu.My concern is that by doing so, the master page is fixed to only particular resolution only.In future there might be higher resolution available, the master page design need to be changed from time to time which is considered not so good programmer.OR in future, the when site need to have something like "Best view in resolution 1024 x 768", somethign like that...Is there any other way not to do so? Are they doing their master page correctly?

Copy table (with content and links) from one page to another

  
Hi, I'm new to sharepoint and learning this software on my own.  I'm running WinXP Professional.  I've created a table on one page in a subfolder/directory (10Kgold) and would like to use the same table on a page in a different subfolder (24Kgold).  Both subfolders are in the same root folder.  Here are the steps I took: On 10kgold/bracelets.aspx page: right-click on element to copy --> select Copy On 24kgold/bracelets.aspx page: right-click --> Paste On the 24kgold/bracelets page, the "Paste" option was disabled, so then I knew I wouldn't be able to copy/paste the table I copied from 10K gold/bracelets page. I don't want to recreate this table again if I don't have to. Also, I've tried to copy and paste links within the same page, but that doesn't work either. Here are the steps: Select link (yellow-gold) on 10kgold/bracelets page: right-click --> Copy Scroll to where I want to paste the link Right-click (yellow-gold) on 24kgold/bracelets page: --> Paste Is there a way to copy and paste links and tables, etc. from one page to another, with the page/s being in either the same subfolder and/or a different subfolder as long as they are within the same root folder? Thanks in advance for your help.    

How to submit data to a SQL Server database table from a custom page ?

  
Using SPD, I have created a custom page. It has a form with ASP.NET controls textbox, radio buttons, dropdown, submit button etc., Also, I created a Database connection (to the SQLServer database table) under Database Connections. But not sure how to connect this form to the database connection so that when form data is submitted, the data will be inserted into the table.

What is the best way to develop a multi-page Windows Application (i.e. work like a web app - no pop-

  
Hi, I have implemented a toolstrip and want to use this as my menu to change current page (just like a web application). I DON'T want extra forms popping up.    I ask this question as in the past I have always used TAB Control, but now that I'm using the toolstrip I don't require the Tab Buttons themselves. Can I hide these buttons, during runtime. Obviously I only need one tab displayed at a time. I have looked at using a panel, but that means I can't flick between panels during design stage. Any suggestions would be really appreciated. Thanks. John.      

HELP!!! HIDE ONE TEXTBOX IN TABLE HEADER WHEN IT IS NOT IN FIRST PAGE IN REPORTING SERVICES 2005

  
help me plis. this thing drive me crazy. it really should be a simple solution but i cant find it, even with googling. i have subreport that display deposit transaction banking statement from account (customer). this subreport will be accessed through main report that loop all accounts in one branch, so its like a batch report processing for all customer in a branch. rendered to pdf and distributed to all our branchs. since i know that subreports header footer wont work on main report, i decide to move the subreport header into subreport table header and make it looks like it was a report header. but THERE is one problem i cant solve, there is ADDRESS BOX that should only VISIBLE on FIRST page for each customer, along with the other header that always visible. how im i supposed to do? please help. been searching n trying for 3 days and cant find any workin solution. been wondering do i really that dumm @_@ . thanks.   ps: sory for my bad english.  

How to know the number of columns displayed on the last page for Multi column table

  
Hi, How will I determine how many columns to be displayed on the last page of the report if I am using a Multiple column table.  I am going to use the number of columns to multiply with the width of the body of the report. I am going to use a Function to get the product. 

What is the best way to develop a multi-page Windows Application (i.e. work like a web app - no pop-

  

Hi,

I have implemented a toolstrip and want to use this as my menu to change current page (just like a web application). I DON'T want extra forms popping up.   

I ask this question as in the past I have always used TAB Control, but now that I'm using the toolstrip I don't require the Tab Buttons themselves. Can I hide these buttons, during runtime. Obviously I only need one tab displayed at a time.

I have looked at using a panel, but that means I can't flick between panels during design stage.

Any suggestions would be really appreciated.

Thanks.

John.

 

 

 


MVC doesn't work once is published in the WEB, "Error 404 Page Not Found" vs2010 iis7 mvc 2rc2 I up

  

Hi Everyone.

 I'm doing the samething in my two differents pc.

1) Windows 7,  vs2010 rc, mvc 2rc2, .Net 3.5

2) Winodws xp, vs2008, mvc 2rc2, .Net 3.5

My Hosting is in GOdaddy IIS 7, .Net 3.5.

I created a new project in both computers, i build it, i copied the 3 dll's files in the bin folder (System.Web.Mvc,  System.Web.Routing, system.Web.Abstractions), and i publish them...., i go to my website (www.luisbragagnolo) both same problem "Page Not Found"

 I tried many blogs...many advices...nothing yet....

 Any other new Advice people? Thankssssssss


The Group Work Site template has the "What's New" web part on it's home page and I have the follow

  

I can't find that web part as something I can use elsewhere? As in, I can't add that web part on other pages made even on the same site. What would be ideal is to have that web part available to add as needed to other sites/pages of course. As it stands, for me it seems the only place I can use that web part is on the home page of a new "Group Work Site", i hope that I'm wrong. I've tried exporting the web part, but the importing does nothing when trying to import it to other sites, of course other 2010 sites. Please let me know how I may add that web part to my available to use web parts please.

 

:)


Categories: 
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