[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 798
  • Last Modified:

SQL profiler Filter

I want to make a trace on my MS SQL 2005 server to be able to see if one specific database still in used by external software.

I know how to filter on the database itself  (Filter on "Database name")
I know how to filter on the Cross database query (filter on "Text data")

how can I create a trace filter whit a "OR" between two filter.

Where [Database Name] = 'xxx' or [TextData] = 'xxx'


Thanks,
0
Cboudroz
Asked:
Cboudroz
  • 3
  • 2
1 Solution
 
Alpha AuCommented:
i cannot found or between two filter.

how about opening two trace and log the result the two db table,

and then select the union result from the two tables?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you only want to know if a database is in use why don't you capture only "Audit Login" event?
0
 
CboudrozAuthor Commented:
alphaau:

I think it's the only solution available

VMontalvao:

what about the cross database query made from another database?  
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You have information about the user, host and application in the Audit Login event. So I think you won't need nothing else.
0
 
CboudrozAuthor Commented:
VMontalvao:

I don't want to see if application connect to the server but if query goes in a specific DB.  Audit Login don't give any info about database connection and don't give me any info about cross database query.



alphaau:

event if you didn't really help me the point goes to you!
0
 
CboudrozAuthor Commented:
no solution look available for "OR" filter, I will used two seperate Trace.

thanks,
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now