Tuesday, July 21, 2015

How to change the password of a SQL Server login

How to change the password of a SQL Server login 

(Enterprise Manager)

To change the password of a SQL Server login

  1. Expand a server group, and then expand a server.
  2. Expand Security, and then click Logins.
  3. In the details pane, right-click the login to modify, and then click Properties.
  4. In the Password box, on the General tab, enter a new password.
  5. Confirm the password.

Follow the steps below to reset the "SA" password if you have forgotten what it was set to: 

Step 1: * Go to the server that SQL Server is running on. * Open Enterprise Manager(Start -> Programs -> Microsoft SQL Server) * Right click on the SQL Server and select "Edit SQL Server Registration Properties" * Select "Use Windows authentication" and select OK. 

Step 2: * Once connected, select Security * Right click on sa and select properties * Reset the password.

Unable to open system drive in Windows

Some time when we right click on drive C: a window comes up; Open with: Chose the program you want to use to open the file. In such situation we are unable to open C drive but we can explore C drive using right click.This is because of autorun.inf file.

Solution 1:

  • Double-click on My Computer on Desktop.
  • Choose Tools and select "Folder options"
  • Click on "View" tab, select and untick "Show Hidden files and folders" and "Hide Extention...." then click on apply.
  • Back to "My Computer" right click on C drive and select explore then you will see "Autorun.inf" delete the file.
  • Go back to "Folder options" Click "View" Tab, select "Restore
  • Defaults" and click on "Apply".
  • "Restart" your Computer. 

Solution2:

  1. Open Command prompt (Start-> Run-> CMD) 
  2. Type the following
  3. attrib -r -s -h c:\autorun.inf
  4. del c:\autorun.inf

Delete Duplicate COD in Postman 7.9 by CEPT

Delete Duplicate COD Solution given by CEPT

In most of the Time while fetch COD articles in Postman 7.9 it shows an duplicate entries of Same COD Article message.
Solution given by CEPT, Mysore.

Solution

Delete COD Articles Appearing more than Once @ Invoicing.. 
  1. Download attached Script Provided by CEPT.
  2. Execute Script using MM Script Tool, before Invoicing

Download


Download

ENHANCEMENT OF COMMISSION TO KVP IN SANCHAY POST

 Enhance of commission to KVP in Sanchay Post

vide SB Order No : 8/ 2015 dtd 10th July 2015

1. Login as Super in Online Module >>>> Initialization >>>> Init Comisn,TDS Amount (form No 0412) >>> New Form

2. In ‘Initialise Agent Commission & TDS Amount’ window, enter the details(as shown below)

3. Click ‘SAVE’ button