Sunday, 29 June 2014

CRM 2011/ 2013 SQL Query When Debugging Plugin

When you are debugging a plugin, then you want to do SQL Query, you will realize that you will find a deadlock and the SQL will be keeping executing and executing.


After you stop or finish your debugging, it will give you the result, but during the debugging, those queries would be keeping executing, executing, and executing.

To make it enable to you to query during plugin debugging, please add with (nolock) syntax in your Query after the from table syntax

For example:
select * from Opportunity with (nolock)

And here is the result:


And it is also help you to see the record that has been created, even though you are debugging in the PostCreate Plugin event.


When you see in the SQL,
it is actually you can see the record has been created after debugging completed:


Hope it helps!


  1. Did you know that you can earn cash by locking premium pages of your blog or site?
    Simply join AdWorkMedia and embed their content locking widget.

    1. Great Article Cyber Security Projects projects for cse Networking Security Projects JavaScript Training in Chennai JavaScript Training in Chennai The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

  2. Credit score score reporting isn't always something however oracle fusion procurement manner in which viable avail with options to offer the customer or the industrial organization company with all of the credit score and debt data
    thank for sharing use full information
    oracle fusion procurement online training
    oracle fusion procurement training

  3. Hi,
    This is a very interesting topic.Thanks for sharing such a nice topic.
    oracle fusion SCM online training

  4. hi,
    this is very informative post.
    Thanks for sharing such a nice post.
    oracle fusion HCM training.

  5. Want To Increase Your ClickBank Traffic And Commissions?

    Bannerizer made it easy for you to promote ClickBank products with banners, simply visit Bannerizer, and get the banner codes for your favorite ClickBank products or use the Universal ClickBank Banner Rotator Tool to promote all of the available ClickBank products.


My Name is..