Pages

Tuesday, January 15, 2019

Recovering the suspected SharePoint 2013 Config database

Issue:

Central Administrator site not accessible.



Open SQL Server -- New Query, run these command to repair the SharePoint config database.




— Use the Master database 
Use Master

— Verify that database has issues 
EXEC sp_resetstatus 'SharePoint_Config'

— Put the database in emergency mode 
ALTER DATABASE SharePoint_Config SET EMERGENCY 
DBCC checkdb('SharePoint_Config')

— Set the database in single user mode 
ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE

— Repair the database with data loss 
DBCC CheckDB ('SharePoint_Config', REPAIR_ALLOW_DATA_LOSS)

— Set the database in multi-user mode 
ALTER DATABASE SharePoint_Config SET MULTI_USER

— Verify that database is reset 
EXEC sp_resetstatus 'SharePoint_Config'

Friday, January 11, 2019

Sharepoint Online - Quick Edit supports JS Link and Client Side Rendering

The sharepoint online list quick edit (Data Sheet View) would support Client Side Rendering Code (CSR).

when I renamed a file to become “kar.txt” it turns the background green &  text white colour tag.   This could be leveraged to give end users real-time feedback on the values entered.   Unlike a JQuery page load event which only triggers once, this triggers per row as values are changed.

 Upload JS file to Site Asset library and Provide in the following

~site/SiteAssets/CSSQEdit.js