0

How can I write a log for sharepoint BDC List webpart? I want to know that which sql query bdc list webpart send to the database. Like I am filtering webpart on "Test". So, what would be the sql query? Either SELECT * FROM TABLE WHERE A='TEST' OR SELECT @ FROM TABLE? Is there any way to check what request sharepoint send to my Oracle database?

Which tool I can use for Oracle to check any query request?

Bill the Lizard
  • 398,270
  • 210
  • 566
  • 880
user116627
  • 47
  • 1
  • 9

1 Answers1

0

You can use SQL Profiler to check any query going to the database.

http://msdn.microsoft.com/en-us/library/ms181091.aspx

http://www.eggheadcafe.com/articles/sql_server_profiler.asp

JMD
  • 1,408
  • 11
  • 9