c# must for projects
error log api log application error tracking
Uncategorized
Get Size of All Tables of MSSQL Database
SELECT OBJECT_NAME(i.OBJECT_ID) AS TableName, i.name AS IndexName, i.index_id AS IndexID, 8 * SUM(a.used_pages) AS ‘Indexsize_KB’ FROM sys.indexes AS i JOIN sys.partitions AS p ON p.OBJECT_ID = i.OBJECT_ID AND p.index_id = i.index_id JOIN sys.allocation_units AS a ON a.container_id = p.partition_id GROUP BY i.OBJECT_ID, i.index_id, i.name ORDER BY OBJECT_NAME(i.OBJECT_ID), i.index_id Next Query: SELECT t.NAME AS TableName, s.Name …
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”); });
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.