Solved

SQL profiler Filter

Posted on 2010-08-18
6
746 Views
Last Modified: 2012-05-10
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
Comment
Question by:Cboudroz
  • 3
  • 2
6 Comments
 
LVL 7

Accepted Solution

by:
Alpha Au earned 250 total points
ID: 33473106
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
 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 33474761
If you only want to know if a database is in use why don't you capture only "Audit Login" event?
0
 
LVL 7

Author Comment

by:Cboudroz
ID: 33474793
alphaau:

I think it's the only solution available

VMontalvao:

what about the cross database query made from another database?  
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 33474830
You have information about the user, host and application in the Audit Login event. So I think you won't need nothing else.
0
 
LVL 7

Author Comment

by:Cboudroz
ID: 33476205
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
 
LVL 7

Author Closing Comment

by:Cboudroz
ID: 33476227
no solution look available for "OR" filter, I will used two seperate Trace.

thanks,
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question