December 23, 2003 03:23 PM

Tracking Extended Stored Procedures in Profiler

Rating: (0)
SQL Server Magazine
InstantDoc ID #40964

I want to track the usage of extended stored procedures within a particular application. The Object Type data column sets a filter within SQL Server Profiler. And the Help file entry for the Object Type data column filter says that the value in the column represents "the type of the object involved in the event," which I assume corresponds to the Object Type column in sysobjects. So, a value of 'X' (the extended stored procedure's value for the sysobjects.type column) should represe...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Excellent. BOL SP3a is also wrong in Security Audit Event Category in that it says ObjectType is tracked for the AuditObjectDerivedPermission event; it's really the AuditObjectPermission event as Brian states.

Kevin Bailey 6/8/2004 11:42:10 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS