Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server event tracing
Message
From
24/09/2002 16:30:53
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL Server event tracing
Miscellaneous
Thread ID:
00703985
Message ID:
00703985
Views:
50
I'm trying to get SQL Server to do event tracing. when I execute this line in Query Analyzer (I already executed sp_trace_create and got back 0 as the trace ID)

exec sp_trace_setevent 0, 14, 4, 1

I get back

Procedure expects parameter '@on' of type 'bit'.

The help files say that on is the 4th parameter, and that bit constants are to be expressed as 1 or 0 with no quotes. What gives?
Randy Hersom
President, Habilitation Software Inc.
Next
Reply
Map
View

Click here to load this message in the networking platform