Month: June 2018

For Fixed Header Sample Code

<table class=”table table-striped table-fixed-header table-hover ” id=”reportContent “> <thead id=”pageHeader” class=”header”> <tr> <th colspan=”2″ width=”100px”>&nbsp;</th> <th width=”100px”>Ledger Code</th> <th>Ledger Name</th> <th width=”100px”>Debit</th> <th width=”100px”>Credit</th> </tr> </thead>

Madhyapur Hospital Backup Plan

Application/Files/Database to backup SN Application Description Runtime User Uploads Database 1 Main MIS Web Application Yes Yes Yes 2 Desktop Application Yes No No 3 Payroll Application Yes Yes Yes 4 Inventory Application Yes No Yes 5 Main MIS Web Application [2073] Yes No Yes 6 Old Record Check Application Yes Yes Yes

Fix User Server Principal authentication error after db restore

use database_name; — ALTER DATABASE database_name SET READ_WRITE ——– Reset SQL user account guids ——————— DECLARE @UserName nvarchar(255) DECLARE orphanuser_cur cursor for SELECT UserName = su.name FROM sysusers su JOIN sys.server_principals sp ON sp.name = su.name WHERE issqluser = 1 AND (su.sid IS NOT NULL AND su.sid <> 0x0) AND suser_sname(su.sid) is null ORDER BY …

Fix User Server Principal authentication error after db restore Read More »