Solved

Disable wildcard characters in trace filtering

Posted on 2006-06-13
3
285 Views
Last Modified: 2012-05-05
Hello All,

How should I disable wildcard characters in NOT LIKE filter with trace sp_trace_setfilter or with profiler.
For example I would like to exclude table_ with filter '%table_%'
but not tabletest. How can I use _ (underscore) as a normal character but not wildcard.

With best regards,

Czibok

I need the answer very quickly so I give 300 points for the goal. :)
0
Comment
Question by:czibok
3 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 300 total points
Comment Utility
Hi czibok,

%table[_]%'

Aneesh R!
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now