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.

image

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:

image

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

image

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

SNAGHTML13556bc2

Hope it helps!

4 comments:

  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.

    ReplyDelete
  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

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

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

    ReplyDelete

My Name is..