.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

Change the order of articles downloaded to subscribers.

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


I have a publication with table T1 referncing T2 with a foreign key relationship. However on the subscriber side T1 is getting downloaded first and then T2. Is there any way that I can change the order by which T2 is downlloade first and then T1. I tried sp_changemergearticle @processing order . But on the subscriber side I am still seeing table T1 downloaded first.

View Complete Post

More Related Resource Links

How do I change the order of column names in EditForm.aspx

I have an Announcements list to which I've added extra columns: Publish (date), De-Publish (date), and Category (choice).  When I go to EditForm.aspx, the columns display in this order: Title , Body, De-Publish , Category and Publish . I'd like to change the order of the columns on EditForm.aspx so that it is Title, Body, Category, Publish and De-Publish . Changing the All Items view doesn't do it. How might I change the order of columns that is shown to the user?

Manage User Profile -- cannot change order

Hi, Is there any reason why I can't change the order of some of the properties in Manage User Profile. E.g  "about me " and "account name". I clicked the move down error, but it doesn't move Please advice, your help would be greatly appreciated.

Change Item order wont work for folder items

Hello. Links lists in Sharepoint 2010 have Change Item Order Action which can order your items. I added new content type based on folder content type to my list. And When I want to order my folder items with Change Item Order action Sharepoint sorts my items randomly. For example with 4 folder items it sorts it right in 3 or 4 times. I can't see any rule in it's behavior sometimes it works sometimes not. For Link list items everything is OK. Anyone have an idea? Thanks.

Change order for list view drop down

I may be overlooking something obvious, but I have not been able to find an easy way to sort the views available in the view drop down for lists.  We're migrating to 2010 from WSS 3.0 and currently, the view drop down is sorted alphabetically.   Help?

How to change the order of Webparts in Sharepoint 2010 wiki pages

In WSS you change the order of webparts just by moving them above or below another webpart. This does not work any longer in SP 2010. I want to move a list webpart above another list webpart. How can I do it [SP2010 Foundation].

Change order of columns in a list


Hi there

I'm looking for a way to change the order of the colums in a list in SharePoint 2010. I only have access to SharePoint Designer 2010 for editing the site.

I already looked at the function to create custom views for lists. However this are only useful when viewing the list as a whole, however when you edit an existing, or create a new entry you will see

  • first: the columns in the order in which they were created.
  • and second: all of the columns. i cant find a way to make certain columns invisible for the user.
I already looked through the functions that are given to me by SharePoint Designer 2010 when editing the columns of a list and I also checked for a way to change the order of the columns when surfing the actual website with Internet Explorer.

Does anyone know how to do this? Or am I just trying to find a function that doesn't make sense because it's covered by another feature?

Thanks for your help!

Change the order of fields in the 'edit properties' screen in a document library?


How can I change the order of the fields in the 'edit properties' screen on a document library?

In a standard list there is an option for 'column ordering'. This option does not exist in a document library! In my document library I have added some site columns to be used for filtering of documents in the library. But I'm not happy with the order they are being added into the 'edit properties' screen. The order looks different to the order that is shown in SharePoint Designer in the doc library when I click the 'edit list columns' link.

Any help much appreciated.


Change the order of list fields on Edit page?


Is there a way to change the order of the fields show up on the edit page (EditForm.aspx) and new page (NewForm.aspx)?  I know the fields can be reordered in views. 

How to change the chronological order of blog commets



We have a requirement where we have to show blog comments in reverse chronological order than what SP2010 OOTB provides. Is there a way to do so.This is urgent as we have a demo to our customer this friday.




Change the order for upload: 1st fill the form and then upload the file



I would like to change the order for upload: 1st fill the form and then upload the file.

THanks in advance


Change in transaction replication articles without enabling the enable Schema Replication to true


We have a transactional replication database where in we have set the schema change property to false. Now we have added a new column and to the table and wanted this column also to be replicated. But before enabling the allow schema replication parameter, we have altered the article added a column.

Now we reliazed that we have not enabled the sehema replication option. The database is very large and reinitializing the subscription remains our last option.

Could anyone suggest us the right way forward.

Thanks in advance.


How to Localize Windows Forms and Change the Language at Runtime

Localization is the process of customizing your application to a particular language, culture or locale. Visual Studio provides support for localizing Windows Forms with much ease. In this article, we will see how to localize windows forms and give the user the ability to change to his preferred language at runtime.
When you run a localized application, the appearance is determined by two culture values. The UICulture property is used to specify which resource files will be loaded for the form. The Culture property, on the other hand, determines how strings such as dates, numerals, and currency amounts are formatted.
Let us see the steps required to create a localized form. You can then expand this example and adopt the same approach for the rest of the forms in your project

Selected to change the background color of the page



As this site, http://www.borfin.com.tr/genel/Default.aspx, How can I change the background color selected pages.

Bug: Does not change column type from nvarchar to ntext


Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.

Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.

How to change the default page base class?


I've tried setting the <pages pageBaseType="DynamicWebPage" /> value in web.config, but when I response.write out the page type, I'm still getting Microsoft.WebPages.WebPage.

I'm simply trying to sub-class WebPage and add some additional functionality such as a dynamic PageData dictionary similar to Phil Haack's dynamic ViewData dictionary.





Is it possible with SQL sorted in descending order according to the word?
In Table I shrajeno Mastercard, Visa, Diners etc ...

All Visa are the first in the order, another Mastercard, etc. ...

Something does not work: ORDER BY PaymentType = 'Visa';

I would not want to work in one field PaymentId (111,222,33, etc. ..) and then use the ORDER BY.

Is this possible in such a way?

Linq qry with order by basic questions


I have never tried a group by with linq, now I do and I'm stuck.

I try to convert this sql statement to its linq counterpart :

SELECT COUNT(tb_Mailer_Smses.Id) AS [cnt], tb_Mailer_mailing.Id As [Id]
,SUM( CASE WHEN tb_Mailer_smses.DLRStatus = 200 THEN 1 ELSE 0 END) As [Delivered]
FROM tb_Mailer_mailing INNER JOIN
tb_Mailer_Smses ON tb_Mailer_mailing.Id = tb_Mailer_Smses.MailingId
WHERE tb_Mailer_mailing.ApplicationId = 1
GROUP BY tb_Mailer_mailing.Id

Is there some one who can me show me the convertion process ?

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