Executing the query “ALTER INDEX [cndx_PrimaryKey_WorkflowLog] ON [dbo]…” failed with the following error: “The index “cndx_PrimaryKey_WorkflowLog” (partition 1) on table “WorkflowLogBase” cannot be reorganized because page level locking is disabled. Summary: Recently one of my server index reorganize job start failing. I checked the index name and then enable the page level locks on that
In this post we will learn how to store hashtable in session. By storing values in hashtable & then transfer them to a new page with session is easiest way. ASP.NET session state lets you associate a server-side string containing state data with a particular HTTP client session.Session is defined as a series of requests
10 Greatest Tricks for iPhone In this post I will tell you some of greatest tips, tricks, hacks and secrets of using iPhone. I am using iPhone since iPhone 4 and now upgraded to iPhone 6. In these years i have learnt a lot of useful and handy tips & tricks of using iPhone. 1.
The specified report server URL could not be found.Verify the syntax of the URL and that the report server exists. Hi friends yesterday I got a call from my remote team, that they are not able do deploy reports on report server from their system. They told me that error they are facing is: The specified
Reports cannot be run because the Connector for Microsoft SQL Server Reporting Services, a required component for reporting, is not installed on the server that is running Microsoft SQL Server Reporting Services. Hi friends, today I had received an error on Microsoft Dynamics CRM 2011, it seems like some issue with CRM reporting extension. I
Index cannot be reorganized because page level locking is disabled Hi Friends, recently my Index reorganize job is failed. When I checked about error: “The index “cndx_PrimaryKey_AsyncOperation” (partition 1) on table “AsyncOperationBase” cannot be reorganized because page level locking is disabled.”. Solution: A DBA can resolve the above error message by enabling Page Level Locking on the index
SQL Server DBA Interview Questions & Answers Q: What are indexes and how much non-clustered indexes are there in SQL Server 2008 R2? Ans: An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. 999 non-clustered indexes in SQL Server