Fix user, Role already exists in mssql db
Whenever we restore db but user doesn’t exists and user is created after db restore only. following error appears. sp_change_users_login ‘AUTO_FIX’, ‘coop_sahakari_paanch’
MVC5 Async RedirectToAction
use Async Task Run for async return redirecttoaction return await Task.Run<ActionResult>(() => { return RedirectToAction(“MultipleLoanEODFix”); });
Some useful Commands for Check and Maintain MSSQL Database
— Shrink Database DBCC SHRINKDATABASE (AdventureWorks2008R2, TRUNCATEONLY); — Rebuild All Index on a table ALTER INDEX ALL ON Production.Product REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = ON); — Reorganize all indexes on the HumanResources.Employee table. ALTER INDEX ALL ON HumanResources.Employee REORGANIZE ; — Check DB for database consistency DBCC CHECKDB — Reclaims …
Some useful Commands for Check and Maintain MSSQL Database Read More »
Basic Pattern for application
PDF File Link: App Pattern Use AsyncControllers Use await, ToListAsync, SaveChangesAsync, FindAsync
Configure Email in outlook and other email client software
Manual Settings If you do not see an auto-configuration script for your client in the list above, you can manually configure your mail client using the settings below: Secure SSL/TLS Settings (Recommended) Username: info@shresthansons.com.np Password: Use the email account’s password. Incoming Server: host.outsourcingnepal.com IMAP Port: 993 POP3 Port: 995 Outgoing Server: host.outsourcingnepal.com SMTP Port: 465 …
Configure Email in outlook and other email client software Read More »
Merry Christmas 2015
A Merry Christmas to you, our cherished partner. We’re sending you and your family heartfelt wishes for peace, joy and abundance this Holiday Season.
Bootstrap sample website with responsive jcarousel
Here is our sample website that we have done for our client. URL: http://projects.outsourcingnepal.com/bootstrap_sample/
Responsive jquery jcarsouel
Response websites means those sites that act as per user activities like chaiging the display on fly as user goes on changing the browser size, moving mouse and other events. We ho have often use jquery jcarusel that’s useful for showing image thumbnails, but its really hard to find the responsive jcarousel. We do have …
MS SQL Server Pivot as an alternate for MS Access Tranform
Usually from small application development to large application development for single user based applications, I find MS Access considerabily easy and powerful. One good proven table design can be a good starting point for autogenerating good working forms, queries as well reports. Apart from default auto reports I find cross tab reports of ms access …
MS SQL Server Pivot as an alternate for MS Access Tranform Read More »
Importing Hotmail Contacts Via PHP
We do have come across openinvitor and other system but found problem while interacting with hotmail or live. So we made a search and found a pretty useful website with old script. Tried in local it worked. Tried in server got error: Warning: fsockopen() [function.fsockopen]: unable to connect to messenger.hotmail.com:1863 (Connection timed out) Aaahhh… its …