The index cannot be reorganized because page level locking is disabled

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

Store Hashtable in Session

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

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.

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

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

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

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