Solution for MSDTC Error While Submit Account of Point of Sale in SQL 2008R2

1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.
2. In SQL Server Configuration Manager, click SQL Server Services.
3. In the details pane, right-click the name of the SQL Server instance for which you want to change the service startup account, and then click Properties.
4. In the SQL Server Properties dialog box, click the Log On tab, chose Built in Account and select Local System as account type.
5. After selecting the new service startup account, click OK.
   A message box asks whether you want to restart the SQL Server service.
6. Click Yes, and then close SQL Server Configuration Manager.

RemoveRow Editing Limitation In SQL2008

In SQL Server 2008 Management Studio Express , we can change the default settings that allows to edit more than the 200 rows at a time, or select more than 1000 rows.
To modify the “Edit Top 200 Rows” or “Select Top 1000 Rows” settings do the following:
1.Run the SQL Management Studio Express 2008
2.Click the Tools -> Options
3.Select SQL Server Object Explorer . Now you should be able to see the options
*Value for Edit Top Rows Command
*Value for Select Top Rows Command
4.Give the Values 0 here to select/ Edit all the Records

5.Now we can see the Edit All and Select All options on the table.

RNet Communication Error Solution

Problem : 
While running RNet communciation, the following error mesage

"The channel " http  is not registered with remoting services"

Solution :

Do the following steps to rectify this problem


1. Go to the folder C:\windows\System32\drivers\etc ( if you have installed windows on D partition then the path will be like D:\windows\System32\drivers\etc)


2. Open the file “Hosts” file using notepad
3. There will be an entry like the following inside the hosts file
127.0.0.1 localhost


Add one more entry below.


218.248.43.143 regnnet.ptcmysore.gov.in