how to solve the error 19055

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » how to solve the error 19055

how to solve the error 19055

Rate Topic

Display Mode

Topic Options

Author

Message

vijayabaskar_s

Posted Tuesday, September 22, 2009 6:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 20, 2010 12:29 AM
Points: 6, Visits: 17

the error is pasted here when run the SP

sg 19055, Level 16, State 1, Procedure sp_trace_setfilter, Line 1
Filters with the same event column ID must be grouped together.

Please find code part of my Stored_procedure which is giving error.

declare @intfilter int
declare @bigintfilter bigint

set @intfilter = 13
exec sp_trace_setfilter @TraceID, 3, 1, 0, @intfilter

exec sp_trace_setfilter @TraceID, 10, 1, 6, N'%SQL Server Management Studio%'
exec sp_trace_setfilter @TraceID, 10, 0, 7, N'%.Net SqlClient Data Provider%'
exec sp_trace_setfilter @TraceID, 35, 1, 6, N'%MyworksDatabase%'
exec sp_trace_setfilter @TraceID, 35, 0, 7, N'%TempDB%'
exec sp_trace_setfilter @TraceID, 35, 0, 7, N'%Master%'

Now how do i group these events?

Post #791684

Jack Corbett

Posted Tuesday, September 22, 2009 12:16 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:13 PM
Points: 8,185, Visits: 7,966

Did you set up the trace in Profiler and then export the definition or are you trying to create the trace by hand?

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #792084

vijayabaskar_s

Posted Wednesday, September 23, 2009 12:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 20, 2010 12:29 AM
Points: 6, Visits: 17

Yes, I created the trace with SQL Profiler and then exported the trace definition .

now i wanted to sehedule the trace by SQL server Agent Job.

I am able to run the same trace in SQL server Profiler with all the filters applied. it is giving errors when i try to run with Stored Procedures.

Post #792375

« Prev Topic | Next Topic »

Permissions