Get Executed Query for Specific Date

Page 1 of 1

2 Replies - 710 Views - Last Post: 14 August 2012 - 09:12 AM

#1 visweswaran28  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 36
  • Joined: 29-October 09

Get Executed Query for Specific Date

Posted 14 August 2012 - 09:04 AM

HI,

I want to retrieve list of executed query for a specific date in sql server.

Thanks in Advance
Is This A Good Question/Topic? 0
  • +

Replies To: Get Executed Query for Specific Date

#2 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 200
  • View blog
  • Posts: 1,523
  • Joined: 12-January 10

Re: Get Executed Query for Specific Date

Posted 14 August 2012 - 09:11 AM

ok you have just told us absolutely nothing.

post the query you made and we can help other then that your on your own.

use [code] tags
Was This Post Helpful? 0
  • +
  • -

#3 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 6430
  • View blog
  • Posts: 23,409
  • Joined: 12-June 08

Re: Get Executed Query for Specific Date

Posted 14 August 2012 - 09:12 AM

You'll need some third party tool, attach a trigger to each table, or turn on the profiler and ship that information to a file. (That last one will kill performance)
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1