Wednesday, October 17, 2012

How to get to Edit view in SharePoint form

When adding a customized page to SharePoint, I attempted to hide the existing default list view web part by clicking on the web part property in the context menu.  Instead of displaying the web properties so I could hide the list view web part, it was previewing the page instead.  By adding "&pageview=shared&toolpaneview=2" to the end of the URL string in the web browser, I was able to hide the original list view web part through the browser. 

Remember to close your custom form in Designer when hiding the web part or any additional modifications will undo the "hide" property. 

Monday, October 1, 2012

How to gather the syntax for a current process

Here is a query that I use to get the syntax of a currently running process.  It has allowed me to get the syntax for suspect processes without setting up trace/profiler.   

select text
from sys.dm_exec_sql_text((select sql_handle from
sys.dm_exec_requests where session_id = [session id]))